Table of Contents

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:

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