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.1.x release.
Content
- CQM-tested database vendors and drivers for Release 12.1.2
- CQM-tested database vendors and drivers for Release 12.1.1
- CQM-tested database vendors and drivers for Release 12.1.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.1.x release
- the list of Pre-installed drivers, if you are running Cognos Analytics on Cloud On-Demand
- IBM Cognos Analytics on Premises 12.1.x: Supported Software Environments
Database vendor and database driver versions that were tested using CQM with Cognos Analytics on Premises 12.1.2:
Database vendor versions | Database driver versions |
| DB2 LUW V12.1.2.0 Enterprise Server Edition |
|
| DB2 LUW V12.1.1 server |
|
| DB2 LUW V11.5.9 Advanced Enterprise Server Edition |
|
| DB2 for IBM i server 7.6 |
|
| DB2 for IBM i server 7.5 |
|
| DB2 for IBM i server 7.4 |
|
| DB2 for z/OS 13.1.5 |
|
| DB2 for z/OS 12.1.5 |
|
| IBM Netezza Performance Server 11.2.2.10 (11.2.2.10 [Build 71]) |
|
| Informix IDS 15.0.0.1 Enterprise Edition |
|
| Informix V15.00 GA server |
|
| Informix IDS 14.10 FC11 Enterprise Edition |
|
| Informix V12.10.FC14 server |
|
| MySQL 8.4.6 GA Community Server - on Docker container |
|
| MySQL 8.4.5 GA Community Server - on Docker container |
|
| MySQL 8.4.4 GA Community Server - on Docker container |
|
| MySQL 8.4.3 GA Community Server - on Docker container |
|
| MySQL 8.4.2 GA Community Server - on Docker container |
|
| MySQL 8.1.0 GA Community Server - on Docker container |
|
| MySQL 8.0.39 GA Community Server - on Docker container |
|
| Oracle 23.9 Free - on Podman container |
|
| Oracle 21.19 Enterprise Edition |
|
| Oracle 19.28 Enterprise Edition |
|
| PostgreSQL 17.6 - on Docker container |
|
| PostgreSQL 16.9 - on Docker container |
|
| MS SQL Server 2022 Enterprise Edition CU20 |
|
| MS SQL Server 2019 Enterprise Edition CU32 |
|
| MS SQL Server 2017 Enterprise Edition CU30 |
|
| MS SQL Server 2017 Enterprise Edition CU21 |
|
| SAP Sybase ASE 16.1 SP00 PL00 Enterprise Edition |
|
| SAP Sybase ASE 16.0 SP04 PL04 Enterprise Edition |
|
| SAP Sybase ASE 16.0 SP04 PL03 Enterprise Edition |
|
| Sybase IQ Server 16.1 SP05 PL15 |
|
| Sybase IQ Server 16.1 SP05 PL14 |
|
| Teradata V20.00 GA |
|
| Teradata V17.20.03.39 |
|
| Vertica 25.1 |
|
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.
Database vendor and database driver versions that were tested using CQM with Cognos Analytics on Premises 12.1.1:
Database vendor versions | Database driver versions |
| DB2 LUW V12.1.2.0 Enterprise Server Edition |
|
| DB2 LUW V12.1.1 server |
|
| DB2 LUW V11.5.9 Advanced Enterprise Server Edition |
|
| DB2 for IBM i server 7.4 |
|
| DB2 for IBM i server 7.5 |
|
| DB2 for IBM i server 7.6 |
|
| DB2 Z Server 12.1.5 |
|
| DB2 Z Server 13.1.5 |
|
| IBM Netezza Performance server 11.2.2.10 |
|
| Informix IDS 14.10 FC11 Enterprise Edition |
|
| Informix IDS 15.0.0.1 Enterprise Edition |
|
| Informix V12.10.FC14 server |
|
| Informix V15.00 server |
|
| MySQL 8.0.39 server |
|
| MySQL 8.1.0 server |
|
| MySQL 8.4.2 server |
|
| MySQL 8.4.3 server |
|
| MySQL 8.4.4 server |
|
| MySQL 8.4.5 server |
|
| MySQL 8.4.6 server |
|
| Oracle Server 19.28 |
|
| Oracle Server 21.19 |
|
| Oracle Server 23.9 |
|
| PostgreSQL Server 16.9 |
|
| PostgreSQL Server 17.6 |
|
| SQL Server 2017 CU21 |
|
| SQL Server 2017 CU30 |
|
| SQL Server 2019 CU32 |
|
| SQL Server 2022 CU20 |
|
| Sybase ASE Server 16.0 SP04 PL03 |
|
| Sybase ASE Server 16.0 SP04 PL04 |
|
| Sybase ASE Server 16.0 SP00 PL00 |
|
| Sybase IQ Server 16.1 SP05 PL14 |
|
| Sybase IQ Server 16.1 SP05 PL15 |
|
| Teradata 17.20.03.39 server |
|
| Teradata 20 server |
|
| Vertica 25.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.
Database vendor and database driver versions that were tested using CQM with Cognos Analytics on Premises 12.1.0:
Database vendor versions | Database driver versions |
| IBM DB2 11.5.9 server |
|
| IBM DB2 12.1 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.2.10 |
|
| Informix V14.10.XC11 server |
|
| Informix V15.0 server |
|
| MySQL 8.0.39 server |
|
| MySQL 8.1 server |
|
| MySQL 8.4.4 server |
|
| Oracle Server 19.26 |
|
| Oracle Server 21.16 |
|
| Oracle Server 23.7 |
|
| PostgreSQL Server 16.5 |
|
| PostgreSQL Server 17.2 |
|
| SQL Server 2016 SP3 |
|
| SQL Server 2017 CU30 |
|
| SQL Server 2019 CU30 |
|
| SQL Server 2022 CU17 |
|
| Sybase ASE Server 16 SP4 PL03 |
|
| Sybase ASE Server 16 SP4 PL04 |
|
| Sybase IQ Server 16.1 SP5 PL07 |
|
| Sybase IQ Server 16.1 SP5 PL08 |
|
| Teradata 16.20 server |
|
| Teradata 17.10 server |
|
| Teradata 17.20 server |
|
| Teradata 20 server |
|
| Vertica 24.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.
[{"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"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"12.1.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
12 March 2026
UID
ibm17185329