Data from LDAP

[#1]

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

[petter]

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...

[avinashelite]

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

[avinashelite]

[flipside]

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.

[avinashelite]

hi flipside‌

Can you please explain the procedure , will try the same

[flipside]

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.

[petter]

[#9]

I tried to fetch data using Microsoft Directory Services.

Not able to see any table

[petter]

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