Category:ODBC
Last Updated:2010-05-26
When using an ODBC to AD connection to sync 'Manager' there are a few special configuration requirements.
The following are required for Create, Join or Create/Join:
Each record in your source data must contain an employeeID and a ManagerID.
Further, the ManagerID must be the employeeID of the Manager.
In the below sample data, you can see how Rhonda's employee_id correlates with John's manager_id. Rhonda is John's manager.
In order to perform a sync using this source odbc data to a destination AD, you will need to make the following configurations in your ODBC-to-AD connection.
1) On the Source tab, 'Field Definition - Index' should be set to: employee_id.
2) In a custom map file, add the following custom mapping: Manager=#manager_id#
Also note, you will need to run your connection TWICE as some Manager values may not be set on the first run through, depending on the order each record is processed.
In ADDITION to the above, the following are further notes related to the use of a Create/Join or Join Only:
1) On the Destination tab, the Source Index NEED NOT match your Source tab Index (although it may if appropriate).
2) On the Destination tab, you should select a Source Index and Dest Index which identifies valid matches between your source database and the destination AD. For example:
Source Index: login
Dest Index: samaccountname
** If this is a Create/Join connection, be sure to include the mapping to set samaccountname from the source login: samaccountname=^login^
Sample Data:
full_name: Smith, John
first_name: John
last_name: Smith
login: jsmith
employee_id: 00111
department: Sales
state: VA
postal: 23464
title: Associate
city: Virginia Beach
company: ACME Corporation
country: USA
manager_name: Jones, Rhonda
manager_id: 00222
full_name: Jones, Rhonda
first_name: Rhonda
last_name: Jones
login: rjones
employee_id: 00222
department: Sales
state: VA
postal: 23464
title: Manager
city: Virginia Beach
company: ACME Corporation
country: USA
manager_name: Miller, Paul
manager_id: 00333