Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

pushpita
Contributor

Help needed to get data from AD

Hi All,

I am trying to connect to AD. The connection is successful but not able to see the database.

Code :

OLEDB CONNECT32 TO [Provider=ADsDSOObject;User ID=usename;Encrypt Password=False;Data Source=LDAP://Domain Name.Local;Location=LDAP://Domain Name.Local Mode=Read;Bind Flags=0;ADSI Flag=-2147483648] (XPassword is WcfUUGFMNLYYWUBIUbYGXYIGTBNKTcA);
A:

SQL select name, sAMAccountName FROM 'LDAP://Domain Name.Local; WHERE objectCategory='person' AND objectClass = 'User' ;

Error :

Message was edited by: Priyabrata Das