OBIEE - ODBC

About

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 a data source via its own odbc driver

Articles Related

Support Type

The Oracle Business Intelligence Server supports accessing:

• ODBC 2.0 and 2.1 compliant databases/data sources for 8-bit character sets.
• ODBC 3.5 compliant databases/data sources for UTF-16 (unicode) character sets.

DataDirect ODBC Drivers

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

Support

The connection has failed

The log is nqquery.log

Example:

• Specified driver could not be loaded

[nQSError: 16001] ODBC error state: IM003 code: 0 message: 
[DataDirect][ODBC lib] Specified driver could not be loaded. [[
[nQSError: 43093] An error occurred while processing the EXECUTE PHYSICAL statement.
[nQSError: 43119] Query Failed: 

• Driver does not support this function. Change the interface from 3.5 to 2 for instance.

[nQSError: 16001] ODBC error state: IM001 code: 0 message: 
[unixODBC][Driver Manager]Driver does not support this function. 
[nQSError: 16001] ODBC error state: S1000 code: 0 message: 
[unixODBC][Driver Manager]Driver returned SQL_ERROR or SQL_SUCCESS_WITH_INFO but no error reporting API found. (HY000)

Environment variable of the nqsserver

 cat /proc/`pidof nqsserver`/environ | tr \\0 \\n

Backtrace Example

Backtrace Example where we see the call the data direct driver (Merant/7.1.5/lib/libodbc.so)

/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilityserver64.so(_ZN71_GLOBAL__N_server_Utility_Server_Src_CrashHandler.cpp_CF4CBC2E_03BAD87B15bisCrashHandlerEiP7siginfoPv+0x1a9)[0x7fcd197dda89]
/lib64/libpthread.so.0[0x35bc60eb70]
/lib64/libc.so.6(cfree+0x1e)[0x35bba7288e]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65cd35]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65c0a0]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so[0x7fcd0b65c4d0]
/u01/app/oracle/product/fmw/Oracle_BI1/common/ODBC/Merant/7.1.5/lib/libodbc.so(SQLDriverConnect+0x149)[0x7fcd0b6453d7]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewayodbc64.so(_ZN8NQSQLAPI18NQSQLDriverConnectEPvS0_RKN3sup6StringIwN7_SASSTL9allocatorIwEEEES8_S8_tbS8_+0x1ee)[0x7fcd01cebc1e]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgatewayodbc64.so(_ZN24OdbcDataSourceConnection7ConnectERK6SignonbjN10ServerInfo17TxnIsolationLevelEi+0x28d)[0x7fcd01cfea2d]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilityserver64.so(_ZN20DataSourceConnection7ConnectERK6SignonbRK14GatewayOptions+0x7c)[0x7fcd1977932c]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbconnection64.so(_ZN12DbConnection9FixDamageERK14GatewayOptions+0x7c)[0x7fcd1f71a9ec]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbconnection64.so(_ZN19MultiThreadedDbPool22GetAvailableConnectionERK6SignonR17DbConnectionGuardRbRK14GatewayOptions+0x398)[0x7fcd1f72a138]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsdbgateway64.so(_ZN11NQDbGateway7PrepareEv+0xc98)[0x7fcd1f5ceaa8]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqsexecutionlist64.so(_ZN8Producer11ExecuteOnceEv+0xa80)[0x7fcd1ed0df40]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x85)[0x7fcd199d4ab5]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN15NQThreadJobBase17ExecuteSystemMainEv+0x55)[0x7fcd19a1a455]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN10PoolThread15ExecuteUserMainEv+0x325)[0x7fcd19a1bd95]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN16NQExecutionState17ExecuteSystemMainEv+0x85)[0x7fcd199d4ab5]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread17ExecuteSystemMainEv+0x5b)[0x7fcd19a1964b]
/u01/app/oracle/product/fmw/Oracle_BI1/bifoundation/server/bin/libnqutilitygeneric64.so(_ZN8NQThread15ThreadMainEntryEPv+0x32)[0x7fcd19a18d52]
/lib64/libpthread.so.0[0x35bc60673d]
/lib64/libc.so.6(clone+0x6d)[0x35bbad44bd]

Documentation / Reference

• More ? … Using the DataDirect Connect ODBC Drivers