1 Reply Latest reply: Feb 15, 2013 1:58 PM by user750024 RSS

    Connect to open ldap server using ODI

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