Insert / Update records LDAP - DataStage v.8.0

gomez · Post by **gomez** » Thu Mar 29, 2007 11:33 am

Hi:
I read DataStage 8.0 services provides complete connectivity to LDAP viewtopic.php?t=96758&highlight=ldap

Can someone please elaborate on that?
Right now I am able to read data from LDAP. We are also looking at insert/updates on LDAP using DataStage. I still havent found a way to do that. Appreciate any help on this

Thanks

DSguru2B · Post by **DSguru2B** » Thu Mar 29, 2007 11:40 am

How are you reading it? Is it a direct connection or via Sql Server linked server? I read data from Active directory using ldap calls but by setting up a linked server. Never tried writing to it. I would be interested in the resolution though.

DSguru2B · Post by **DSguru2B** » Thu Mar 29, 2007 11:47 am

Ok. I got curious and did some research. It turns out your cannot do ADSI calls like LDAP for INSERT/UPDATE/DELETE DML's. Only select is allowed. This is ofcourse if you are using Linked Server which apparantly you are by your other post.
My Reference.

gomez · Post by **gomez** » Thu Mar 29, 2007 1:30 pm

Thanks DSGuru2B for researching on this. I came to know we can do writes using ADAM. I am yet to read about it fully though.

I am not even sure right now if I can use SQL queries with ADAM or use command line functions to work. Has anyone come across this?

Appreciate any clue on this!

Thanks

DSguru2B · Post by **DSguru2B** » Thu Mar 29, 2007 1:37 pm

As long as you can deploy it as a stand alone, you will be fine.

gomez · Post by **gomez** » Fri Mar 30, 2007 2:30 pm

Hi DSGuru2B. Can you please elaborate on your reply on having ADAM as "stand-alone" ?

DSguru2B · Post by **DSguru2B** » Fri Mar 30, 2007 2:33 pm

I have no experience with ADAM. The message that I wanted to convey with my previous post was, that as long as you can write a stand alone piece of code that executes and provides the right result, you can invoke it from within datastage.

eostic · Post by **eostic** » Mon Apr 02, 2007 7:09 pm

I haven't had a chance to implement one, but reading and writing LDAP should be fairly simple using JavaPack.... java api's for LDAP are common....integrating such with DataStage is very easy. Find someone who knows how to manipulate LDAP in Java and with JavaPack you'll have something working in 1/2 day or less.

As for v8, LDAP integration for user authentication is much more out-of-the-box than ever before, as the entire Information Server platform can have it's authentication OS or LDAP based. DataStage itself still needs formal authentication as before, but can still use PAM as needed (Pluggable Authentication Module) for the machine where it is installed.

Ernie