ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Connecting openLDAP

In Hyperion EPM 11 , authentication information is stored in openLDAP .

To get more information for the Hostname , port name , log into your Hyperion Shared Service console and under ‘ Administration ‘ click on ‘ Configure User Directories ‘

Configure User Directories

Provider Configuration

Click ‘ Edit ‘ on the ‘ Provider Configuration‘ and check for the other details required for setting up the connection for openLDAP in ODI

Right click on LDAP Technology and ‘ Insert Data Server ‘ and for User -enter the above ‘user DN – ‘ cn=root,dc=css,dc=hyperion,dc=com ‘

Here cn=root , the main root user who have all privilege to read all the data from OpenLDAP .

Select the Sunopsis JDBC Driver for LDAP

JDBC URL –

jdbc:snps:ldap?ldap_url=ldap://<host>:<port>/&ldap_basedn=<base_dn>[&<property>=<value>…]

jdbc:snps:ldap?ldap_url=ldap://localhost:28089/&ldap_password=KLLEJMNLKFLBKLKODDGPGPDB&ldap_basedn=dc=css,dc=hyperion,dc=com

<host>: LDAP server network name or IP address. – < localhost >

<port>: port number the LDAP server is listening on. < 28089 >

<base_dn>: base DN to connect to. < dc=css,dc=hyperion,dc=com >

Encode the password using this command

The Default Password for OpenLDAP is ” security “

To encode the password , run this command

java -cp E:OraHome_1oracledidriverssnpsldapo.jar com.sunopsis.ldap.jdbc.driver.SnpsLdapEncoder <enter password here>

If your password is not changed and also the User DN is same then you can use this JDBC url ,just change the localhost to your hostname

jdbc:snps:ldap?ldap_url=ldap://localhost:28089/&ldap_password=KLLEJMNLKFLBKLKODDGPGPDB&ldap_basedn=dc=css,dc=hyperion,dc=com

9 Comments

Leave a reply →

  1. Shiva Kumar
    January 31, 2017 at 6:55 AM

    Hi,
    i have configured the LDAP in ODI, it tested successfully. I have created models for LDAP and Oracle. My requirement is LDAP data should transferred to oracle table. i have created mapping, while executing the mapping, im getting error as: ” ODI-1227: Task Load FILTER_AP-LKM SQL to Oracle (Built-In)- fails on the source connection LDAP_TEST_SECOND.
    Caused By: java.sql.SQLSyntaxErrorException: user lacks privilege or object not found: ORGANIZATIONALPERSON_PERSON_US “.

    Please help me for resolving the issue.

    Thanks,
    Shiva

    Reply
    • Cezar Santos
      January 31, 2017 at 11:34 AM

      Hi Shiva,

      apparently the user used to connect to the LDAP source haven’t the right privilege….

      Reply
      • Shiva Kumar
        February 6, 2017 at 11:14 AM

        Hi Cezar,

        I’m able to see the data in datastore at Model level (view data), which means that there is a select permission has already given.

        Please help.

        Thanks & Regards,
        Shiva Kumar

        Reply
      • Shiva Kumar
        February 17, 2017 at 5:54 PM

        Hi Santos,

        I have resolved the issue. We will get this kind of error when the name of datastore (ODI creates the datastore while reverse engineer the model of LDAP) are very big like more than 30 characters. So ODI will read the table names upto only 30 characters (this is the default value for LDAP datastore), when we execute mapping ODI will look for the object of length 30 character datastore, but in actually the datastore name is more than 30 characters. So we will get above mentioned error.

        To overcome the error, we have to specify the maximum table name length value to some 50 or 100 or more than default value.
        Navigation path: Physical Architecture -> Technologies -> LDAP -> Right click Open -> Advanced tab -> Maximum table name length.

        It is in ODI 12c.

        Thanks & Regards,
        Shiva Kumar

        Reply
    • Alejandro Gerez
      May 23, 2018 at 3:33 PM

      Greetings Shiva, can u send me a pic of your pyshical arquitecture configuration?

      I having trouble when i try to connect ODI with LDAP topology (Active Directory 2003). If u cant then could you point me to tutorial or documentation showing how to do it?

      Error: ‘oracle.odi.runtime.agent.invocation.InvocationException: http://omcsbabmhpsgna.compute-a421288.oraclecloud.internal:3013/oraclediagent:java.net.SocketTimeoutException: Read timed out’

      Thanks and regards.

      Reply
      • Claire
        August 1, 2018 at 7:57 PM

        Did you get the LDAP topology to connect? I keep getting timed out. It is trying to bring back too much. Do you know how to filter out a certain cn or uid?

        Reply
  2. Carlito
    August 30, 2010 at 5:59 AM

    Hi,
    I hope the you can help me !
    I have an error during the configuration because (I think) the base_dn has some blank space in the dn :

    dc=service account profile,dc=company,dc=com

    “java.sql.SQLException: A NamingException occured saying: Cannot parse url: service,dc=company,dc=com with this explanation: Cannot parse url: service,dc=abc,dc=net and this remaining name: null”

    Thanks in advance .

    Carlito.

    Reply
  3. Kiran
    October 21, 2009 at 10:25 AM

    Hi,,
    I’m having hard time in setting up the LDAP authentication from ODI.we are having the 9.3.1 shared services and i’m using 58089 port and also the shared services host name and the default password which is shown in the blog.

    But it says the connection cannot be found.

    Please help me in this.
    Kiran

    Reply

Leave a Reply

Required fields are marked *.


This site uses Akismet to reduce spam. Learn how your comment data is processed.