IBM Support

CQM testing of vendor-supported client driver versions for each Cognos Analytics 12.0.x release

Detailed System Requirements


Abstract

This document lists the vendor-supported client driver versions that were tested using Compatible Query Mode (CQM) for each Cognos Analytics 12.0.x release.

Content

Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.3

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 12.0.3:
 
Database type
Compatible Query versions
IBM Db2 11.5.8 server
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: DB2 Client 11.05.0900
IBM Db2 11.5.9 server
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: DB2 Client 11.05.0900
Db2 for IBM i server 7.4
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: IBM Data Server Client 11.05.0900
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.027
Db2 for IBM i server 7.5
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: IBM Data Server Client 11.05.0900
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.027
Db2 Z Server 12.1.5
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: IBM Data Server Client 11.05.0900
Db2 Z Server 13.1.5
  • Windows: IBM Data Server Client 11.05.0900
  • Linux: IBM Data Server Client 11.05.0900
IBM Netezza Performance server 11.2.0.0
  • Windows: IBM Netezza ODBC Driver 11.2.1.4 [Build 37]
  • Linux: Not tested
Informix V12.10.XC14 server
  • Windows: Informix Client Software Development Kit 4.10 TC14
  • Linux: Informix Client Software Development Kit 4.10 UC15
Informix V14.10.XC10 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
MySQL 8.0.34 server
  • Windows: MySql ODBC Driver 08.00.0036
  • Linux: MySql ODBC Driver 08.00.0033
MySQL 8.0.35 server
  • Windows: MySql ODBC Driver 08.00.0036
  • Linux: MySql ODBC Driver 08.00.0033
MySQL 8.0.36 server
  • Windows: MySql ODBC Driver 08.00.0036
  • Linux: MySql ODBC Driver 08.00.0033
MySQL 8.1 server
  • Windows: MySql ODBC Driver 08.00.0036
  • Linux: MySql ODBC Driver 08.00.0033
Oracle Server 19.21
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 19.20.0.0
Oracle Server 21.10
  • Windows: Oracle Instant Client 21.8.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 21.11
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 23.3
  • Windows: Oracle Instant Client 21.12.0.0
  • Linux: Oracle Instant Client 21.3.0.0
PostgreSQL Server 15.5
  • Windows: PostgreSQL ODBC Driver 16.00.00.00
  • Linux: PostgreSQL ODBC Driver 15.00.0000
PostgreSQL Server 16.1
  • Windows: PostgreSQL ODBC Driver 16.00.0000
  • Linux: PostgreSQL ODBC Driver 15.00.0000
PostgreSQL Server 16.2
  • Windows: PostgreSQL ODBC Driver 16.00.0000
  • Linux: PostgreSQL ODBC Driver 15.00.0000
SQL Server 2019 CU23
  • Windows: Microsoft OLE DB Driver for SQL Server 19.3.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.3.2
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2019 CU24
  • Windows: Microsoft OLE DB Driver for SQL Server 19.3.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.3.2
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU10
  • Windows: Microsoft OLE DB Driver for SQL Server 19.3.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.3.2
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU11
  • Windows: Microsoft OLE DB Driver for SQL Server 19.3.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.3.2
  • Linux: DataDirect ODBC Driver 8.0.2.1222
Sybase ASE Server 16 SP4 PL03
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase ASE Server 16 SP4 PL04
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5 PLO7
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Sybase IQ Server 16.1 SP5 PLO8
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Teradata 17.10 server
  • Windows: Teradata ODBC Driver 20.00.00.004
  • Linux: Teradata ODBC Driver 20.00.00.04
Teradata 17.20 server
  • Windows: Teradata ODBC Driver 20.00.00.004
  • Linux: Teradata ODBC Driver 20.00.00.04
Vertica 12 server
  • Windows: Vertica ODBC Driver 23.03.0000
  • Linux: Vertica ODBC Driver 9.02.0100
Vertica 24.1 server
  • Windows: Vertica ODBC Driver 23.03.0000
  • Linux: Vertica ODBC Driver 9.02.0100
 

Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.2

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 12.0.2:
 
Database type
Compatible Query versions
IBM Db2 11.5.8 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Db2 11.5.9 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 for IBM i server 7.4
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.027
Db2 for IBM i server 7.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.027
Db2 Z Server 12.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 Z Server 13.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Netezza Performance server 11.2.0.0
  • Windows: IBM Netezza ODBC Driver 11.2.1.4 [Build 37]
  • Linux: Not tested
Informix V12.10.XC14 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
Informix V14.10.XC10 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
MySQL 8.0.33 server
  • Windows: MySql ODBC Driver 08.00.35.00
  • Linux: MySql ODBC Driver 08.00.0033
MySQL 8.1 server
  • Windows: MySql ODBC Driver 08.00.35.00
  • Linux: MySql ODBC Driver 08.00.0027
Oracle Server 19.19
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 19.20
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 21.10
  • Windows: Oracle Instant Client 21.8.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 21.11
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle Server 23.3
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
PostgreSQL Server 15.4
  • Windows: PostgreSQL ODBC Driver 13.02.00.00
  • Linux: PostgreSQL ODBC Driver 15.00.0000
PostgreSQL Server 16.0
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 15.00.0000
SQL Server 2019 CU21
  • Windows: Microsoft OLE DB Driver 19 for SQL Server 19.3.2.0
  • Windows: ODBC Driver 18 for SQL Server 18.3.2.1
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2019 CU23
  • Windows: Microsoft OLE DB Driver 19 for SQL Server 19.3.2.0
  • Windows: ODBC Driver 18 for SQL Server 18.3.2.1
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU7
  • Windows: Microsoft OLE DB Driver 19 for SQL Server 19.3.2.0
  • Windows: ODBC Driver 18 for SQL Server 18.3.2.1
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU8
  • Windows: Microsoft OLE DB Driver 19 for SQL Server 19.3.2.0
  • Windows: ODBC Driver 18 for SQL Server 18.3.2.1
  • Linux: DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU9
  • Windows: Microsoft OLE DB Driver 19 for SQL Server 19.3.2.0
  • Windows: ODBC Driver 18 for SQL Server 18.3.2.1
  • Linux: DataDirect ODBC Driver 8.0.2.1222
Sybase ASE Server 16 SP4 PL03
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase ASE Server 16 SP4 PL04
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5 PLO7
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Sybase IQ Server 16.1 SP5 PLO8
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Teradata 17.10 server
  • Windows: Teradata Database ODBC Driver 17.20.00.22
  • Linux: Teradata ODBC Driver 20.00.00.04
Teradata 17.20 server
  • Windows: Teradata Database ODBC Driver 17.20.00.22
  • Linux: Teradata ODBC Driver 20.00.00.04
Vertica 12 server
  • Windows: Vertica ODBC Driver 23.03.0000
  • Linux: Vertica ODBC Driver 9.02.0100
Vertica 23 server
  • Windows: Vertica ODBC Driver 23.03.0000
  • Linux: Vertica ODBC Driver 9.02.0100
 

Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.1

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 12.0.1:
 
Database type
Compatible Query versions
IBM Db2 11.5.8 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 for IBM i server 7.4
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.026
Db2 for IBM i server 7.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.026
Db2 Z Server 12.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 Z Server 13.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Netezza Performance server 11.2.0.0
  • Windows: Netezza ODBC Driver 11.2.1.4
  • Linux: Netezza ODBC Driver 11.2.1.1
Informix V12.10.XC14 server
  • Windows: Informix Client Software Development Kit 4.10 TC14
  • Linux: Informix Client Software Development Kit 4.10 UC15
Informix V14.10.XC10 server
  • Windows: Informix Client Software Development Kit 4.10 TC14
  • Linux: Informix Client Software Development Kit 4.10 UC15
MySQL 8.0.32 server
  • Windows: MySql ODBC Driver 08.00.0033
  • Linux: MySql ODBC Driver 08.00.0032
MySQL 8.0.33 server
  • Windows: MySql ODBC Driver 08.00.0033
  • Linux: MySql ODBC Driver 08.00.0033
Oracle Server 19.19
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 19.17.0.0
Oracle Server 21.9
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
PostgreSQL Server 14.5
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 15.3
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
SQL Server 2019 CU20
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18.3 for SQL Server (MSODBCSQL18.DLL 18.00.0003)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1222
SQL Server 2019 CU21
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18.3 for SQL Server (MSODBCSQL18.DLL 18.00.0003)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU2
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1120
SQL Server 2022 CU4
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18.3 for SQL Server (MSODBCSQL18.DLL 18.00.0003)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1222
SQL Server 2022 CU5
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18.3 for SQL Server (MSODBCSQL18.DLL 18.00.0003)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1222
Sybase ASE Server 16 SP4 PL03
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase ASE Server 16 SP4 PL04
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5 PLO7
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Sybase IQ Server 16.1 SP5 PLO8
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Teradata 17.10 server
  • Windows: Teradata ODBC Driver 17.20.00.015
  • Linux: Teradata ODBC Driver 17.20.00.015
Teradata 17.20 server
  • Windows: Teradata ODBC Driver 17.20.00.020
  • Linux: Teradata ODBC Driver 17.20.00.020
Vertica 12.0.4 server
  • Windows: Vertica ODBC Driver 12.00.0100
  • Linux: Vertica ODBC Driver 9.02.0100
 

Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.0

The following driver versions were tested using CQM on relational data sources with Cognos Analytics 12.0.0:
 
Database type
Compatible Query versions
IBM Db2 11.5.8 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 for IBM i server 7.4
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.026
Db2 for IBM i server 7.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
  • Windows: DB2 iSeries ODBC Driver: 07.01.027
  • Linux: DB2 iSeries ODBC Driver: 07.01.026
Db2 Z Server 12.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
Db2 Z Server 13.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Netezza Performance server 11.2.0.0
  • Windows: Netezza ODBC Driver 11.2.1.4
Informix V12.10.XC14 server
  • Windows: Informix Client Software Development Kit 4.10 TC14
  • Linux: Informix Client Software Development Kit 4.10 UC15
Informix V14.10.XC9 server
  • Windows: Informix Client Software Development Kit 4.10 TC14
  • Linux: Informix Client Software Development Kit 4.10 UC15
MySQL 8.0.31 server
  • Windows: MySql ODBC Driver 08.00.0032
  • Linux: MySql ODBC Driver 08.00.0031
MySQL 8.0.32 server
  • Windows: MySql ODBC Driver 08.00.0032
  • Linux: MySql ODBC Driver 08.00.0032
Oracle Server 19.17
  • Windows: Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux: Oracle Instant Client (19.17) - 19.17.0.0.0
Oracle Server 19.18
  • Windows: Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux: Oracle Instant Client (21.3) - 21.3.0.0.0
Oracle Server 21.8
  • Windows: Oracle Database 21c Client (21.8) - 21.8.0.0.0
  • Linux: Oracle Instant Client (21.3) - 21.3.0.0.0
Oracle Server 21.9
  • Windows: Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux: Oracle Instant Client (21.3) - 21.3.0.0.0
PostgreSQL Server 14.5
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 15.0
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 15.1
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 15.2
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
SQL Server 2019 CU19
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18.1 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1120
SQL Server 2022 CU1
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux-x86-DataDirect ODBC Driver 8.0.2.1120
Sybase ASE Server 16 SP4
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5 PLO7
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Teradata 17.10 server
  • Windows: Teradata ODBC Driver 17.20.00.015
  • Linux: Teradata ODBC Driver 17.20.00.015
Teradata 17.20 server
  • Windows: Teradata ODBC Driver 17.20.00.010
  • Linux: Teradata ODBC Driver 17.20.00.003
Vertica 12.0.3 server
  • Windows: Vertica ODBC Driver 11.00.0100
  • Linux: Vertica ODBC Driver 9.02.0100

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"12.0.0;and future releases"}]

Document Information

Modified date:
25 April 2024

UID

ibm17112270

Page Feedback