LDAP to Database job question

jared5494 · Post by **jared5494** » Wed Apr 23, 2008 8:53 am

Thanks for looking and any help you can provide!

I am doing some research on DataStage to see if you can create a simple job that will extract values from a LDAP and put them into a DB2 table. How would you go about doing this?

The LDAP connection string looks like this:
ldapUser: cn=xxxxx,ou=yyyyy,o=zzzzz
ldapURL: ldap://ldapserver:389/O=wwwww
ldapPassword: daPassword

Let me know if you need anymore information.

Thanks again,
Jared

rameshrr3 · Post by **rameshrr3** » Wed Apr 23, 2008 9:02 am

Are you using Datastage TX? If so you may have to post it in a different forum.( TX)
. Search might help you too use LDAP as the search string ..

eostic · Post by **eostic** » Wed Apr 23, 2008 9:15 am

Yes, as noted, TX has an LDAP adapter.....and of course, if you are a DataStage EE and a TX (now WebSphere TX) site, then you could use MapStage to invoke a TX map from within DS...... for DataStage EE or Server, JavaPack is probably the best route to take to read LDAP. Libraries (and skills) for LDAP are readily available for Java, and integrating a java class into DataStage is childs play if you put a DataStage person and a Java person together (or have the skills combined!)...

Ernie

chulett · Post by **chulett** » Thu Dec 17, 2009 7:09 pm

Arise! :D

Out of curiousity, is there a way to do this without TX or the Java pack? I've been offered up a perl script shooting LDAP information out to standard out as a possible solution but wondering what other approach there might be. For us 'Don't Haves', that is.