OBIEE - Data Direct ODBC drivers

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

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

3 - Management

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

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

3.3 - Update

3.4 - 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

4 - Documentation / Reference