Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Use Oracle Instant Client for OBIEE

Posted by Dylan Wan on August 16, 2007

Oracle BI Server shipped the Oracle Merant ODBC Driver from DataDirect technology.  The ODBC driver files are stored under X:\OracleBI\DAC\oraclemerantodbc

It does a license check so you may receive a warning when you connect to a non-Siebel database.  I received a message when I tried to recalculate the row count in the Oracle BI Server Administration Tool for connecting to a non-Siebel database..

I just installed the Oracle ODBC Instant Client to solve this problem.  It does not require Oracle Home and the installation is very simple.  It took less then 10 minutes for downloading and installing the files.

I do not have a ORACLE_HOME in my machine since I am using the Oracle XE.  The only problem I have found for using XE is that BIEE and XE are running different OC4J servers so I have multiple web server instances on my machines.  Fortunately Oracle Express takes the port 8080 as the default and the OC4J for analytics is running under the port 9704, so they are not conflicting with each other.

To run the Oracle BI Application, you don’t need to install a separate application server.  The OC4J server is packaged with the Oracle BI Enterprise Edition platform and you can put your web page files under X:\OracleBI\oc4j_bi\j2ee\home\default-web-app.


2 Responses to “Use Oracle Instant Client for OBIEE”

  1. […] Dylan Wan Did an interesting post today on dylanwan.wordpress.comRead this summary: […]

  2. Informática Para Seres Humanos….

    […]Use Oracle Instant Client for OBIEE « Dylan’s BI Study Notes[…]…

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