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:
- Relational Database Systems: including Oracle, UDB DB2, OS390 DB2, AS400DB2, SQL Server, Teradata, Red Brick, Informix, Sybase, and Microsoft SQL-Server.
- Various Host Data Sources including VSAM, IDMS, IMS, and CICS.
- Enterprise Applications including Oracle, Peoplesoft Enterprise, JD Edwards Enterprise One, Oracle e-Business Suite, and SAP R/3 and mySAP.
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
- LIBRARY_PATH or LIBPATH
- TNS_ADMIN for the Oracle tnsnames
The ODBCINI is located at ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini.
Non-dimensional data source
A non-dimensional data source is flat file with fact and dimension information in one row.