LDAP connection through datastage
Moderators: chulett, rschirm, roy
LDAP connection through datastage
Hi
I am trying to connect to LDAP server as a source. I would like to retrieve the data from LDAP and doing transformation
I would like to know which stage I can use and what are the information required to connect to LDAP.
Thanks
I am trying to connect to LDAP server as a source. I would like to retrieve the data from LDAP and doing transformation
I would like to know which stage I can use and what are the information required to connect to LDAP.
Thanks
parimala
Ummm....
This may sound silly, so forgive me... but are you referring to the Authentication method called LDAP (Active Directory) ?
An "LDAP" server is a host that uses active directory to be used for authenticating users.
Are you referring to any other type of LDAP acronym?
To log in to an "LDAP" server you need a user id and password, optionally you can use SSH keys for password-less secure connections.
To transfer data from one host to another, you need to either FTP/SFTP the files, SCP the files or connect to a database and extract the data.
This may sound silly, so forgive me... but are you referring to the Authentication method called LDAP (Active Directory) ?
An "LDAP" server is a host that uses active directory to be used for authenticating users.
Are you referring to any other type of LDAP acronym?
To log in to an "LDAP" server you need a user id and password, optionally you can use SSH keys for password-less secure connections.
To transfer data from one host to another, you need to either FTP/SFTP the files, SCP the files or connect to a database and extract the data.
Dont know much internals of how LDAP stores its data (system admins can answer this). First of all, as it is being credentials data, isnt it all encrypted.
There is no direct LDAP read feature in DataStage like it does for Oracle, Flat file etc. Pls check and let know what is type of source (file or DB or XML)
Lets say, if the contents are readable, you can use ODBC if your direct LDAP source is DB. Otherwise you can use some wrappers on LDAP server to pre-process the data first and use stages like External Stage to call the wrappers.
There is no direct LDAP read feature in DataStage like it does for Oracle, Flat file etc. Pls check and let know what is type of source (file or DB or XML)
Lets say, if the contents are readable, you can use ODBC if your direct LDAP source is DB. Otherwise you can use some wrappers on LDAP server to pre-process the data first and use stages like External Stage to call the wrappers.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
LDAP does not store data. It is a protocol, much like TCP/IP is a protocol.
The data are stored in some kind of store, such as Tivoli Access Manager or Microsoft Active Directory. LDAP provides a mechanism for accessing those data in something akin to a REST API. But different.
The data are stored in some kind of store, such as Tivoli Access Manager or Microsoft Active Directory. LDAP provides a mechanism for accessing those data in something akin to a REST API. But different.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Hi Ray,
I couldn't read your message fully. but I am trying to get the data from LDAP Active Directory only . Right now my team is using python script to do LDAPSEARCH and get the data. I am looking for an option whether datastage can connect directly to the LDAP active directory and get the data.could you please let me know if there is a way. Thanks in Advance
I couldn't read your message fully. but I am trying to get the data from LDAP Active Directory only . Right now my team is using python script to do LDAPSEARCH and get the data. I am looking for an option whether datastage can connect directly to the LDAP active directory and get the data.could you please let me know if there is a way. Thanks in Advance
parimala