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

7 Comments

Leave a reply →

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

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

- rew
  March 5, 2015 at 6:35 PM
  
  have you solved your problem?
  
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

ODIExperts.com

The blog for Oracle Data Integrator ( ODI )

Connecting openLDAP

7 Comments

Leave a Reply Cancel reply

Recent Posts ODI Expert and why there is no new posts… Passing Values to ODI Variables in Packages/Scenarios New Author Arriving… ODI Certification – Approved How to Change ODI Language (Idiom) Recent Comments Darrell Jefferson on Drivers Location in ODI 11g vasantha on Flow Control and Static Control Cezar Santos on How to use PL/SQL procedures and functions in ODI D.E.Ulger on How to use PL/SQL procedures and functions in ODI surya on ODI Certification – Approved Archives February 2016 April 2015 March 2015 February 2014 November 2013 September 2013 December 2011 November 2011 September 2011 August 2011 June 2011 March 2011 February 2011 January 2011 December 2010 November 2010 October 2010 September 2010 August 2010 July 2010 June 2010 April 2010 March 2010 January 2010 December 2009 November 2009 October 2009 September 2009 August 2009 Categories Administration Architecture Common Errors Drivers How to Java Codes Knowledge Modules Logic ODI ODI Bug Others Reports SDK SQL Technology Tips and Tricks Uncategorized Meta Log in Entries RSS Comments RSS WordPress.org

Recent Jobs ODI Expert and why there is no new posts… Passing Values to ODI Variables in Packages/Scenarios New Author Arriving… ODI Certification – Approved How to Change ODI Language (Idiom) Information about the ODI Certification Exam Finally!!!! The Oracle Data Integrator 11g Certified Implementation Exam!!!!!! Interface with Union, Minus Operator using ODI SDK Export and Importing Scenarios based on Project (or)Folder Creating Interface for Single Source and Target Creating Permanent Interface based on Model Level Automatically add Interfaces/Scenarios to new ODIPackage using ODI SDK Creating Package using SDK Handling the “ORDER BY” clause in an interface Creating Temporary Interface using ODI SDK Creating ODI Procedure using SDK ODI SDK Setup and Config in Eclipse Things to be pride of…. CDC CONSISTENT Ordered SQL Killing session in ODI 11g 11g Oracle Data Integrator – Part 8/11g – Table Partitioning supported Jython Scripts fails to recognize the module during scenario run in ODI 11g Scenarios, a lot in the first delivery makes maintenance very simple! Direct load by interface with no work tables (C$, I$) 11g Oracle Data Integrator – Part 7/11g – SUNOPSIS MEMORY ENGINE 11g Oracle Data Integrator – Part 6/11g – Union , Minus, Intersect Jython’s Beginner Guide for ODI Send SQL by Email Security Module – Main concepts and use Drivers Location in ODI 11g 11g Oracle Data Integrator – Standalone Agent but, and about the Windows Service??? 11g Oracle Data Integrator – Part 5/11g – odiConsole, the new Metada Navigator Using one of ODI’s lesser-known secrets: the Common Format Designer (CFD) – by Craig Stewart 11g Oracle Data Integrator – Part 4/11g – Upgrading from 10g 11g Oracle Data Integrator – Upgrading from 10g – Part 4/11g First year of many…. Thank you Friends! 11g Oracle Data Integrator – Part 3/11g – Graphical User Interface Datatypes – Creating what is missing for any technology IS_NUMBER (and IS_CHAR) at Oracle? A workaround… Calling OdiSqlUnload using ODI Procedure with no hardcoded password SNP_EXP_TXT – A “huge” table problem Internal ID SCD Type 2 11g Oracle Data Integrator – Part 2/11g – Creating Repositories 11g Oracle Data Integrator – Creating Repositories – Part 2/11g Regenerate ODI Objects using OdiGenerateAllScen Generate Column_name Header for OdiSqlUnload Error Records Log Get the Error Message of any Failed ODI objects inside Package SCD TYPE 3 Best practice of ODI 11g Oracle Data Integrator – Part 1/11g – First Screen Automated ODI Export Import Scenarios LKM OdiSqlUnload(File) to Oracle ( SQLLDR ) Jython OS bug in Windows 7 Writing SQL counts using Jython Getting one or several unknown files from a directory Interface Parallel Execution – A new solution Displaying SQL results in Operator Flow Control and Static Control Export DWR to EWR [ Common Master Rep ] Scenario Report Asynchronous -Parallel Execution Dropping $ Tables KM FOR UNION BASED ON IKM SQL CNTRL APPEND Installing ODI in Windows 7 Querying in ODI Changed Data Capture ( CDC ) Agent Manual entry in ODI Driver List MINUS IN ODI Variable Detail Query Interface Mapping Query Topology Connection Detail Versioning Get File Length and Header in Operator Find the Value of the Variable in Operator ? Invisible Join Shortcuts Keys Export – Import DWR to EWR having same Master Rep Categorize Scenarios Alignment of objects in Package Duplicate Multiple Objects in Package Smart Search Export – Import DWR to DWR having same Master Repository Procedures (or KM) Steps – Source and Target tab’s Subscribers – An example of how to use Why Creating a separate schema in ODI? How to show Business Messages on Operator and, too, debug variables… Topology – Data Server – Which user should be used to connect? How to use PL/SQL procedures and functions in ODI Context, Logical And Physical Schema – How does it work? Repository Architecture – Work Repository, Development or Execution? When and why uses each one. Removing Special character using Jython script Faster and Easiest way to design Interfaces AUTOMIZE ODI REPOSITORY EXPORTS Informix Connection SQL Server connection Repository Architecture – Two or more Masters – Part 3 Report of list of KMs in each Interface Connecting openLDAP How to call a Web Service that start an ODI Scenario and waits its complete execution Processing multiple Interface through single Package Multiple Files – Single Interface Generate Multiple Scenarios Sequence How to get a constant or pseudo-column from source mapping Lock Windows Layout Hide Unused Technologies Tab at the Top oracle.jdbc.V8Compatible Oracle to Flat file Scheduling using ODI Scheduler Exception – getobjectname schema How to create a Temp Table in ODI Interface (Yellow Interface) Printing report Step by step procedure to Read Excel (*.xls) Importing Knowledge Modules Creating Master and Work Repository Installation Repository Architecture – Just one Master – Part 2 How to refresh ODI variables from file – Part 2 – Getting all lines, once at time How to refresh ODI variables from file – Part 1 – Just one value Repository Architecture – Just one Master – Part 1 Welcome to ODI Experts, this is Cezar Santos.