LDAP Query Help

prajwala — Sat, 16 Nov 2024 19:58:32 GMT

Hello all,

I am very new to using LDAP queries. We have setup LDAP connection as below:

OLEDB CONNECT32 TO [Provider=ADsDSOObject;User ID="cn=user,ou=serviceaccounts,ou=ops,ou=abc,ou=xyz,ou=ad,dc=xyz,dc=com";Encrypt Password=False;Data Source="LDAP://directoryservices.xyz.com:636/Base DN: ou=XYZ,ou=XYZInternalView,ou=XYZViews";Mode=Read;Bind Flags=0;ADSI Flag=-2147483648] (XPassword is DDIeLIBIEBJOXXJOELMAFAREEZdeGZRMRBTB);

I am just getting started and tried the below script:

LOAD *;
SQL
SELECT sn FROM 'LDAP://directoryservices.xyz.com:636/Base DN: ou=XYZ,ou=XYZInternalView,ou=XYZViews' WHERE objectCategory='person';

I am receiving the below error:

Can someone help me with the query please?

TIA

Re: LDAP Query Help

Brett_Bleess — Wed, 09 Oct 2019 16:16:04 GMT

Your best bet is going to be going to someone on the LDAP team to have them give you the correct information to access things, they are going to be the experts, not us.

That being said, I want to clarify something as well, what you are trying to do is actually pull data from your LDAP via the Load Script and NOT configure a Directory Service DSP? Either way, I would expect your LDAP admins are the guys to best help you here.

Regards,
Brett

topic LDAP Query Help in QlikView

LDAP Query Help

Re: LDAP Query Help