help

[#1]

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

[ashfaq_haseeb]

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

[sujeetsingh]

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

[sujeetsingh]

LDAP Login to Retrieve Users and Groups

[its_anandrjs]

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';

[#6]

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'

[#7]

Hi,

Thank you for your response but i don't know how to create a oledb or odbc connection with LDAP, i use openldap