I have a database table with ~3000 employee records. There’s a column that I don’t get from the system of origin that I need to extract from our LDAP server. Basically, I need to get the SAM account for each employee using their employee ID as the lookup. I haven’t seen much documentation on how to use the LDAP query service but I wanted to see what the best practice would be in terms of getting the SAM account.
First of all, how do I actually structure the query in a flow? Second, is it better for me to insert all the records into the table and then somehow loop over each record in the table to do an LDAP query for each one (update of each record)? OR…is it possible for me to do the LDAP query inline as I’m doing the insert with the JDBC Adapter in that flow?
I hope I’m being clear and any help or guidance would be greatly appreciated. Thanks in advance.