Integrating Oracle eBS and Oracle BI EE – Getting started

I have been playing around with Oracle eBS Release 12 and Oracle BI EE 10g. 

In Release 12 the integration is very straight forward. If you would like to achieve the same functionality in Release 11, you need to do some patching first.

Lucky enough for me I am able to use an Release 12 environment.

select release_name
from   applsys.fnd_product_groups

All I had to do was set the ‘FND: Oracle Business Intelligence Suite EE base URL’-profile in Oracle eBS.

This would be something like; http://[hostname.domain_name]:[port_number]

statement:

select fnd_profile.value('FND_OBIEE_URL') oracle_bi_url
from   dual

Now Oracle eBS nows where to find Oracle BI.

Secondly I had to change the way Oracle BI authenticates in the instanceconfig.xml file. This way you can login to Oracle BI via Oracle eBS. You use your Oracle eBS credentials to login to Oracle BI directly.

   <Auth>
   <ExternalLogon enabled="true">
      <ParamList>
      <Param name="NQ_SESSION.ICX_SESSION_COOKIE"
         source="cookie"
         nameInSource="VIS"/>
      <Param name="NQ_SESSION.ACF"
         source="url"
         nameInSource="acf"/>
      </ParamList>
   </ExternalLogon>
   </Auth>  

Last but not least, you change your connection settings in the Repository of Oracle BI and you are good to go.

If you would like to see how the integration between Oracle eBS and Oracle BI works, I can recommend a blogpost of Gerard Braat.

Robin Moffat has written a good explanation about how to validate EBS-BI authentication, without BI.

Author: Daan Bakboord

I am an Oracle Big Data Analytics Consultant with great interest in anything closely related to the Oracle Big Data Analytics (OBIEE, BICS, OAC, Big Data, Data Integration, Data Visualization, Data Management, Data Architecture).

One thought on “Integrating Oracle eBS and Oracle BI EE – Getting started”

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s