OBIEE - BI Server Clients (ODBC, JDBC)

Bi Server Architecture With Client

About

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 database schemas. Oracle BI Server clients submit simplified logical SQL, which ultimately gets translated by the server to some combination of physical SQL sent to the back-end databases, in addition to intermediate processing within the Oracle BI Server Execution Engine.

Technology

ODBC

By default, OBIEE provides several ODBC clients:

which permit you to made ODBC calls via the Analytics ODBC driver such as an odbc function.

JDBC

Any Jdbc client can easily made a JDBC connection with the BI Jdbc driver.





Discover More
Saw Object
OBIEE - BI Presentation Service (SAW/OBIPS)

AnswersInteractive DashboardsDelivers The Oracle BI Presentation Service Server: is a pure Web Environment visualize data from the Oracle BI Server through the creation of Interactive Dashboards...
Obiee Nqsgetleveldillability
OBIEE - BI Server (JDBC|ODBC) Driver Functions

The Bi Server interface functions permit: to get data dictionary information. to manage the query cache to set a repository session variable You can call them : through a client that provides...
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...
Logical Business Model
OBIEE - Common Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)

The Logical Business Model is the three-layer metadata model of the repository and its aim is to build a known also as a model-centric view (as compared to report-centric view of information). Each layer...
Bi Server Architecture With Client
OBIEE - EXECUTE PHYSICAL CONNECTION POOL Statement

The EXECUTE PHYSICAL CONNECTION POOL Statement permit you to execute Physical SQL statement from a BI Server Client where: myConnectionPool is the fully qualified name of a connection pool (ie...
Obi Edition
OBIEE - Localization

localization refers to the process of adapting the Oracle Business Intelligence deployment to a particular language. Part of the process of customizing is localizing the interface, if...
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
OBIEE - ODBC Client

ODBC Client is a standard ODBC client provide with the default installation of OBIEE (Only in 10g) It permit to issue any SQL against an ODBC data source. It's a good way to confirm performance issue...
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...
Bi Server Architecture With Client
OBIEE - Server Thread

A Obiee server thread is a thread that execute the BI server to serve clients (such as Answers, nqsserver, ...) You can have more sessions than threads but in this case, the session must wait for a free...



Share this page:
Follow us:
Task Runner