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: 10

Points: 86

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: 1010
Location: Omaha, NE
Points: 6513

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: 1153

Points: 7639

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: 174

Points: 1670

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: 54042
Location: Sydney, Australia
Points: 293160

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:  
parilango
Participant



Joined: 23 Jun 2016
Posts: 10

Points: 86

Post Posted: Mon Oct 02, 2017 11:41 am Reply with quote    Back to top    

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

_________________
parimala
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1153

Points: 7639

Post Posted: Mon Oct 02, 2017 12:46 pm Reply with quote    Back to top    

What are you basically trying to do?

I've used LDAPSEARCH before and found it quite useful.

you have to remember that the LDAP host is not a database to query.

Like Ray said... it's a PROTOCOL for authenticating users.


so...

What are you trying to do?
Rate this response:  
Not yet rated
parilango
Participant



Joined: 23 Jun 2016
Posts: 10

Points: 86

Post Posted: Mon Oct 02, 2017 12:59 pm Reply with quote    Back to top    

Python script is connecting to LDAP and run LDAPSEARCH command to get the data from the directories. I am trying to do the same using datastage.
Not sure how to use them? Scripting is the only way ? or is there any otherway to do in datastage

_________________
parimala
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 42226
Location: Denver, CO
Points: 216806

Post Posted: Mon Oct 02, 2017 2:15 pm Reply with quote    Back to top    

Have you engaged your official support provider yet?

_________________
-craig

Watch out where the huskies go and don't you eat that yellow snow
Rate this response:  
Not yet rated
PaulVL



Group memberships:
Premium Members

Joined: 17 Dec 2010
Posts: 1153

Points: 7639

Post Posted: Mon Oct 02, 2017 2:40 pm Reply with quote    Back to top    

well... you could use an external source stage to obtain the data and then process it via a datastage job, but that would be gosh darn silly.

You still haven't explained WHAT you are trying to do other than run the ldapsearch command.
Rate this response:  
Not yet rated
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