Skip to main content
Version: 1.23.3

Example of the integration with AD

The "out-of-the-box" solution contains an example of the connection to the Active Directory (AD) service.

Check out the examples mentioned below before setting up the LDAP import on an instance. The settings of the examples are protected from changes. In the burger menu of each record, click Make a copy to copy the example settings and change their values.

The following records are created and configured:

  • the Demo_Active_Directory LDAP Server with the LDAP URL example. In your copy, specify the parameters of the server.
  • the SimpleOneCourses1 and SimpleOneCourses2 LDAP Settings. Use one of these definitions as an example to create a working connection with the AD service.

Description of the field values

  • Filter – the filter that selects user records with any username to import from the AD service.
Value
(&

 (objectClass=person)

(sn=*)

)
  • Query field – the field that is used for connecting with the AD and querying the records.

Value: sAMAccountName

  • Attribute list – the attributes the LDAP query returns.

Value: samaccountname,sn,givenname,distinguishedname,msDS-cloudExtensionAttribute6,telephonenumber, mobile,mail,manager,company,useraccountcontrol,thumbnailphoto

  • the LDAP Users Import Source. Use one import source for the same LDAP settings.
  • the Daily Import SimpleOne Employees and Daily Import SimpleOne Employees 2 scheduled imports. The AD data is imported daily at a specific time. Use one of the imports as an example to create your scheduled import.
  • the Daily Deletion of Obsolete Import Sets scheduled script. The script deletes inactive import sets. When an import set is deleted, a cascading deletion occurs for the Import Set column of the Import Set Row table.

To connect and import the users from the AD service, complete the following steps:

  1. Create a local pack in the Simple application for the LDAP import settings.
  2. Create copies of records mentioned above and set up the LDAP integration by changing the field values to the required ones.
  3. Click Test connection in the LDAP Server record. If the connection is established successfully, click Browse LDAP to check the LDAP structure.
  4. After you checked the structure, go to the LDAP Setting you need and open the related import source.
  5. (optional) Click Test Load (20 records) to create a test import set.
  6. Click Load all records.
  7. Click View Transform Map to create a Transform Map record. The Target Table value should match the value of the Table field in the LDAP Settings record.
  8. On the Transform Map create Field Maps through the related list. The Login and Email field map records should have the selected Coalesce checkbox. The parameter defines the fields of the target table that will be used to search for the records based on the imported data. If a record is found in the target table, it will be updated. Otherwise, a new record will be created.
  9. Go back to the Import Source record and open the Import Set record via the related list.
  10. Click Transform to import data from the AD service.
  11. Configure the copy of the Daily Import SimpleOne Employees scheduled import. Add the reference to the created Import Source.
  12. Configure the copy of the Daily Deletion of Obsolete Import Sets scheduled script and select the Active checkbox. Copy the ID of the Import Source to the import_source_id variable of the script.