This discussion is archived
1 Reply Latest reply: Feb 15, 2013 11:58 AM by user750024 RSS

Connect to open ldap server using ODI

963952 Newbie
Currently Being Moderated
Hello,

I need to use openldap as dataserver in ODI. But I'm not sure how to provide valid connection string. My test ldap server:
- host: 172.18.0.106
- port: 389
- base dn: dc=example,dc=com

And (optionally), root access (simple authentication):
- Bind dn: cn=jimbob, dc=example, dc=com
- password: pass

So, I'm trying to begin with anonymous access (read only), this is my connection string:

jdbc:snps:ldap?ldap_url=ldap://localhost:389/&ldap_basedn='dc=example,dc=com'

Unfortunatelly, it does now work:
java.sql.SQLException: ODI-40528: A com.sunopsis.ldap.connection.SnpsLdapDriverPropertyException occurred saying: ODI-40546: A user has not been provided

Why does it ask me for user? ODI documentation says, that user/pass are not mandatory.

What are correct connection strings for anonymous access and root (or other user) access in my case? Both methods works with apache directory studio.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points