LDAP query

[#1]

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?

[rbecher]

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

[rbecher]

..a better download link:

http://sourceforge.net/projects/myvd/files/jdbc%20ldap%20bridge/jdbc%20ldap%20bridge%202.1/

[#4]

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

[rbecher]

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[:port]/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]

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