1 Reply Latest reply on Nov 1, 2013 11:31 PM by Ayush Ganeriwal-Oracle

    ODI Integration With Microsoft Active Directory to bring User id to Table

    Gourav Atalkar(ELT)

      Hi All,

       

      I have to bring the USER Id of  Employees from the Microsoft Active Directory based on the Mai id of the user.

      I have a table like below:

       

      User_nameMail_id
      Vishwasviv.123@sft.com
      Johnjohn123@sft.com
      Depakdeepak.123@sft.com

       

      I need to bring the User id of that employees from Active Directory and load it to another table

       

      Now the Issues is What are the Things i have to perform in ODI to do this:

       

      I have gone through some of the Blogs for the same but every where i found using ODI for External Authentication.

       

      Can i get the User Ids in a relational tables so that i can join it with above table and load it to target ?

       

      Please let me know if any body have the solution for it

       

      Thanks

      Regards