IBM Support

CQM tested database vendor and database driver versions for each Cognos Analytics 12.2.x release

Detailed System Requirements


Abstract

This document lists the database vendor and database driver versions that were tested using Compatible Query Mode (CQM) for each Cognos Analytics 12.2.x release.

Content

 

Database vendor and database driver versions that were tested using CQM with Cognos Analytics on Premises 12.2.0:

Database vendor versions
Database driver versions
DB2 LUW V12.1.2.0 Enterprise Server Edition
  • Windows: IBM Data Server Client 12.1 RTCL
  • Linux: IBM Data Server Client 12.1 RTCL
  • AIX: IBM Data Server Client 12.1 RTCL
  • IBM Z: IBM Data Server Client 12.1 RTCL
  • IBM System p: IBM Data Server Client 12.1 RTCL
DB2 LUW V12.1.1 server
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
DB2 LUW V11.5.9 Advanced Enterprise Server Edition
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
DB2 for IBM i server 7.6
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
  • Windows: DB2 iSeries ODBC Driver 07.0.28
  • Linux: DB2 iSeries ODBC Driver 07.0.27
DB2 for IBM i server 7.5
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
  • Windows: DB2 iSeries ODBC Driver 07.0.28
  • Linux: DB2 iSeries ODBC Driver 07.0.27
DB2 for IBM i server 7.4
  • Windows: IBM Data Server Client 12.01.0100
  • Linux: IBM Data Server Client 12.01.0000
  • Windows: DB2 iSeries ODBC Driver 07.0.28
  • Linux: DB2 iSeries ODBC Driver 07.0.27
DB2 for z/OS 13.1.5
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
DB2 for z/OS 12.1.5
  • Windows: IBM Data Server Client 12.01.0200
  • Linux: IBM Data Server Client 12.01.0200
IBM Netezza Performance Server 11.2.2.10 (11.2.2.10 [Build 71])
  • Windows: Netezza ODBC Driver 11.3.0.3-IF1
  • Linux: Netezza ODBC Driver 11.2.1.13
Informix IDS 15.0.0.1 Enterprise Edition
  • Windows: Informix Client Software Development Kit 4.10 TC16W2
  • Linux: Informix Client Software Development Kit 4.10 TC16
Informix V15.00 GA server
  • Windows: Informix Client Software Development Kit 4.10 TC16W2
  • Linux: Informix Client Software Development Kit 4.10 TC16
Informix IDS 14.10 FC11 Enterprise Edition
  • Windows: Informix Client Software Development Kit 4.10 TC16W2
  • Linux: Informix Client Software Development Kit 4.10 TC16
Informix V12.10.FC14 server
  • Windows: Informix Client Software Development Kit 4.10 TC16W2
  • Linux: Informix Client Software Development Kit 4.10 TC16
MySQL 8.4.6 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.4.5 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.4.4 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.4.3 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.4.2 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.1.0 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.0.39 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 08.00.0043
  • Linux: MySQL ODBC Driver 08.00.0042
MySQL 8.4.8 GA Community Server - on Docker container
  • Windows: MySQL ODBC Driver 9.0
  • Linux: MySQL ODBC Driver 9.0
  • AIX: MariaDB ODBC 3.2.4
  • IBM Z: MariaDB ODBC 3.2.4
  • IBM System p: MariaDB ODBC 3.2.4 
Oracle 23.9 Free - on Podman container
  • Windows: Oracle Instant Client 21.18.0.0
  • Linux: Oracle Instant Client 21.18.0.0
Oracle 21.19 Enterprise Edition
  • Windows: Oracle Instant Client 21.18.0.0
  • Linux: Oracle Instant Client 21.18.0.0
Oracle 19.28 Enterprise Edition
  • Windows: Oracle Database Client 21.3.0.0
  • Linux: Oracle Instant Client 21.3.0.0
Oracle 26ai Enterprise Edition
  • Windows: Oracle Instant Client 21.18
  • Linux: Oracle Instant Client 21.12
  • AIX: Oracle Instant Client 19.32
  • IBM Z: Oracle Instant Client 19.32
  • IBM System p: Oracle Instant Client 19.31
PostgreSQL 17.6 - on Docker container
  • Windows: PostgreSQL ODBC Driver 17.00.0006
  • Linux: PostgreSQL ODBC Driver 17.00.0006
PostgreSQL 16.9 - on Docker container
  • Windows: PostgreSQL ODBC Driver 17.00.0006
  • Linux: PostgreSQL ODBC Driver 17.00.0006
PostgreSQL 17.5 - on Docker container
  • Windows: PostgreSQL ODBC Driver 17
  • Linux: PostgreSQL ODBC Driver 17
  • AIX: PostgreSQL ODBC Driver 17
  • IBM Z: PostgreSQL ODBC Driver 17
  • IBM System p: PostgreSQL ODBC Driver 17
MS SQL Server 2022 Enterprise Edition CU20
  • Windows: Microsoft OLE DB Driver for SQL Server 19.4.0001.0
  • Windows: Microsoft ODBC Driver for SQL Server 18.05.0001
  • Linux: DataDirect ODBC Driver 8.0.2.2200
MS SQL Server 2019 Enterprise Edition CU32
  • Windows: Microsoft OLE DB Driver for SQL Server 19.4.0001.0
  • Windows: Microsoft ODBC Driver for SQL Server 18.05.0001
  • Linux: DataDirect ODBC Driver 8.0.2.1222
MS SQL Server 2017 Enterprise Edition CU30
  • Windows: SQL Server Native Client 11.0.7515.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.05.0001
  • Linux: DataDirect ODBC Driver 8.0.2.2200
MS SQL Server 2017 Enterprise Edition CU21
  • Windows: SQL Server Native Client 11.0.7515.2
  • Windows: Microsoft ODBC Driver for SQL Server 18.05.0001
  • Linux: DataDirect ODBC Driver 8.0.2.1222
MS SQL Server 2019 Enterprise Edition CU32
  • Windows: Microsoft ODBC Driver for SQL Server 18.00
  • Linux: Microsoft ODBC Driver for SQL Server 18.00
  • AIX: FreeTDS 1.5.19
  • IBM Z: FreeTDS 1.5.19
  • IBM System p: FreeTDS 1.5.19 
SAP Sybase ASE 16.1 SP00 PL00 Enterprise Edition
  • Windows: SAP Client-Library/16.1 SP00 PL01
  • Linux: SAP Client-Library/20.0
SAP Sybase ASE 16.0 SP04 PL04 Enterprise Edition
  • Windows: SAP Client-Library/16.1 SP00 PL01
  • Linux: SAP Client-Library/20.0
SAP Sybase ASE 16.0 SP04 PL03 Enterprise Edition
  • Windows: SAP Client-Library/16.1 SP00 PL01
  • Linux: SAP Client-Library/20.0
Sybase IQ Server 16.1 SP05 PL15
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Sybase IQ Server 16.1 SP05 PL14
  • Windows: Sybase IQ ODBC Driver 16.00.2195
  • Linux: Sybase IQ ODBC Driver 16.00.2014
Teradata V20.00 GA
  • Windows: Teradata ODBC Driver 20.00.00.030
  • Linux: Teradata ODBC Driver 20.00.00.030
Teradata V17.20.03.39
  • Windows: Teradata ODBC Driver 20.00.00.030
  • Linux: Teradata ODBC Driver 20.00.00.030
Vertica 25.1
  • Windows: Vertica ODBC Driver 24.02.0001
  • Linux: Vertica ODBC Driver 09.02.0100

 

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6sAAC","label":"Install-\u003EConfigure"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"and future releases;12.2.0"}]

Document Information

Modified date:
04 November 2026

UID

ibm17290507

Page Feedback