OBIS - JDBC

Bi Server Architecture With Client

OBIS - JDBC

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....
Obi Edition
OBIEE 10G - Linux OEL 5 x86 Installation version 10.1.3.4.1

Open the Set the JavaHome parameter to the point to the new JDK location. For example, . tail Oracle BI Java Host start-up details: /usr/local/OracleBIData/web/log/javahost.out.log Oracle BI Java...
Obiee Connection Pool
OBIEE 10G/11G - Oracle Call Interface (OCI) configuration

This page shows you how to install an OCI driver with OBIEE. To use it you have to install it on the BI Server machine through an Oracle Client installation (for instance an Oracle Database, an...
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