Supported ODBC drivers and relational data sources

In most cases, DB2 OLAP Server and DB2 OLAP Integration Server require the minimal levels of ODBC drivers. If you install both products, check the following tables to make sure that you use an ODBC driver that meets the minimum requirements of both products.

For DB2 OLAP Server

DataDirect Technologies (formerly MERANT) ODBC driver version 4.2 is provided with the DB2 OLAP Server Version 8.2. DB2 OLAP Server also supports other drivers, which are listed in Table 12.

Table 12. Supported ODBC drivers for DB2 OLAP Server
Relational Database Server (Relational Data Source) ODBC drivers per supported operating system
Windows 2000, Windows 2003, Windows XP Solaris 8, 9 (Sun OS 5.8, or 5.9) AIX 5.1, 5.2 HP-UX 11.0, HP-UX 11i Red Hat Linux AS 2.1
DB2 UDB 7.2 (Wired drivers) DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2
DB2 UDB 8.1 (Wired drivers) DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2
Informix(R) 9.x 1 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Oracle 8i DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Oracle 9i DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Teradata V2 R4.1 TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC Not Supported
Teradata V2 R5 TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC Not Supported
MS SQL Server 7.0 MS SQL Server 3.70 ODBC DataDirect 4.2 Not supported DataDirect 4.2 DataDirect 4.2
MS SQL Server 2000 MS SQL Server 3.70 ODBC DataDirect 4.2 Not supported DataDirect 4.2 DataDirect 4.2
Sybase 12.0 1 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Sybase 12.5 1 (Adaptive Server) DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Access 2000 1 Microsoft Driver Not supported Not supported Not supported Not Supported
Access 2002 1 Microsoft Driver Not supported Not supported Not supported Not Supported
Notes:
  1. The Informix 9x, Sybase 12.0, Sybase 12.5, Access 2000, and Access 2002 databases are supported with SQL Interface, but they are not supported with Hybrid Analysis.

For DB2 OLAP Integration Server

DB2 OLAP Integration Server supports the ODBC drivers for the relational database management systems (RDBMS) and operating systems shown in Table 13. Unless otherwise noted, client software is not required for the database server.

Table 13. Supported ODBC drivers for DB2 OLAP Integration Server
Relational Database Server (Relational Data Source) ODBC drivers per supported operating system
AIX 5.1, 5.2 HP-UX 11.0, HP-UX 11i Solaris Operating System 8, 9 (Sun OS 5.8, 5.9) Red hat Linux AS 2.1 Windows 2000, Windows 2003, Windows XP
DB2 UDB 7.2, FP7 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2 DB2 UDB 7.2 ODBC, DataDirect 4.2
DB2 UDB 8.1 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2 DB2 UDB 8.1 ODBC, DataDirect 4.2
DB2 UDB for z/OS(R) and OS/390(R) V7 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Informix 9.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Informix 9.3 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
MS SQL Server 7.0 Not supported DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 MS SQL Server 3.7 ODBC (included in MDAC 2.6)
MS SQL Server 2000 Not supported DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 MS SQL Server 3.7 ODBC (included in MDAC 2.6)
Oracle 8i (Oracle 8i 32-bit client required with OCI direct connection) DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 DataDirect 4.2 Wire Protocol, OCI direct connection
Oracle 9i (Oracle 8i 32-bit client required with OCI direct connection) DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 Wire Protocol, OCI direct connection DataDirect 4.2 DataDirect 4.2 Wire Protocol, OCI direct connection
Sybase 12.0 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Sybase 12.5 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2 DataDirect 4.2
Teradata V2 R5.0 TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC TUF 7.0 with Teradata 3.2 ODBC Not Supported TUF 7.0 with Teradata 3.2 ODBC

ODBC drivers used with DB2 OLAP Integration Server must be thread-safe. All drivers listed in Table 13 are thread-safe. HP-UX requires kernel-threads. Solaris Operating System requires Solaris threads, and AIX requires kernel-threads with pthread API.