Business Intelligence – Oracle

Oracle BI EE 10.1.3.3/2 – Open Intelligence Interface

Posted by Venkatakrishnan J on October 23, 2007

One of the major advantages of BI EE is that BI Server exposes itself in the form of ODBC so that any other utlity/reporting tool can leverage the metadata of BI EE. In fact, any other reporting tool(which can use ODBC) can leverage this metadata. Let us take a sample scenario. Lets say we have installed BI EE on one machine A(including BI Server and Presentation Services). And say you have another reporting tool on Machine B. So, the question is how do we make the reporting tool on Machine B leverage the metadata of BI EE, which is on machine A? To understand better i have depicted the scenario using a diagram below.

      

So, coming back to question of how do we make BI EE available to the Custom Reporting Tool on Machine B, all we need to do is to install a product called Open Intelligence Interface on machine B. It generally is bundled under the Client_Ancillary folder of the BI EE software bundle. What this product basically does is it installs a ODBC driver for Oracle BI Server. Once you have this installed this product you can create a ODBC DSN using the Oracle BI Server ODBC driver and can connect to any BI Server. So, while creating the DSN just use the Oracle BI Server odbc driver as shown below.

      

      

Now you can use this DSN within your reporting tool and can start reporting using BI Server metadata. Though this is pretty straight forward i thought i would blog about this since it is a very handy utility

Advertisements

3 Responses to “Oracle BI EE 10.1.3.3/2 – Open Intelligence Interface”

  1. Heidi said

    Hi Venkatakrishnan, I followed your direction to load the BI Server ODBC driver using the Open Intelligence Interface and it completed successfully. Unfortunately, after the reboot, the BI Server driver did not appear. I have installed BI Server to the D drive of one VM server and Presentation Services on the D drive of another VM server.

    Thanks!

  2. Heidi said

    …sorry, so the question is, do you have any suggestions for installing this driver?

  3. Utsav Jaiswal said

    Hi,

    I installed both Oracle BI Server and Oracle BI ODBC Driver on my machine. I also got listed Oracle BI Server in System DSN list. but when i am going to connect my reporting tool with the Oracle BI Server DSN, it pops me error message “The Driver Doesnt support this function”. Can you help me out to resolve this issue?

    Thanks in advance

    Regards,
    Utsav

Leave a Reply

Fill in your details below or click an icon to log in:

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

 
%d bloggers like this: