Web service for Active Directory

[danielact]

My company uses a web service for our active directory. I have the address for it - let's say it's this:

http://abcdef2/activedirectoryws_auth/ad.asmx

Can someone give me a walk-through of how to connect to this, and bring the data into QlikView?

Thanks!

[phaneendra_kunc]

Hi,

I don't know whether this works for your case or not. But below works if you can read from LDAP.

http://guerrillabi.com/qlikview_Active_Directory

Regards

Phani

[danielact]

I saw that already, and I can't get it to work - at least, I think I've tried it properly. Here's what I have in my script:

OLEDB CONNECT TO [Provider=ADsDSOObject;Encrypt Password=False;Integrated Security=SSPI;Data Source=ldap://abcdef2/activedirectoryws_auth/ad.asmx;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648];

users:

load 

distinguishedName as KEY_User,

cn as Userid,

displayName,

givenName,

sn,

mail,

userAccountControl;

sql select distinguishedName,cn,displayName,

givenName,sn, mail,userAccountControl from 'LDAP://

abcdef2/activedirectoryws_auth/ad.asmx';

groups:

load 

distinguishedName as GroupKey,

     cn as "Group Name",

     subfield(member,'|') as KEY_User;

sql select distinguishedName,cn,member from 'LDAP://

abcdef2/activedirectoryws_auth/ad.asmx';

Can you tell me if I'm doing this right, or if I need to adjust something?