DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
parilango
Participant



Joined: 23 Jun 2016
Posts: 8

Points: 67

Post Posted: Fri May 19, 2017 9:22 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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

_________________
parimala
Mike



Group memberships:
Premium Members

Joined: 03 Mar 2002
Posts: 1003
Location: Omaha, NE
Points: 6478

Post Posted: Fri May 19, 2017 12:38 pm Reply with quote    Back to top    

It depends...

Start with some initial research:

1) What kind of API does your LDAP vendor provide?
2) Do you need a real-time interface, batch interface, or something in between?

Mike
Rate this response:  
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1075

Points: 7141

Post Posted: Fri May 19, 2017 3:54 pm Reply with quote    Back to top    

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.
Rate this response:  
mouthou
Participant



Joined: 04 Jul 2004
Posts: 173

Points: 1657

Post Posted: Thu Jun 08, 2017 9:55 am Reply with quote    Back to top    

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.
Rate this response:  
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 53940
Location: Sydney, Australia
Points: 292679

Post Posted: Thu Jun 08, 2017 10:54 pm Reply with quote    Back to top    

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 ...

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong | Hobart | Brisbane
currently hiring: Canberra, Sydney and Melbourne
Rate this response:  
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours