OBIS - JDBC

Bi Server Architecture With Client

About

This page is about how to use Oracle Bi Server as a data source via JBDC.

It's possible to make a connection with the presentation layer of the repository through JDBC and to query it via the OBIEE - BI Server (OBIS|nqsserver|nqs)

For a step by step, see this blog

Management

Driver

The Jdbc driver of Oracle BI Server is a part of the BI Open Interface and is located in the directory:

  • 10g: OracleBIHome\jdbc
  • 11g: {Middleware_home}\Oracle_BI1\bifoundation\jdbc\lib (See the Readme.txt in the same directory for more information)
  • 12c: {Middleware_home}\bi\clients

You can find the following file: bijdbc.jar

A bijdbc14.jar has existed and wasused by BIP in the directory OC4J_Home\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF\lib

URL

The Jdbc connections parameters are available here

Built-in Function

OBIEE - BI Server (JDBC|ODBC) Driver Functions




Discover More
Card Puncher Data Processing
BIP 10G - Configuration with OBIEE 10G

When you have to configure BIP to work completely with OBIEE, you will have then three main tasks to perform: the configuration of the security through the OBIEE BI Server the configuration of the...
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 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 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 10g - Oracle BI Open Intelligence Interface (ODBC and JDBC) client connectivity

Some sites use third-party analytical tools, such as spreadsheets and databases, which require connectivity to the Oracle BI Server (ie the BI Server becomes a data source) The Oracle BI Open Intelligence...
Dbeaver Driver Obiee
WeBlog - How to query and get data from OBIEE with a database client (Jdbc)

This article will show you how you can query data in OBIEE through a database client application. This is actually really handy when you want to: create automatic test to control the repository design...



Share this page:
Follow us:
Task Runner