LDAP To SQL using Forefront Identity Manager
Hi, we have a requirement to migrate the user details from LDAP server to SQL server using the FIM interface. Can anyone help on this? Thanks RMAKR
March 24th, 2010 9:32am

Depending on the type of LDAP server you can use an OOTB management agent in FIM to read in the LDAP objects. If there is not an OOTB management agent then you can use the OpenLDAP XMA. To export to SQL server you can use the OOTB SQL management agent. You'll face a challenge if you need to migrate the password since it is probably stored as a hashed value. There are documents on TechNet that will help get you started: http://www.microsoft.com/downloads/details.aspx?FamilyID=11FB01BC-94A9-4404-BB90-CECA1A206E32&displaylang=en CraigMartin Edgile, Inc. http://identitytrench.com
Free Windows Admin Tool Kit Click here and download it now
March 24th, 2010 8:02pm

You will also have to pay attention to your specific schema on the LDAP server and make sure you have a compatible schema within SQL. Basic single value attribute to attribute mapping is straightforward, but if you multiple value attributes or reference attributes it will require some thought.
March 24th, 2010 8:25pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics