Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

LDAP query

I have a new project that involves reporting account status (date of request, date of approval, access levels, etc.) so that we can report on the amount of time it is taking to get accounts approved/changed, and the progress snapshot data is being stored in an LDAP database. The only way I've ever successfully accessed that same database was through ldifde via a shell - and while it will pull the data I am looking for, it only exports to a flat text file that then has to be parsed - not to mention it's a little cumbersome trying to pull data for hundreds of users. So I was wondering if there wasn't a better and easier way through some sort of ODBC type connection.

Thoughts? Suggestions?

5 Replies
MVP
MVP

LDAP query

I don't know if there is an ODBC driver. But maybe this could work via JDBC:

http://www.openldap.org/jdbcldap/

Our QlikView JDBC driver:

http://community.qlik.com/docs/DOC-2438

- Ralf

MVP
MVP

LDAP query

Not applicable

Re: LDAP query

Hi Ralf,

Thanks for the links.

I assume that these are all going to do the same thing, which is provide a bridge between the Qlikview server and the LDAP database? If so which one should I go with? I don't have the luxury of accessing the server to install the files, so I will need to have the system admin put them on. Might take a few days.

I apologize but I'm new to java - so will need some help identifying where the files will need to go on the server and how to write the syntax to connect and retrieve the data.

I also found this solution, which is pretty interesting. Just not sure whether I can set up a job somewhere to update and push the excel file to the server or if it will need to be done manually

http://sourceforge.net/projects/excelldapsearch/?source=directory

MVP
MVP

Re: LDAP query

Hi,

you'll need at least the two .jar files in the CLASSPATH (see instructions on our QlikView JDBC driver document).

I have had to add one missing file to the jdbcLdap.jar lib: META-INF/servies/java.sql.Driver

Unfortunately I have no LDAP server running for a test. The connect URL should look like this:

     jdbc:ldap://host[Smiley Tongueort]/basedn[?property1:=value1 &property2:=value2&propertyn:=valuen]

A select statement could used in this way:

     SELECT * FROM subTreeScope;dc=domain,dc=com WHERE cn='Test User'

See also: http://myvd.sourceforge.net/bridge.html

- Ralf

qlikviewforum
Contributor II

Re: LDAP query

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

Community Browser