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
- CQM-tested drivers for Release 12.0.3
- CQM-tested drivers for Release 12.0.2
- CQM-tested drivers for Release 12.0.1
- CQM-tested drivers for Release 12.0.0
Note:
For more information, see the following resources:
- the database vendor's documentation with respect to their statement of forward and backward compatibility of client and server versions
- DQM testing of vendor-supported client driver versions for each Cognos Analytics 12.0.x release
- the list of Pre-installed drivers, if you are running Cognos Analytics on Cloud On-Demand
- IBM Cognos Analytics on Premises 12.0.x: Supported Software Environments
Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.3
Database type
|
Compatible Query versions
|
IBM Db2 11.5.8 server |
|
IBM Db2 11.5.9 server |
|
Db2 for IBM i server 7.4 |
|
Db2 for IBM i server 7.5 |
|
Db2 Z Server 12.1.5 |
|
Db2 Z Server 13.1.5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MySQL 8.0.34 server |
|
MySQL 8.0.35 server |
|
MySQL 8.0.36 server |
|
MySQL 8.1 server |
|
Oracle Server 19.21 |
|
Oracle Server 21.10 |
|
Oracle Server 21.11 |
|
Oracle Server 23.3 |
|
PostgreSQL Server 15.5 |
|
PostgreSQL Server 16.1 |
|
PostgreSQL Server 16.2 |
|
SQL Server 2019 CU23 |
|
SQL Server 2019 CU24 |
|
SQL Server 2022 CU10 |
|
SQL Server 2022 CU11 |
|
Sybase ASE Server 16 SP4 PL03 |
|
Sybase ASE Server 16 SP4 PL04 |
|
Sybase IQ Server 16.1 SP5 PLO7 |
|
Sybase IQ Server 16.1 SP5 PLO8 |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
Vertica 12 server |
|
Vertica 24.1 server |
|
Note:
In addition to the CQM relational testing shown in the table above, CQM testing was successfully performed on IBM Cognos Powercubes (OLAP). No driver was required for this testing.
Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.2
Database type
|
Compatible Query versions
|
IBM Db2 11.5.8 server |
|
IBM Db2 11.5.9 server |
|
Db2 for IBM i server 7.4 |
|
Db2 for IBM i server 7.5 |
|
Db2 Z Server 12.1.5 |
|
Db2 Z Server 13.1.5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MySQL 8.0.33 server |
|
MySQL 8.1 server |
|
Oracle Server 19.19 |
|
Oracle Server 19.20 |
|
Oracle Server 21.10 |
|
Oracle Server 21.11 |
|
Oracle Server 23.3 |
|
PostgreSQL Server 15.4 |
|
PostgreSQL Server 16.0 |
|
SQL Server 2019 CU21 |
|
SQL Server 2019 CU23 |
|
SQL Server 2022 CU7 |
|
SQL Server 2022 CU8 |
|
SQL Server 2022 CU9 |
|
Sybase ASE Server 16 SP4 PL03 |
|
Sybase ASE Server 16 SP4 PL04 |
|
Sybase IQ Server 16.1 SP5 PLO7 |
|
Sybase IQ Server 16.1 SP5 PLO8 |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
Vertica 12 server |
|
Vertica 23 server |
|
Note:
In addition to the CQM relational testing shown in the table above, CQM testing was successfully performed on IBM Cognos Powercubes (OLAP). No driver was required for this testing.
Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.1
Database type
|
Compatible Query versions
|
IBM Db2 11.5.8 server |
|
Db2 for IBM i server 7.4 |
|
Db2 for IBM i server 7.5 |
|
Db2 Z Server 12.1.5 |
|
Db2 Z Server 13.1.5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MySQL 8.0.32 server |
|
MySQL 8.0.33 server |
|
Oracle Server 19.19 |
|
Oracle Server 21.9 |
|
PostgreSQL Server 14.5 |
|
PostgreSQL Server 15.3 |
|
SQL Server 2019 CU20 |
|
SQL Server 2019 CU21 |
|
SQL Server 2022 CU2 |
|
SQL Server 2022 CU4 |
|
SQL Server 2022 CU5 |
|
Sybase ASE Server 16 SP4 PL03 |
|
Sybase ASE Server 16 SP4 PL04 |
|
Sybase IQ Server 16.1 SP5 PLO7 |
|
Sybase IQ Server 16.1 SP5 PLO8 |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
Vertica 12.0.4 server |
|
Note:
In addition to the CQM relational testing shown in the table above, CQM testing was successfully performed on IBM Cognos Powercubes (OLAP). No driver was required for this testing.
Vendor-supported client driver versions that were tested using CQM with Cognos Analytics on Premises 12.0.0
Database type
|
Compatible Query versions
|
IBM Db2 11.5.8 server |
|
Db2 for IBM i server 7.4 |
|
Db2 for IBM i server 7.5 |
|
Db2 Z Server 12.1.5 |
|
Db2 Z Server 13.1.5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC9 server |
|
MySQL 8.0.31 server |
|
MySQL 8.0.32 server |
|
Oracle Server 19.17 |
|
Oracle Server 19.18 |
|
Oracle Server 21.8 |
|
Oracle Server 21.9 |
|
PostgreSQL Server 14.5 |
|
PostgreSQL Server 15.0 |
|
PostgreSQL Server 15.1 |
|
PostgreSQL Server 15.2 |
|
SQL Server 2019 CU19 |
|
SQL Server 2022 CU1 |
|
Sybase ASE Server 16 SP4 |
|
Sybase IQ Server 16.1 SP5 PLO7 |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
Vertica 12.0.3 server |
|
Note:
In addition to the CQM relational testing shown in the table above, CQM testing was successfully performed on IBM Cognos Powercubes (OLAP). No driver was required for this testing.
Was this topic helpful?
Document Information
Modified date:
25 April 2024
UID
ibm17112270