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
sn
FROM 'LDAP://$(Based DN)' WHERE UNIQUEIDENTIFIER='00100xxxx';
UNIQUEIDENTIFIER is a field available in this source.
