OBIEE - Data Source (Oracle Analytics Adapter)

Bi Server Architecture With Client

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.

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.

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...
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
OBIEE - ODBC

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...
Obiee Sa System Presentation Layer
OBIEE 10G/11G - SA System subject area

The users who have worked with Siebel Analytics 7.7 or above, are aware of a special subject area called SA System subject area that was necessary to set up Delivers. With the advent of: the releases...



Share this page:
Follow us:
Task Runner