Table of contentPrerequisites
LDAP ConnectorThe LDAP Import Connector is DM-ETL+'s connector to a LDAP (Lightweight Directory Access Protocol) directory. It's possible to connect to multiple LDAP within the same connector, this has the advantage to merge attributes from several objects to the same Diagram. In Windows server 2005/2008, LDAP is the primary way the Operating System accesses the Active Directory database.
- A working and technically accessible server with the Active Directory Domain Services role installed
- User/Login information that can be used to access the Active directory Domain Services database (with sufficient rights for the tasks that you will be using it for)
ConfigurationSee Figure 1.
- Open a new or existing solution and from the import menu, select LDAP to add it to the solution.
- Double click the LDAP connector title to open the LDAP main window
- Click the Node Properties button on the top of the screen.
- Click the Add button.
- Entry of the directory store.
- Example: "LDAP://CN=<group name>, CN =<Users>, DC=<domain component>, DC=<domain component>,...".
- If you would like to connect to a specific server, set the server name before the container definitions.
- Example, "LDAP://<server>/CN=<group name>, CN =<Users>, DC=<domain component>, DC=<domain component>,...".
- To bind to the current domain using LDAP, use the path "LDAP://RootDSE", then get the default naming context and rebind the entry.
- The "Port" specifies the port number to be used for the connection. The default port number is 389. If an SSL connection is used, you should set this value to or 636.
- Max. Result
- The "Max. Result" defines a maximum result set. The default value is 0 meaning the entire result.
- The "Filter" specifies the attributes to be retrieved within the search scope of the RootPath
- The following table lists the filter operators:
|=*||(name=*)||All entries that contain a name attribute.|
|=||(o=scope4mation)||All entries in which the organization name is scope4mation.|
|~=||(givenName~=Steve)||All entries with a givenName that's like Steve. The directory server might also return Steven as givenName.|
|>=||(givenName>=St)||All entries with 'St' and appearing after 'St'.|
|<=||(givenName=<St)||All entries with 'St' and appearing before 'St'.|
|*||(o=Scope*)||All entries with a organization name start with 'Scope'.|
|&||(&(o=Scope4mation)(co=nl)||All entries in which the organization name is 'Scope4mation' and the country is 'nl'.|
||||(|(o=Scope4mation)(givenName=Steve))||All entries in which the organization name is 'Scope4mation' or the givenName is Steve|
|!||(!(STREET=*))||All entries that do not contain a StreetAddress attribute|
- Use alternative credentials
- Check this option to use alternative credentials.
- Use this option when the current logged in account does not have sufficient rights
- If the use alternative credentials option is checked then this field must contain the username that has sufficient rights.
- If the use alternative credentials option is checked then this field must contains the password corresponding to the entered username.
- LDAP://ADServer1/ DC=demo, DC=scope4mation, DC=nl
- Note: (server= ADServer1 and domain= demo.scope4mation.nl)
- LDAP://ADServer1/CN=User, DC=demo, DC=scope4mation, DC=nl
- Note: Server = ADServer1, Container = Users and domain= demo.scope4mation.nl
Figure 4Once all information has been entered click the Test button to test the connection. If the connection is successful press the OK button to save the connection. Then press the OK button to save and close the LDAP properties window. In the top of the screen press the Connect button to connect to the directory server. Once a connection is established the Directory Server entries should be visible.
Figure 5To create a result set, select the desired containers of the Directory Server in the tree by selecting the check boxes on the left side of the screen. Select the fields from the attribute list on the right side of the screen to retrieve the attributes. To show a preview of the Directory Server result set press the Import button to collect the data and press the View Last button. After the required information has been imported press the Save button to save the result. The data is now ready to be used as an input in diagram tasks.