Oracle BI Server has an extensible and open connectivity layer with a set of adapters that are responsible for communicating with source data servers.
An Oracle Analytics Adapter is a dynamically loaded library that can be configured to run within the Oracle BI Server process itself or in an external process. Individual adapters have been built to communicate with for the following systems:
The Oracle BI Server connects to data sources using
Since the version 10.1.3.3.2, essbase is also supported.
ORACLE_HOME/bi/modules/oracle.bi.cam.obis/env/obis.properties contains the environment variable of the OBIS process where you can configure an external ODBC connection
The ODBCINI is located at ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini.
A non-dimensional data source is flat file with fact and dimension information in one row.