OBIEE - Data Source (Oracle Analytics Adapter)


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.


The Oracle BI Server connects to data sources using

Since the version, essbase is also supported.



$ORACLE_HOME/bi/modules/ contains the environment variable of the OBIS process where you can configure an external ODBC connection

  • TNS_ADMIN for the Oracle tnsnames
  • PATH

The ODBCINI is located at $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/bienv/core/odbc.ini.

Doc: Oracle® Fusion Middleware Metadata Repository Builder's Guide for Oracle Business Intelligence Enterprise Edition - 16 Setting Up Data Sources on Linux and UNIX

Non-dimensional data source

A non-dimensional data source is flat file with fact and dimension information in one row.

Powered by ComboStrap