OBIEE - ODBC

Bi Server Architecture With Client

About

To know the basis of ODBC, check this article: ODBC.

ODBC is closer related to the BI Server. It uses it to:

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




Discover More
Bi Server Architecture With Client
OBIEE - Physical Layer

The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information the physical data sources. The most common way to...
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...
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Bi Server Architecture With Client
OBIEE - Data Direct 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...
Bi Server Architecture With Client
OBIEE - Data Source (Oracle Analytics Adapter)

Oracle BI Server has an extensible and open connectivity layer with a set of adapters that are responsible for communicating with source data servers. An Oracle Analytics Adapter is a dynamically loaded...
Obiee Dsn Configuration 1
OBIEE 10G/11G - How to create an Analytics ODBC Data Source (System DSN ODBC connexion)

How to create an odbc DSN to be able to connect to the OBIEE BI Server ? On Windows XP (), go to Control Panel / Administration Tools and open “Data Sources ODBC”. Go to the “System DNS”...
Bi Server Architecture With Client
OBIEE 10G/11G - Oracle BI ODBC driver

The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection. The BI Presentation Service and the Administration Tool use this connection method to connect...
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...



Share this page:
Follow us:
Task Runner