Syncing Manager from ODBC to Active Directory2017-06-04 16:28:32
When using an ODBC to Active Directory (AD) connection to sync ‘Manager’ there are a few special configuration requirements.
The following are required for Create, Join or Both (Create and Join):
Each record in your Source data must contain an employeeID and a managerID. Further, the managerID must be the employeeID of the named manager.
In the below sample data, you can see how Rhonda’s employeeID correlates with John’s managerID. Rhonda is John’s manager.
In order to perform a sync using this Source ODBC data to a Destination AD, you will need to configure these items in your ODBC-to-AD connection:
- On the Source tab, ‘Field Definition - Index’ should be set to: employeeID
- In a custom map file, add the following custom mapping:
Also note, you will need to run your connection twice as some Manager values may not be set on the first connection run, depending on the order each record is processed.
In addition to the above, the following are further requirements related to the use of Sync/Join mode Join or Create/Join:
You must enter a valid LDAP query. This query may compare one or more Source attribute values to one or more Destination attribute values. Please see this knowledge base article for more information on Join Queries but, keep in mind, for ODBC to AD you will need to substitute values from your ODBC Source data. Contact email@example.com for assistance.
Note: If this is a Both connection, be sure to include the mapping to set samaccountname from the source login:
fullNname: Smith, John firstName: John lastName: Smith login: jsmith employeeID: 00111 department: Sales state: VA postal: 23464 title: Associate city: Virginia Beach company: ACME Corporation country: USA managerName: Jones, Rhonda managerID: 00222
fullName: Jones, Rhonda
city: Virginia Beach
company: ACME Corporation
managerName: Miller, Paul