topic Re: Data from LDAP in QlikView

Data from LDAP

Wed, 30 Sep 2015 06:50:54 GMT

how to fetch the data from LDAP.

I have to fetch all the users from LDAP and import recipient from LDAP to send mail using N printing

Re: Data from LDAP

petter — Wed, 30 Sep 2015 08:59:29 GMT

You can use at least two approaches to retrieve LDAP data so you can get them as normal tables in QlikView:

1. OLE DB provider for Microsoft Directory Services:

https://technet.microsoft.com/en-us/library/ms190803(v=sql.105).aspx

Using SQL ...... to read the LDAP (might only work with Microsoft LDAP (Active Directory) ... haven't tested it)

2. LDAP search with PowerShell - multiple approaches:

http://activedirectoryfaq.com/2015/02/ldap-search-powershell-find-ldapobject/

You can in your load script use the EXECUTE statement to execute a PowerShell command

and there are many more options available too...

Re: Data from LDAP

avinashelite — Wed, 30 Sep 2015 10:21:32 GMT

As per my knowledge you cannot directly pull data from LDAP and LDAP is not a data base , it should sync the data to some DB and then only you can fetch the same .

archive.oreilly.com/pub/post/ldap_is_not_a_database.html

Hope this helps you

Re: Data from LDAP

avinashelite — Wed, 30 Sep 2015 10:22:35 GMT

Re: Data from LDAP

flipside — Wed, 30 Sep 2015 10:31:02 GMT

Actually it is possible. I haven't got the code with me but I have done it. If no-one else knows I'll try and find it and post it later.

EDIT: Although this is using Qlikview and not NPrinting which I am not familiar with.

Re: Data from LDAP

avinashelite — Wed, 30 Sep 2015 10:35:13 GMT

hi flipside‌

Can you please explain the procedure , will try the same

Re: Data from LDAP

flipside — Wed, 30 Sep 2015 10:46:09 GMT

This might help, the code looks familiar.

Re: Active Directory Query

Not sure what ODBC drivers are needed. It also takes a bit to decipher some of the data because it is binary based values stored as integers, I had to write some code to do that.

Re: Data from LDAP

petter — Wed, 30 Sep 2015 11:02:50 GMT

Re: Data from LDAP

Wed, 30 Sep 2015 12:03:12 GMT

I tried to fetch data using Microsoft Directory Services.

Not able to see any table

Re: Data from LDAP

petter — Wed, 30 Sep 2015 12:18:55 GMT

You might have to write the SQL yourself - since the LOAD wizard doesn't seem to be able to pick out the right "tables"...

Re: Data from LDAP

petter — Wed, 30 Sep 2015 12:26:58 GMT

You do have a valid connection as you tested that. But it seems that the wizard is unable to retrieve the right entities in LDAP and show them as table-like entities.

That doesn't mean that you can't retrieve the information you want. But you will have to use SQL syntax according to the documentation that Microsoft provides:

SQL

SELECT ADsPath, cn FROM 'LDAP://DC=Fabrikam,DC=COM' WHERE objectCategory='group';

Should give you all groups...

'LDAP://DC=.....' must be replaced by your specific LDAP path.

SQL

To search for all the users whose Last Name starts with letter H.

SELECT ADsPath, cn FROM 'LDAP://OU=Sales,DC=Fabrikam,DC=COM' WHERE objectCategory='person' AND objectClass='user' AND sn = 'H*' ORDER BY sn

;

Re: Data from LDAP

Thu, 01 Oct 2015 05:07:40 GMT

what should be enter in data source name and location