How can I configure LDAP node in IPA 10.1.1.76.5425 to retrieve data from our AD?
Once it is set up in Configuration console then how do you use the Node. I am looking to update employee emails from AD to GHR. So I have a SQL query that grabs all the employees without emails, however, I need to compare them based on User = actor or employee ID....have it in my flow that use to read from an database table we had for Outlook emails, and that worked find until the database team decided we didn't need that database any longer because the information was already in AD. Now i have to update all employees without emails in landmark to the email they were given in AD. Any ideas on how to use the node? I have the LDAP configured in LTM/GHR already.
I think the only effective way of doing this is for AD to also contain a unique Identifier you use in GHR, we use the EmployeeID field in AD to make that link. You would then have to pull back all AD records employeeID, mail values into an Array then iterate each one compariing with what you currently have stored in GHR and updated as appropriate.
That's what I am doing. I select all the employees with a sql query and have their Employee ID's and just have to compare that with the LDAP user id and then if email is blank in the Sql table then populate the email from AD....I had the flow working with a table that AD was dumped into and it was working fine, but they took that AD table away so was just going to replace the second sql query node that was looking up AD email in a table and replace it with the LDAP node but it is not comparing like I want it to....it basically grabs the first one and moves on and then errors out. I can grab a screen shot once I figure out how to add it here.
