About
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.
- OLAP Sources including Oracle Database OLAP Services, Microsoft Analysis Services Cubes, Hyperion Essbase, and SAP BW Infocubes.
- XML Data Sources including access to other types of data servers (e.g., other non-relational servers), Microsoft Excel spreadsheets, and Web Services.
Articles Related
Adapters
The Oracle BI Server connects to data sources using
Since the version 10.1.3.3.2, essbase is also supported.
Configuration
12C
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
- PATH
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.