topic Re: help in QlikView

help

Tue, 22 Apr 2014 08:31:24 GMT

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

Re: help

ashfaq_haseeb — Tue, 22 Apr 2014 08:34:56 GMT

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

Re: help

sujeetsingh — Tue, 22 Apr 2014 08:36:35 GMT

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

Re: help

sujeetsingh — Tue, 22 Apr 2014 08:36:47 GMT

LDAP Login to Retrieve Users and Groups

Re: help

its_anandrjs — Tue, 22 Apr 2014 08:38:30 GMT

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

Re: help

Tue, 22 Apr 2014 09:39:51 GMT

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'

Re: help

Tue, 22 Apr 2014 09:43:54 GMT

Hi,

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