Imanami Community

Identity Management by Group Management = Faster Results
Welcome to Imanami Community Sign in | Join | Help
in Search

Updating Manager attribute

Last post 01-06-2009, 7:38 AM by henrychan. 2 replies.
Sort Posts: Previous Next
  •  01-03-2009, 9:36 AM 835

    Updating Manager attribute

    I'm being provided our company's employee information from an HR system (Oracle table) and it contains the usual fields: employee name, employee ID, title, dept, manager, etc. The manager field is in the format "FirstName, LastName".  How can I update the manager attribute in the user's AD account?  I believe a transform is needed to reformat the manager's name into LDAP/DN format and then it should be checked as an existing valid user account in AD to ensure referential integrity?  Can anyone help with this?  I'm not a great VBScripter - is there an existing script out there I can clone?

    Thanks!

  •  01-05-2009, 1:32 PM 836 in reply to 835

    Re: Updating Manager attribute

    I was able to accomplish this relatively easily by using an add'l field from the source and then performing a resolve function in AD to populate the 'manager' field.  Each employee record in our Oracle HR DB has an attribute for not only their own EmployeeID, but for that of their supervisor.  Our Oracle people simply made that 'supervisorID' attribute available in the view they constructed for our synch.  A resolve/lookup is performed against the employee's 'supervisorID', which (in the DTM resolve) maps to the 'employeeID' of the supervisor in AD.  Once this <supervisor's> employee ID is resolved, the value is returned (in DN format) and populated into the 'Manager' field as a normal 'Lastname, Firstname' format in the AD User Object. 

    This is dependent on the 'employeeID' being populated for every user, but once it's there, it works like a charm.  I'm assuming you're setting this up be able to handle ongoing updates/changes.  Once you get this running any changes/updates in the HR DB are automatically reflected in AD the next time the DTM job runs.  There was NO scripting in this.  Just use the 'resolve' function and make sure you tell DTM that the supervisorID <source> is actually their employeeID <target>, and THAT's what you want to pull from and populate into the AD 'manager' field. 

    Good Luck!

    • Post Points: 0
  •  01-06-2009, 7:38 AM 839 in reply to 836

    Re: Updating Manager attribute

    Great idea! And no scripting - I like it!  Thanks much for the suggestion.
View as RSS news feed in XML
Powered by Community Server (Personal Edition), by Telligent Systems