OBIEE - BI Server Clients (ODBC, JDBC)

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

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

Advertising

3 - Technology

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

3.2 - JDBC

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