Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data in ldap database and i need to make a transfert of this data to qlikview personal edition can someone help me.Thank you
Hi,
Just created a oledb or ODBC connection with LDAP.
Which LDAP you are using Tivoli/Microsoft?
You can pull any table.
Hope it helps
Regards
ASHFAQ
Hope this will help you out
In the connection tab, set the Data source to: LDAP://your.adserver.com < where the last part is any AD node in the network.
And use any username that has the rights to read the AD
In the edit script place the lines below:
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:// your.adserver.com'; groups: load distinguishedName as GroupKey, cn as "Group Name", subfield(member,'|') as KEY_User; sql select distinguishedName,cn,member from 'LDAP:// your.adserver.com';
No more needs for the silly logparser application
Load your LDAP dat some thing like below script change according to your LDAP
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://
your.adserver.com';
groups:
load
distinguishedName as GroupKey,
cn as "Group Name",
subfield(member,'|') as KEY_User;
sql select distinguishedName,cn,member from 'LDAP://
your.adserver.com';
please i have this error
Échec de la connexion ODBC
sql select distinguishedName,
cn,
displayName,
givenName,
sn,
mail,
userAccountControl from 'LDAP://192.168.1.101'
Hi,
Thank you for your response but i don't know how to create a oledb or odbc connection with LDAP, i use openldap