OBIEE - Data Source (Oracle Analytics Adapter)

Bi Server Architecture With Client


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.

Discover More
Bi Server Architecture With Client
OBIEE - Physical Layer

The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information the physical data sources. The most common way to...
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Obi Edition
OBIEE - Calculation

A Pass-through calculation is not computed by the Oracle BI Server but is passed to another data source. Enables advanced users to leverage data source features and functions without the need to modify...
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Obiee Essbase Unbalanced Hierarchy
OBIEE - Essbase

Cube scope: Member attributesunbalanced hierarchies“”“”hierarchy columnattribute column Support...
Bi Server Architecture With Client
OBIEE - Federated Query / Multi-Database or Cross-Database Join

Data can exist in many different places. Instead of moving data to a single database, the BI Server can access multiple databases simultaneously to answer a single query, regardless of whether the databases...
Bi Server Architecture With Client

ODBC ODBC is closer related to the BI Server. It uses it to: retrieve data from data source in the back-end through the physical layer but also to expose the presentation catalog of BI Server as...
Obiee Query Log
OBIEE - Physical SQL

The physical SQL is the SQL that send the BI Server to the data sources in order to retrieve data. This SQL is most of the time generated by the query compiler during the query processing of the logical...
Obiee Combine With Similar Request
OBIEE 10G - Reporting on Multiple Subject Area (Advanced Logical SQL)

In 11G, you can easily joins two subject areas. This article shows advanced logical SQL statement for the sake of knowledge and was written on a 10G because within an answer, it was possible through the...
Obiee Physical Alias Table Cannot Be Deleted
OBIEE 10G/11G - Physical Alias

Use physical aliases in the Physical layer with consistent naming conventions to: order the physical tables easily identify the data source in the business logical model. to identify the tables...

Share this page:
Follow us:
Task Runner