Update the Manager Attribute

The following article will explain the steps you need to follow to assign managers to users within your Active Directory.

Set ReadOnly

By default the Manager attribute is set to ReadOnly=True, in order to update this you need to set ReadOnly to False. If TryParseValue is not already set to False, please update this too.

You can do this by going to the connection properties window and then Properties. Click onto the ellipsis (...) to open the properties collection manager.


Then find the manager attribute in the list and change the values.

Manager Properties

Once you are done, please refresh your target data source by using the refresh button.

Refresh Data Source

If you preview the data you will notice that the distinguished name of the manager is returned e.g. CN=User,OU=Test,DC=demo,DC=simego,DC=com. This is how we need to present the manager record in Data Sync to Active Directory. We can return the distinguished name by using a lookup to AD in a calculated column.

Calculated Column

An example of a lookup function to find the Distinguished Name of the manager is:

LOOKUPB("Distinguished Name", "", WHEN("EmployeeID", ReportsTo))

This function looks up the distinguished name when the EmployeeID attribute matches the value in the ReportsTo (manager) column of the source data.

Manager Lookup

You can find more details on Lookups in Active Directory here, such as looking up managers in different OUs.

You then need to map this result to the Manager record in the schema map.

Schema Map