OBIEE - Data Source (Oracle Analytics Adapter)

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - 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.
Advertising

3 - Adapters

The Oracle BI Server connects to data sources using

Since the version 10.1.3.3.2, essbase is also supported.

4 - Configuration

4.1 - 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.

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

Advertising

5 - Non-dimensional data source

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