Retrieve Objects from LDAP based on table content

[bi4business]

Hi All,

Does anyone know how to get LDAP objects what I can use in FM ?

I have a table with User ID's in my DWH system.
The User ID's are the same as the LDAP User ID's.

Can I use a calculated field within my FM table to retrieve LDAP objects like firstname / lastname / email / phone / department what is stored in LDAP ?
Not the session paramater, but based on the table user ID.

I need to create a list with users and ID's / phone / department ect ect.

I should use ETL for putting the data into my DWH, but is there an other way like macro's ?

Thanks you for helping.

bi4business

[cognostechie]

It can be done for sure but I can't provide you the details unless you post an example of what you have in LDAP and what you have in the table. FM can retrieve data from the table (standard functionality) and from LDAP using session parameters so you should be easily able to set filters to identify/isolate the one record of login user-id you are looking for. Have you tried it or just asking the question before trying it?