OBIEE - Data Direct ODBC drivers

Bi Server Architecture With Client

About

Since Oracle BI EE 10.1.3.3.1, the installation provides DataDirect Connect ODBC drivers and driver managers for Linux and UNIX operating systems for connectivity to

DB2 Wire Protocol=DataDirect 7.1 DB2 Wire Protocol
Informix Wire Protocol=DataDirect 7.1 Informix Wire Protocol
Oracle Wire Protocol=DataDirect 7.1 Oracle Wire Protocol
Sybase Wire Protocol=DataDirect 7.1 Sybase Wire Protocol
Teradata=DataDirect 7.1 Teradata
SQL Server Wire Protocol=DataDirect 7.1 SQL Server Wire Protocol
MySQL Wire Protocol=DataDirect 7.1 MySQL Wire Protocol
PostgreSQL Wire Protocol=DataDirect 7.1 PostgreSQL Wire Protocol
Greenplum Wire Protocol=DataDirect 7.1 Greenplum Wire Protocol
Salesforce=DataDirect 7.1 Salesforce
Sybase IQ Wire Protocol=DataDirect 7.1 Sybase IQ Wire Protocol
Progress OpenEdge Wire Protocol=DataDirect 7.1 Progress OpenEdge Wire Protocol
Apache Hive Wire Protocol=DataDirect 7.1 Apache Hive Wire Protocol
Impala Wire Protocol=DataDirect 7.1 Impala Wire Protocol

Management

Location

The DataDirect Connect ODBC drivers are installed in the following location:

  • 10G: OracleBI/odbc: The 32-bit drivers are installed in OracleBI/odbc/lib and 64-bit drivers are installed in OracleBI/odbc/lib64.
  • 11G: FMW_HOMEOracle_BI1/common/ODBC

Architecture (32 vs 64 bit)

Communication between database clients and servers is typically independent of the widths and data paths. In other words, the 32-bit database drivers will communicate with 64-bit database servers, and vice versa.

Update

See : OBIEE 11g: How To Obtain Updated ODBC Drivers (Doc ID 1542558.1)

Version

$FMW_HOME/Oracle_BI1/bin/datadirect_version.sh -l
5.3
6.0
6.1
7.0
7.0.1
7.1.4
7.1.5

Documentation / Reference





Discover More
Bi Server Architecture With Client
OBIEE - ODBC

ODBC ODBC is closer related to the BI Server. It uses it to: retrieve data from data source in the back-end through the physical layer but also to expose the presentation catalog of BI Server as...



Share this page:
Follow us:
Task Runner