{"id":824,"date":"2008-09-13T11:20:09","date_gmt":"2008-09-13T15:20:09","guid":{"rendered":"http:\/\/onlineappsdba.com\/index.php\/2008\/09\/13\/integrate-oracle-bi-server-with-ldap-server-oid-oracle-internet-directory\/"},"modified":"2008-09-13T11:24:40","modified_gmt":"2008-09-13T15:24:40","slug":"integrate-oracle-bi-server-with-ldap-server-oid-oracle-internet-directory","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2008\/09\/13\/integrate-oracle-bi-server-with-ldap-server-oid-oracle-internet-directory\/","title":{"rendered":"Integrate Oracle BI Server with LDAP Server (OID – Oracle Internet Directory)"},"content":{"rendered":"

In this post we are going to cover steps to integrate OBIEE <\/strong>with OID<\/strong>. By default BI<\/strong> users are stored locally and authenticate against BI Server.
\nOBIEE support authentication<\/strong> via LDAP Server (OID, iPlanet, openldap server).<\/p>\n

.<\/p>\n

Integration of OBIEE with OID is required if<\/strong><\/p>\n

1.<\/strong> You wish to use OID as user repository<\/strong> for OBIEE or
\n2.<\/strong> You wish to authenticate OBIEE users against OID<\/strong> or
\n3.<\/strong> You wish to integrate OBIEE<\/strong> (analytics) with Oracle Single Sign-On Server <\/strong>
\nTo know more about OID \u00a0 click here<\/a>\u00a0\u00a0 and \u00a0 here<\/a> .
\n<\/strong><\/u><\/p>\n

.<\/strong>
\nThere are two ways to integrate OBIEE with OID<\/strong><\/u>
\n1. To authenticate<\/strong> against OID or
\n2. Synchronize<\/strong> users\/groups from OID to OBIEE Server .<\/p>\n

.
\nConfigure OID for User Authentication in Oracle BI<\/strong><\/u><\/p>\n

1.<\/strong> Create LDAP (OID) entry<\/strong> in Repository of BI
\n2.<\/strong> Configure initialization block<\/strong> for user authentication .<\/p>\n

.<\/p>\n

1. <\/strong>Create LDAP entry in Repository of BI<\/strong><\/u>
\nTo create LDAP (OID) entry in BI Repository<\/p>\n

a)<\/strong> Open repository (offline\/online mode) from OBI Administration Tool (To know more about BI Administration Tool, Click Here<\/a>)
\nManage<\/strong> -> Security<\/strong> to open Security Manager in BI Administration Tool
\nAction<\/strong> -> New<\/strong> -> LDAP Server<\/strong> to add new ldap server<\/p>\n

<\/a><\/p>\n

.<\/p>\n

b)<\/strong> In new pop up window enter OID server details<\/strong> where<\/p>\n

– HostName<\/strong> is machine name on which OID is running
\n– Port Number<\/strong> is Port on which OID<\/strong> is listening<\/strong>, if you are planning to use SSL port of OID change select SSL in Advanced Tab as shown below<\/font>
\n– Base Dn<\/strong> is location in OID tree under which all users sit\u00a0 (user who wish to login through OBI should be under this tree in OID)
\n– Bind Dn<\/strong> is distinguished name of supeuser usually orcladmin<\/strong> (super user)
\n– Bind Password<\/strong> – is password of orcladmin user<\/p>\n

.
\n<\/a> <\/font><\/p>\n

.<\/p>\n

Test OID connection by clicking on “Test Connection<\/strong>” button<\/font><\/p>\n

<\/a><\/p>\n

– If UserName<\/strong> is OID is recognized by cn<\/strong> and NOT uid<\/strong> then change it in advanced name. (OID is using cn or uid as its userName is determined by orclcommonnicknameattribute<\/strong> value in OID)
\n– If OID is listening on SSL only<\/strong> and you entered SSL port in General Tab then select SSL checkbox<\/strong> in above screen
\n.
\nNote<\/strong> – OBI Server should be able to connect to OID server (If there is any firewall between BI Server and OID server open OID port across firewall<\/font>) .<\/p>\n

.<\/p>\n

.<\/p>\n

2. <\/strong>Configure initialization block for user authentication<\/strong><\/u><\/p>\n

2.1<\/strong> Administration Tool<\/strong> -> Manage<\/strong> -> Variables<\/strong> -><\/p>\n

<\/a><\/p>\n

.<\/p>\n

2.2<\/strong> Action -> New -> Session -> Initialization Block<\/p>\n

<\/a><\/p>\n

2.3<\/strong> In Session Variable Initialization Block window, enter Name<\/strong> for session variable and select “Required for Authentication<\/strong>” check box as shown in screenshot<\/p>\n

<\/a><\/p>\n

2.4<\/strong> Now click on “Edit Data Source<\/strong>” button as shows in above screen shot<\/p>\n

2.5<\/strong> From drop down list select “LDAP<\/strong>” as datasource and select Browse as shown in below screenshot<\/p>\n

<\/a><\/p>\n

2.6<\/strong> Select OID server<\/strong> which you created in step1 above and click OK<\/strong><\/p>\n

<\/a><\/p>\n

2.7<\/strong> Click OK on next screen<\/p>\n

<\/a><\/p>\n

2.8<\/strong> Now click on “Edit Data Target<\/strong>” button on Session Variable Initialization Block <\/strong>screen<\/p>\n

<\/a><\/p>\n

2.9<\/strong> Click on New<\/strong> and enter Name as USER<\/strong> in “System Session Variable<\/strong>” and click OK<\/strong> as shows in screenshot below<\/p>\n

<\/a><\/p>\n

2.10<\/strong> Enter the value of LDAP variable<\/strong> . This value is usually uid<\/strong> or cn<\/strong> (check value of orclcommonnicknameattribute<\/strong> in OID) and click OK<\/strong> as shown in below screenshot<\/p>\n

<\/a><\/p>\n

2.11<\/strong> Finally test your setup<\/strong> by clicking on Test button<\/strong> . Enter any valid Username, Password when prompted<\/p>\n

<\/a><\/p>\n

.<\/p>\n

.<\/p>\n

Related<\/strong><\/u><\/p>\n