LDAP Connection issue

prajwala — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I have a requirement to pull from an LDAP source (not exactly Active Directory). I have these below details and my query. I always get "An Operations error occured" error.

Source: ldap.xx.xx.xx

Base DN: ou=users,dc=XXX,ou=YYY,ou=XXX

User DN: CN=AccountName,OU=ServiceAccounts,OU=XX,OU=YY,OU=XX,OU=ZZ,ou=YYYY,ou=ZZ,ou=XX

I am not really familiar with the LDAP Structure but these are the details given to me. I have a password for the Account used in the User DN.

Below is my query:

OLEDB CONNECT32 TO [Provider=ADsDSOObject;Encrypt Password=False;Integrated Security=SSPI;Data Source=LDAP;Location=ldap.xx.xx.xx;Mode=Read;Bind Flags=0;ADSI Flag=-2147483648];

UserTable:

LOAD

sn;

SQL select

FROM 'LDAP://$(Based DN)' WHERE UNIQUEIDENTIFIER='00100xxxx';

UNIQUEIDENTIFIER is a field available in this source.

Thank you!

topic LDAP Connection issue in QlikView

LDAP Connection issue