OBIEE 10G/11G - Oracle BI ODBC driver

Bi Server Architecture With Client


The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection.

The BI Presentation Service and the Administration Tool use this connection method to connect and manage the BI Server : Check this article for more details

OBI Server can handle multiple repository but you can connect to only one at the same time by DSN Odbc Connection. Therefore, you must set up an ODBC connection for each repository.

In 11g, OBI is deployed in a clustered configuration by default. Because of this, the default ODBC DSN for the Oracle BI Server points to the Cluster Controller by default, rather than to the Oracle BI Server.

Example of use of the ODBC BI Server

When you have create an Analytics ODBC Data Source, you can use it:

Discover More
Obi Edition
OBIEE - Authentication (ATN)

Authentication in an OBIEE context. USERinit block1609872.1can authenticate a user The goal of the authentication configuration is to get a confirmation of the identity of a user based on the credentials...
Bi Server Architecture With Client
OBIEE - BI Server Clients (ODBC, JDBC)

The Open interface of BI Server gives the possibilities to made a client connection throught ODBC and JDBC. Clients of the Oracle BI Server see a logical schema view independent of the source physical...
Obi Edition
OBIEE - Client Tools

Oracle Business Intelligence provides the following client tools, which are supported only on 32-bit Windows operating systems: Oracle Business Intelligence ODBC Driver Oracle Business Intelligence...
Obiee Administration Tools Logon
OBIEE - How to connect remotely to the servers (BI, Presentation) ?

This article shows you how you can perform a remote connections with the OBIEE client tools Administration Tool and catalog manager to manage respectively : the BI Server and the web catalog Variable...
Choose Data Source
OBIEE - How to retrieve data from BI Server in Excel ?

An how-to which show how to use BI Server as a data source in excel In excel : Menu / Data / Import External Data / New DataBase Query Choose the ODBC Data Source used to connect to the repository...
Obiee Nqsgetleveldillability
OBIEE - Issue SQL (the IssueRawSQl Url)

The IssueRawSQl is a module of the saw url and permit to interact with the BI Server through the BI Server ODBC driver. It's then an ODBC client application. You can send: a logical sql of a BI...
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
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 Relationships Between Oracle Bi Infrastructure Components
OBIEE - Presentation Services Architecture

The Oracle Business Intelligence Presentation Services provides the framework and interface for presentation of Business Intelligence data to web clients. It maintains a Presentation Catalog service...
Obiee Driver Config Use Forward Only Cursor

To avoid the error: force the use of “Forward Only Cursor” in the OBIEE driver.

Share this page:
Follow us:
Task Runner