LDAP Import

Guide to install the LDAP Import component in order to use LDAP as your person source.

The LDAP Import component is offered as an additional download and is free to use for all SMTX customers. Please be informed that basic LDAP knowledge is required and that you may need to request assistance from your LDAP/AD expert within your organization.

The LDAP Import application will extract all personal data from LDAP and store that information in a temporary table (within the SSP database). After succesfully loading all persons from LDAP, the data is move to a final table (also within the SSP database). That final table will hold all persons loaded from LDAP, with all properties configured to download from LDAP. The final table can be used to use as the source for the bulk import query.

• Download the LDAP Import app from https://software.smt-x.com/SSP/LDAPImport/

• Download the example file settings.json for reference

• Make sure the downloaded ZIP file isn't blocked by Windows (check file properties)

• Extract the ZIP file to a temporary folder

• Execute this command within the temporary folder: SMTX.LdapImport.ConsoleApplication.exe configure

• This application will now ask a number of questions. The answers will be used to build a settings.json file in the temporary folder

  • If you don't know the answer immediately, feel free to enter dummy data, you can always update the settings.json file manually.

• Write down the name of the final import table

• Go to SSP Admin >> Adapters >> Person Data and go to the section "User Account database query".

  • Connection Type is Internal

  • Connection string is empty

  • Single user synchronisation query should query the final import table as configured earlier

    • Example query: SELECT [FirstName], [LastName],[Email], [UniqueId] as [Login_Long] FROM LDAPImportFinal WHERE [UniqueId] = '{0}'

  • Bulk import query should also query the final import table.

    • Example query: SELECT [FirstName], [LastName], [Email], 1, [UniqueId] from LDAPImportFinal