IBM Support

CQM testing of vendor-supported client driver versions for each Cognos Analytics 11.2.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 11.2.x release.

Content

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.4 FP3:
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 11.2.4 FP2

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.4 FP2:
 
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.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
Oracle Server 19.18
  • Windows: Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux: Oracle Instant Client - 19.17.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.2
  • 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 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 2019 CU20
  • 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
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 CU3
  • 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 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.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

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.4 FP1:
 
Database type
Compatible Query versions
Vertica 12.0 server
  • Windows: Vertica ODBC Driver 11.00.0200
  • Linux: Vertica ODBC Driver 9.2.1
Teradata 17.10 server
  • Windows Teradata ODBC Driver Version 17.20.00.002
  • Linux-x86-Teradata ODBC Driver Version 17.20.00.003
Teradata 17.20 server
  • Windows: Teradata ODBC Driver 17.20.00.002

  • Linux: Teradata ODBC Driver 17.20.00.003

IBM Db2 iSeries Server 7.4
IBM Db2 iSeries 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.026
  • Linux: DB2 iSeries ODBC Driver: 07.01.025
IBM Db2 Z Server 13
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Db2 11.5.8 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
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
MySQL 8.0.30 server
  • Windows: MySql ODBC Driver 08.00.0032
  • Linux: MySql ODBC Driver 08.00.0030
MySQL 8.0.31 server
  • Windows: MySql ODBC Driver 08.00.0032
  • Linux: MySql ODBC Driver 08.00.0031
Oracle Server 19.16
  • 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.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 21.7
  • 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

SQL Server 2019 CU17
  • 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
SQL Server 2022
  • 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
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.XC8 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
Informix V14.10.XC9 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
Sybase ASE Server 16 SP3
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
IBM Netezza Performance server 11.2.0.0
  • Windows: Netezza ODBC Driver 11.2.1.4
  • Linux: Not run

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.4:
 
Database type
Compatible Query versions
Vertica 11.1.1-3 server
  • Windows Vertica ODBC Driver 11.00.0200
  • Linux Vertica ODBC Driver 9.2.1
Vertica 12.0 server
  • Not tested
Teradata 17.10 server
  • Windows Teradata ODBC Driver Version 17.20.00.002
  • Linux-x86-Teradata ODBC Driver Version 17.20.00.003
Teradata 17.20 server
  • Windows: Teradata ODBC Driver 17.20.00.002

  • Linux: Teradata ODBC Driver 17.20.00.003

IBM Db2 iSeries Server 7.4
IBM Db2 iSeries 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.026
  • Linux: DB2 iSeries ODBC Driver: 07.01.025
IBM Db2 Z Server 12.1.5
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Db2 Z Server 13
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Db2 11.5.7 server
  • Windows: IBM Data Server Client 11.05.0800
  • Linux: IBM Data Server Client 11.05.0800
IBM Cloud Data Engine
  • Not applicable
Dremio 21.1.2
  • Not tested
Dremio 21.2.0
  • Not tested
Dremio 22.1.2
  • Not tested
PostgreSQL Server 12.11
  • Windows: PostgreSQL ODBC Driver 13.02.0000

  • Linux: PostgreSQL ODBC Driver 12.02.0000

PostgreSQL Server 13.7
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 14.3
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 14.4
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
PostgreSQL Server 14.5
  • Windows: PostgreSQL ODBC Driver 13.02.0000
  • Linux: PostgreSQL ODBC Driver 13.02.0000
MySQL 8.0.30 server
  • Windows: MySql ODBC Driver 08.00.0031
  • Linux: MySql ODBC Driver 08.00.0030
Oracle Server 19.15
  • 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.16
  • 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 21.6
  • 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.7
  • Windows: Oracle Database 21c Client (21.3) - 21.3.0.0.0

  • Linux: Oracle Instant Client (21.3) - 21.3.0.0.0

Netezza Server 7.2.1
  • Windows: Netezza ODBC Driver 11.2.1.4

  • Linux: Netezza ODBC Driver 7.2.1.11

SQL Server 2017 CU30
  • Windows: OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL )
  • Windows: ODBC Driver 18.1 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux: DataDirect ODBC Driver 8.0.2
SQL Server 2019 CU16
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • Windows: ODBC Driver 18.1 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux: DataDirect ODBC Driver 8.0.2
SQL Server 2019 CU17
  • 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
Informix V14.10.XC7 server
  • Windows: Informix Client Software Development Kit 4.10 TC15
  • Linux: Informix Client Software Development Kit 4.10 UC15
Sybase ASE Server 16 SP3
  • Windows: SAP Client-Library/20.0
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
IBM Netezza Performance server 11.2.0.0
  • Windows: Netezza ODBC Driver 11.2.1.4
  • Linux: Not run

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.3:
 
Database type
Compatible Query versions
Vertica 11.0.2 server
  • Windows Vertica ODBC Driver 11.00.0200
  • Linux Vertica ODBC Driver 9.2.1
Teradata 17.10 server
  • Windows Teradata ODBC Driver Version 17.20.00.002
  • Linux-x86-Teradata ODBC Driver Version 17.20.00.003
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
  • Windows IBM Data Server Client 11.05.0700
  • Linux-x86 - IBM Data Server Client 11.05.0700
  • Windows - DB2 iSeries ODBC Driver 07.01.026
  • Linux-x86 - DB2 iSeries ODBC Driver: 07.01.025
IBM Db2 Z Server 12.1.5
  • Windows - IBM Data Server Client Not run
  • Linux-x86- DB2 Data Server Client Not run
IBM Db2 11.5.7 server
  • Windows DB2 Data Server Client 11.05.07
  • Linux-x86-DB2 Data Server Client 11.05.04
IBM Cloud Data Engine Dynamic Query
Dremio 19.2.0
  • Not applicable
Dremio 20.0
  • Not applicable
Dremio 20.1
  • Not applicable
Dremio 20.1.1
  • Not applicable
PostgreSQL Server 14.2
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.02.000
Progress DataDirect Autonomous REST
  • Not applicable
MySQL 8.0.28 server
  • Windows-MySQL Connector/ODBC 8.00.0030
  • Linux-x86-MySQL Connector/ODBC 8.00.0028
MySQL 8.0.29 server
  • Windows-MySQL Connector/ODBC 8.00.0030
  • Linux-x86-MySQL Connector/ODBC 8.00.0029
Oracle Server 19.14
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Instant Client 19.12
Oracle Server 19.15
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Instant Client 19.12
Oracle Server 21.4
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Oracle Server 21.5
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Oracle Server 21.6
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Netezza Server 7.2.1
  • Windows-Netezza ODBC Driver 11.2.1.4
  • Linux-x86-Netezza ODBC Driver 7.2.1.11
SQL Server 2019 CU15
  • 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
SQL Server 2019 CU16
  • 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
Informix V14.10.XC7 server
  • Windows-Informix Client Software Development Kit 4.10 TC15
  • Linux-x86-Informix Client Software Development Kit 4.10 UC15
Sybase ASE Server 16 SP3
  • Windows-SAP Client-Library/20.0
  • Linux-x86-SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5
  • Windows-SAP Sybase IQ ODBC Driver 16.00.2195
  • Linux-x86-SAP Sybase IQ ODBC Driver 16.00.2014
IBM Performance server/Netezza 11.2.0.0 server
  • Windows- Netezza ODBC Driver 11.2.1.4

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.2:
 
Database type
Compatible Query versions
IBM Db2 11.5.7 server
  • Windows DB2 Data Server Client 11.05.07
  • Linux-x86-DB2 Data Server Client 11.05.04
IBM Db2 iSeries Server 7.4
  • Windows IBM i Access ODBC Driver 07.01.025
  • Linux-x86 -IBM i Access ODBC Driver 07.01.025
IBM Db2 Z Server 12.1.5
  • Windows - DB2 Data Server Client 11.05.07
  • Linux-x86- DB2 Data Server Client 11.05.04
IBM Netezza Performance Server 11.2.0.0 server
  • Windows- ODBC driver 11.2.0.0
  • Linux-x86- ODBC driver 11.2.1.1
Informix V14.10.XC7 server
  • Windows-Informix SDK 4.10 TC14
  • Linux-x86-Informix SDK 4.10 UC15
MySQL 8.0.26 server
  • Windows-MySQL Connector/ODBC 8.0.28
  • Linux-x86-MySQL Connector/ODBC 8.0.25
  • Linux-x86-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.27
  • Linux-x86-MySQL Connector/ODBC 8.0.28
MySQL 8.0.27 server
  • Windows-MySQL Connector/ODBC 8.0.28
  • Linux-x86-MySQL Connector/ODBC 8.0.25
  • Linux-x86-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.27
  • Linux-x86-MySQL Connector/ODBC 8.0.28
Netezza Server 7.2.1
  • Windows-IBM Netezza ODBC driver Version 11.2.1.4
  • Linux-x86-IBM Netezza ODBC driver Version-11.2.1.1
  • Linux-x86-IBM Netezza ODBC driver Version-7.2.1.11
Oracle Server 19.12
  • Windows-Oracle Database 21c Client (21.3)
  • Linux-x86-Oracle Instant Client 21.3
  • Linux-x86-Oracle Instant Client 19.12
  • Linux-x86-Oracle Instant Client 19.3
Oracle Server 19.13
  • Windows-Oracle Database 21c Client (21.3)
  • Linux-x86-Oracle Instant Client 21.3
  • Linux-x86-Oracle Instant Client 19.12
  • Linux-x86-Oracle Instant Client 19.3
Oracle Server 21.3
  • Windows-Oracle Database 21c Client (21.3)
  • Linux-x86-Oracle Instant Client 21.3
  • Linux-x86-Oracle Instant Client 19.12
  • Linux-x86-Oracle Instant Client 19.3
PostgreSQL Server 12.8
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.0000
PostgreSQL Server 13.4
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.0000
PostgreSQL Server 14.0
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.0000
PostgreSQL Server 14.1
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.0000
SQL Server 2019 CU11
  • Windows-SQL Server Native Client OLE DB 11
  • Windows-Microsoft ODBC Driver 17 for SQL Server
  • Linux-x86-DataDirect for ODBC for SQL Server Version 08.02
SQL Server 2019 CU12
  • Windows-SQL Server Native Client OLE DB 11
  • Windows-Microsoft ODBC Driver 17 for SQL Server
  • Linux-x86-DataDirect for ODBC for SQL Server Version 08.02
SQL Server 2019 CU13
  • Windows-SQL Server Native Client OLE DB 11
  • Windows-Microsoft ODBC Driver 17 for SQL Server
  • Linux-x86-DataDirect for ODBC for SQL Server Version 08.02
SQL Server 2019 CU14
  • Windows-SQL Server Native Client OLE DB 11
  • Windows-Microsoft ODBC Driver 17 for SQL Server
  • Linux-x86-DataDirect for ODBC for SQL Server Version 08.02
Sybase ASE Server 16 SP3
  • Windows-SAP Client-Library 16.0
  • Linux-x86-SAP Client-Library 16.0 SP4
Sybase IQ Server 16.1 SP3
  • Windows-SAP IQ ODBC driver 16.1SP04
  • Linux-x86-SAP IQ ODBC driver 16.0 SP11
Sybase IQ Server 16.1 SP4
  • Windows-SAP IQ ODBC driver 16.1SP04
  • Linux-x86-SAP IQ ODBC driver 16.0 SP11
Teradata 17.10 server
  • Windows Teradata ODBC Driver Version 17.10
  • Linux-x86-Teradata ODBC Driver Version 17.10
Vertica 11.00 server
  • Windows ODBC Driver Version 11.02
  • Linux-x86- ODBC Driver Version 9.2
VMware Tanzu Greenplum 6.18.2 server
  • Not applicable
 

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.1:
 
Database type
Compatible Query versions
Vertica 10.1.0 server
  • Windows ODBC Driver Version 10.01
  • Linux-x86- ODBC Driver Version 9.2.1
Teradata 17.10 server
  • Windows Teradata ODBC Driver Version 17.10.00.10
  • Linux-x86-Teradata ODBC Driver Version 17.10.00.10
IBM Db2 iSeries JT400 Server 7.4
  • Windows IBM i Access ODBC Driver 07.01.025
  • Linux-x86 -IBM i Access ODBC Driver 07.01.025
IBM Db2 iSeries JT400 Server 7.4
  • Windows DB2 Data Server Client 11.05.0400
  • Linux-x86 - DB2 Data Server Client 11.05.0400
IBM Db2 Z Server 12.1.5
  • Windows - DB2 Data Server Client 11.05.0400
  • Linux-x86- DB2 Data Server Client 11.05.0400
IBM Db2 11.5.5 server
  • Windows DB2 Data Server Client 11.05.0400
  • Linux-x86-DB2 Data Server Client 11.05.0400
IBM Db2 11.5.6 server
  • Windows DB2 Data Server Client 11.05.0400
  • Linux-x86-DB2 Data Server Client 11.05.0400
Dremio 15.7
  • Not applicable
Dremio 16.0
  • Not applicable
Dremio 17.0.0
  • Not applicable
IBM Cloud SQL Query
  • Not applicable
PostgreSQL Server 12.6
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 12.02.000
PostgreSQL Server 12.7
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 12.02.000
PostgreSQL Server 13.2
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.01.000
PostgreSQL Server 13.3
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.01.000
Progress DataDirect Autonomous REST
  • Not applicable
MySQL 8.0.23 server
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.23
MySQL 8.0.24 server
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.24
MySQL 8.0.25 server
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.25
Oracle Server 19.10
  • Windows-Oracle Client Version 19.3.0
  • Linux-x86-Oracle Client Version 19.3.0
Oracle Server 19.11
  • Windows-Oracle Client Version 19.3.0
  • Linux-x86-Oracle Client Version 19.12
Oracle Server 21.1
  • Windows-Oracle Client Version 19.10
  • Linux-x86-Oracle Client Version 19.12
Netezza Server 7.2.1
  • Windows-IBM Netezza ODBC driver Version 7.2.1.11
  • Linux-x86-IBM Netezza ODBC driver Version-7.2.1.11
SQL Server 2017 14.00.3391
  • Windows-Microsoft ODBC Driver 17.05 for SQL Server
  • Linux-x86-DataDirect Version 08.02
SQL Server 2019 15.0.4073.23
  • Windows-Microsoft ODBC Driver 17.05 for SQL Server
  • Linux-x86-DataDirect Version 08.02
Informix V14.10.XC5 server
  • Windows-Informix SDK 4.10 TC14
  • Linux-x86-Informix SDK 4.10 UC15
Informix V14.10.XC6 server
  • Windows-Informix SDK 4.10 TC14
  • Linux-x86-Informix SDK 4.10 UC15
Sybase ASE Server 16 SP3
  • Windows-SAP Client-Library 16.0
  • Linux-x86-SAP Client-Library 16.0 SP4
Sybase IQ Server 16.1 SP4
  • Windows-SAP IQ ODBC driver 16.0SP11
  • Linux-x86-SAP IQ ODBC driver 16.0 SP11
IBM Performance server/Netezza 11.2.0.0 server
  • Windows- ODBC driver 11.2.0.0
  • Linux-x86- ODBC driver 11.2.1.1

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

The following driver versions were tested on relational data sources using CQM with Cognos Analytics 11.2.0:
 
Database type
Compatible Query versions
Vertica 10.0 server
  • Windows Vertica Client Driver Version 10.0.0
  • Linux-x86 -Vertica ODBC Driver Version 10.0.0
Vertica 10.0 server
  • Windows Vertica Client Driver Version 10.0.1
  • Linux-x86 -Not applicable
Teradata 17.0 server
  • Windows Teradata ODBC Driver Version 16.20.00.98
  • Linux-x86-Teradata ODBC Driver Version 16.20.00.98
Teradata 17.0 server
  • Windows Teradata ODBC Driver Version 17.00.00.17
  • Linux-x86-Teradata ODBC Driver Version 17.00.00.18
Teradata 17.0 server
  • Windows Teradata ODBC Driver Version 17.00.00.19
  • Linux-x86-Teradata ODBC Driver Version 17.00.00.18
Teradata 17.0 server
  • Windows Teradata ODBC Driver Version 17.00.00.20
  • Linux-x86-Teradata ODBC Driver Version 17.00.00.20
Teradata 17.05.02.01 server
  • Windows Teradata ODBC Driver Version 17.00.00.20
  • Linux-x86-Teradata ODBC Driver Version 17.00.00.20
IBM Db2 iSeries JT400 Server 7.4
  • WindowsIBM i Access ODBC Driver 7.01.022
  • Linux-x86 -IBM i Access ODBC Driver 7.01.023
IBM Db2 iSeries JT400 Server 7.4
  • Windows IBM i Access ODBC Driver 7.01.022
  • Linux-x86 -IBM i Access ODBC Driver 7.01.023
IBM Db2 Z Server 12.1.5
  • Windows IBM Data Server Client 11.1
  • Linux-x86-IBM Data Server Client 11.1
IBM Db2 11.5.4 server
  • Windows IBM Data Server Client 11.5.4
  • Linux-x86-IBM Data Server Client 11.5.4
IBM Db2 11.5.4 server
  • Windows IBM Data Server Client 11.5.4
  • Linux-x86-IBM Data Server Client 11.5.4
IBM Db2 11.5.5 server
  • Windows IBM Data Server Client 11.5.5
  • Linux-x86-IBM Data Server Client 11.5.4
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86 PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.8
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 12.3
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 12.4
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 13.0
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
PostgreSQL Server 13.1
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 13.1
PostgreSQL Server 13.1
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 13.1
PostgreSQL Server 13.1
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 13.1
MySQL 8.0.20 server
  • Windows-MySQL Connector/ODBC 8.0.20
  • Linux-x86-MySQL Connector/ODBC 8.0.20
MySQL 8.0.21 server
  • Windows-MySQL Connector/ODBC 8.0.21
  • Linux-x86-MySQL Connector/ODBC 8.0.21
MySQL 8.0.22 server
  • Windows-MySQL Connector/ODBC 8.0.22
  • Linux-x86-MySQL Connector/ODBC 8.0.22
Oracle Server 18.10
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
Oracle Server 19.7
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
Oracle Server 19.8
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
Oracle Server 19.8
  • Windows-Oracle Client Version 19.8
  • Linux-x86-Oracle Client Version 19.6
SQL Server 2017 CU20
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 18.3
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2017 CU21
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and SQL Server Native client 11.0 OLE DB
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU5
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU6
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU8
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
Informix V14.10.XC4 server
  • Windows-Informix Client Version:4.10.14
  • Linux-x86-Informix Client Version: 4.50.FC4W1
Sybase ASE Server 16 SP3
  • Windows-SDK for SAP ASE Version 16.0
  • Linux-x86-SDK for SAP ASE Version 16.0
Sybase IQ Server 16.1 SP3
  • Windows-SAP IQ Network Client 16.0
  • Linux-x86-SAP IQ Network Client 16.0
IBM Performance server/Netezza 11.1.1.0 server
  • Windows-IBM Netezza ODBC driver Version 11.0.6.1
  • Linux-x86 IBM Netezza ODBC driver version 11.0.6.1
IBM Performance server/Netezza 11.1.1.0 server
  • Windows-IBM Netezza ODBC driver Version 11.1.1.0
  • Linux-x86 IBM Netezza ODBC driver version 11.1.1.0
 

[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration-\u003EData Sources"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.2.0;and future releases"}]

Document Information

Modified date:
29 January 2024

UID

ibm17112319