*****************************************************************
September 2003
*****************************************************************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.
Starting in Fix Pack 3, Data Direct (formerly Data Direct) ODBC version 4.1 drivers are provided with the SQL Interface in DB2 OLAP Server, Version 8.1. Additionally, DB2 OLAP Server also supports some non-Data Direct Windows drivers, which are listed in the following table. These non-Data Direct drivers are not provided with SQL Interface.
| Relational Database Server (Relational Data Source) |
ODBC Drivers per supported operating system | ||||
| Windows NT 4.0, Windows 2000, Windows XP | Solaris 7, 8 (Sun OS 5.7, or 5.8) | AIX 4.3.3, AIX 5L (AIX 5.1, 5.2) | HP-UX 11.0, HP-UX 11i | Linux Redhat 7.3 | |
| DB2 UDB 7.2 | DB2 UDB 7.2 ODBC, Data Direct 4.1 | DB2 UDB 7.2 ODBC, Data Direct 4.1 | DB2 UDB 7.2 ODBC, Data Direct 4.1 * | DB2 UDB 7.2 ODBC, Data Direct 4.1 | DB2 UDB 7.2 ODBC, Data Direct 4.1 |
| DB2 UDB 8.1 (Wired drivers) | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC |
| Oracle 8i (SQL Net 8) (Wired drivers) | Data Direct 4.1 | Data Direct 4.1 | Data Direct 4.1* | Data Direct 4.1 | Data Direct 4.1 |
| Oracle 9i (Wired drivers) | Data Direct 4.1 | Data Direct 4.1 | Data Direct 4.1* | Data Direct 4.1 | Data Direct 4.1 |
| Teradata V2R4.1 | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Not supported |
| Teradata V2R5 | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Teradata 3.2 ODBC | Not supported |
| MS SQL Server 7.0 | MS SQL Server 3.70 ODBC | Data Direct 4.1 (Wired drivers) | Data Direct 4.1 * (Wired drivers) | Data Direct 4.1 (Wired drivers) | Data Direct 4.1 (Wired drivers) |
| MS SQL Server 2000 | MS SQL Server 3.70 ODBC | Data Direct 4.1 (Wired drivers) | Data Direct 4.1 * (Wired drivers) | Data Direct 4.1 (Wired drivers) | Data Direct 4.1 (Wired drivers) |
| Sybase 12.0 (Wired drivers) | Data Direct 4.1 | Data Direct 4.1 | Data Direct 4.1 * | Data Direct 4.1 | Data Direct 4.1 |
| Sybase 12.5 (Wired drivers) | Data Direct 4.1 | Data Direct 4.1 | Data Direct 4.1 * | Data Direct 4.1 | Data Direct 4.1 |
| Informix 9.x (Wired drivers) | Data Direct 4.1 | Data Direct 4.1 | Data Direct 4.1 * | Data Direct 4.1 | Not supported |
| Access 2000 | Microsoft driver | Not supported | Not supported | Not supported | Not supported |
| Access 2002 | Microsoft driver | Not supported | Not supported | Not supported | Not supported |
| DBASE V | Microsoft driver | Not supported | Not supported | Not supported | Not supported |
Notes:
* DataDirect 4.1 ODBC drivers support only AIX 4.3.3 and AIX 5.1 but not 5.2.
DB2 OLAP Integration Server supports the ODBC drivers for the relational
database management systems (RDBMS) and operating systems shown in the following
table:
| Relational Database Server (Relational Data Source) |
ODBC Drivers per supported operating system | |||
| AIX 4.3.3, AIX 5L | HP-UX 11.0, HP-UX 11i * | Solaris Operating System 7, 8 (Sun OS 5.7, 5.8) | Windows NT 4.0, Windows 2000, Windows XP | |
| DB2 UDB 7.2 | DB2 UDB 7.2 ODBC, Data Direct 4.1 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.1 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.1 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.1 Wire Protocol |
| DB2 UDB 8.1 (DB2 UDB 8.1 client required) | DB2 UDB 8.1 ODBC (Also supported on AIX 5.2) | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC |
| Informix 9.2 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol |
| Informix 9.3 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol |
| MS SQL Server 7.0 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | MS SQL Server 3.7 ODBC (included in MDAC 2.6) |
| MS SQL Server 2000 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | MS SQL Server 3.7 ODBC
(included in MDAC 2.6) MS SQL Server 2000 ODBC1 |
| Oracle 8i (Client required with OCI direct connection) | Data Direct 4.1 Wire Protocol OCI direct connection (AIX 5.2 supported with 8i 32-bit client) | Data Direct 4.1 Wire Protocol, OCI direct connection | Data Direct 4.1 Wire Protocol, OCI direct connection | Data Direct 4.1 Wire Protocol, OCI direct connection |
| Oracle 9i (Client required with OCI direct connection) | Data Direct 4.1 Wire Protocol, OCI direct connection (AIX 5.2 supported with 8i 32-bit client) | Data Direct 4.1 Wire Protocol, OCI direct connection | Data Direct 4.1 Wire Protocol, OCI direct connection | Data Direct 4.1 Wire Protocol, OCI direct connection |
| Sybase 12.0 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol |
| Sybase 12.5 | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol | Data Direct 4.1 Wire Protocol |
| Teradata V2R4.12 ** | 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 |
| Teradata V2R5** | 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 |
Notes:
* MS SQL Server 2000 driver must be purchased separately from Microsoft.
** Teradata ODBC drivers must be purchased separately from the NCR Corporation.