topic Sun1 LDAP Query in QlikView

Sun1 LDAP Query

Fri, 12 Nov 2010 16:00:32 GMT

I am trying to query SUN1 Open LDAp directory. so far i am able to get some result but all it returns is ADsPath and no attribute

My query is


SQL
select

ADsPath,mail
 FROM
 'LDAP://ldap/ou=people,dc=group,dc=com' where


mail='kris*';

even if use Select * from , it returns only ADsPath

What am i missing here

Also when i create the connection i get below error

and if i click yes,it says

Thanks

Peter

Sun1 LDAP Query

Fri, 12 Nov 2010 18:34:41 GMT

Can anybody help me on this issue

Thanks

Peter

Sun1 LDAP Query

Sat, 13 Nov 2010 20:37:32 GMT

I have been scratching my head on this issue but no solution

Any ideas

Thanks

Peter

Sun1 LDAP Query

Mon, 15 Nov 2010 14:04:19 GMT

hi,

There is SQL interface for Microsoft's own Active Directory. Not sure that will work for other LDAP servers.

You can use a script that will read from LDAP, dump to text file, and load that text file into QlikView

-Alex

Sun1 LDAP Query

Wed, 13 Apr 2011 00:46:30 GMT

Hi Peter,

Did you get a good answer to this, or figure out the solution? I'm in the same boat.

I have verified through my client's LDAP Admin that the query is going through just fine, and (in my case) an authenticated bind is not needed. It appears then that the problem is the ADsDSOObject provider doesn't understand the LDAP-standard field names (which MS changed for AD), and tosses them.

This doesn't bode well for use of the ADsDSOObject provider, so I'm currently working on a macro to grab the fields directly. It seems though, that the provider is still blocking the returning macro fields.

Anyway, please let me know if you found a good solution.

Thanks,

Sun1 LDAP Query

Wed, 13 Apr 2011 08:23:21 GMT

Hi,

ADsDSOObject is Active Directory speciffic.

There are many tools to read LDAP and write output into text files. Why don't you use one of those?

-Alex

www.snowflakejoins.com

Sun1 LDAP Query

Wed, 13 Apr 2011 18:26:01 GMT

Sure, I could do that, but it's frustrating that there's not an LDAP direct-query provider for QlikView, and more frustrating that the ADsDSOObject provider is actually the problem with querying non-AD LDAP.

This should be noted in official QlikView documentation as a known pitfall.

Sun1 LDAP Query

Thu, 14 Apr 2011 07:10:13 GMT

Yes you are right there is lot of problems using the ADsDso object, it works for some fields only.

What we implemented as a solution is to query ldap through a batch file and get the results of the query in a text file

And then read data from the text file into qlikview.transform as per requirement

Batch file first gets triggered from qlikview itself and then script gets executed.

Also this solution was implemeted in one scenario where as inother scenario we could able to retrieve data directly querying LDAp from qlikview

thanks

Peter

Sun1 LDAP Query

jonathandienst — Thu, 14 Apr 2011 07:26:47 GMT

Hi all

I have only limited experience with LDAP queries, but I have noticed that even with AD, SELECT * just returns the adspath. I think the AD LDAP prrovider does not respond to the 'request field names' part of a SELECT * query, so you cannot browse the field names or use SELECT * unless you only want adspath. This means that you need to supply the field names in the SELECT statement, something like:

SQL SELECT
 distinguishedName,
 cn,
 displayName,
 givenName,
 sn,
 mail,
 userAccountControl,
 SamAccountName
FROM 'LDAP://yourdomain.local'
Where objectCategory = 'Person'

If your LDAP provider uses different field names, then adjust the query accordingly. I do not know Open LDAP, but check the documentation for more info.

Hope that helps
Jonathan

Re: Sun1 LDAP Query

qlikviewforum — Tue, 23 Jul 2013 11:56:03 GMT

Hi,

The QVW which tries to load the data from LDAP loads only the partial data frequently. We are unable to find the root cause of the issue as the QVW doesn't fails but it loads only the partial data.Can someone please help us to identify the root cause of the issue. It has been happening from quite a long time but we didn't succeed in finding the root cause of the issue. Hope someone can help us for the same.

Regards,

qvforum

Re: Sun1 LDAP Query

rajeshvaswani77 — Fri, 27 Sep 2013 11:40:08 GMT

Hi,

Was there any solution found for this issue?

thanks,

Rajesh Vaswani