Detailed System Requirements
Abstract
This document lists the vendor-supported client driver versions that were tested using Dynamic Query Mode (DQM) for each Cognos Analytics 12.1.x release.
Content
- DQM-tested drivers for Release 12.1.1 [Relational] | [OLAP]
- DQM-tested drivers for Release 12.1.0 [Relational] | [OLAP]
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
- CQM tested database vendor and database 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
- You can also view a list of CQM-tested database vendors and drivers for release 12.1.1
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.1.1
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.1.1:
Database type | Dynamic Query versions |
| Amazon Athena |
|
| Amazon Athena |
|
| Amazon Athena |
|
| Amazon Redshift |
|
| Apache Hive Server 3.1.3000.7.1.7.0-551 |
|
| Azure Fabric |
|
| Azure Synapse |
|
| Azure SQL |
|
| BigSQL 7.1.0 server |
|
| Cloudera Impala 3.4 server |
|
| Cloudera Impala 4.0 server |
|
| CDATA Connect Cloud |
|
| Databricks |
|
| IBM Data Virtualization |
|
| IBM DB2 11.5.9 server |
|
| IBM DB2 12.1.1 server |
|
| IBM DB2 12.1.2 server |
|
| 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 |
|
| Denodo 8.0.20240306 server |
|
| Denodo 9.2 server |
|
| Denodo 9.3 server |
|
| Dremio 25.1.6 |
|
| Exasol 8.33 server |
|
| Google BigQuery |
|
| IBM Netezza Performance server 11.2.0.0 |
|
| Informix V14.10.XC11 server |
|
| Informix V15.0.1 server |
|
| MariaDB 10.11.9 server |
|
| MariaDB 11.4.5 server |
|
| MariaDB 11.4.7 server |
|
| MySQL 8.1 server |
|
| MySQL 8.4.4 server |
|
| MySQL 8.4.5 server |
|
| Oracle Server 19.26 |
|
| Oracle Server 19.27 |
|
| Oracle Server 21.17 |
|
| Oracle Server 21.18 |
|
| Oracle Server 23.6 |
|
| Oracle Server 23.7 |
|
| Oracle Server 23.8 |
|
| VMware Tanzu Greenplum 6.29.0 server |
|
| VMware Tanzu Greenplum 7.4.1 server |
|
| PostgreSQL Server 16.8 |
|
| PostgreSQL Server 17.3 |
|
| PostgreSQL Server 17.4 |
|
| PostgreSQL Server 17.5 |
|
| Progress DataDirect Autonomous REST |
|
| SAP HANA 2.0 SP07 server |
|
| SAP HANA 2.0 SP08 server |
|
| SingleStore 8.7.21 server |
|
| SingleStore 8.7.22 server |
|
| SingleStore 8.7.24 server |
|
| SingleStore 8.7.25 server |
|
| SingleStore 8.7.29 server |
|
| SingleStore 8.7.33 server |
|
| SingleStore 8.7.37 server |
|
| SingleStore 8.7.38 server |
|
| SingleStore 8.9.5 server |
|
| SingleStore 8.9.9 server |
|
| SingleStore 8.9.12 server |
|
| SingleStore 8.9.18 server |
|
| SingleStore 8.9.22 server |
|
| SingleStore 8.9.27 server |
|
| SingleStore 8.9.29 server |
|
| Snowflake |
|
| SQL Server 2019 CU31 |
|
| SQL Server 2019 CU32 |
|
| SQL Server 2022 CU17 |
|
| SQL Server 2022 CU18 |
|
| SQL Server 2022 CU19 |
|
| SQL Server 2022 CU20 |
|
| Sybase IQ Server 16.1 SP5 PL14 |
|
| Sybase IQ Server 16.1 SP5 PL15 |
|
| Teradata 17.20 server |
|
| Teradata 17.20.03.39 server |
|
| Teradata 20 server |
|
| Trino Server 469 |
|
| Trino Server 470 |
|
| Trino Server 471 |
|
| Trino Server 472 |
|
| Trino Server 473 |
|
| Trino Server 474 |
|
| Trino Server 475 |
|
| Trino Server 476 |
|
| TIBCO Composite Server 8.5 | Tibco Composite JDBC driver version 8.5.0 |
| Vertica 25.1 server |
|
| watsonx.data server |
|
OLAP Data sources
The following OLAP driver versions were tested using DQM with Cognos Analytics 12.1.1:
Database type | Dynamic Query versions |
| IBM Planning Analytics as a Service 12.4.7 Server |
|
| IBM Planning Analytics 2.1.12 Server |
|
| IBM Planning Analytics 2.0.920 Server |
|
| IBM Cognos PowerCube |
|
| Azure Analysis Services server |
|
| MS Analysis Services 2019 CU31 server |
|
| MS Analysis Services 2019 CU32 server |
|
| MS Analysis Services 2019 CU32 server |
|
| MS Analysis Services 2022 CU18 server |
|
| MS Analysis Services 2022 CU19 server |
|
| MS Analysis Services 2022 CU20 server |
|
| MS Analysis Services 2019 CU31 server |
|
| MS Analysis Services 2019 CU32 server |
|
| MS Analysis Services 2022 CU18 server |
|
| MS Analysis Services 2022 CU19 server |
|
| MS Analysis Services 2022 CU20 server |
|
| SAP BW 7.5 SP31 server |
|
| SAP BW/4Hana server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.1.0
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.1.0:
Database type | Dynamic Query versions |
| Amazon Athena |
|
| Amazon Redshift |
|
| Apache Hive Server 3.1.3000.7.1.7.0-551 |
|
| Azure Synapse |
|
| Azure SQL |
|
| BigSQL 7.1.0 server |
|
| Cloudera Impala 3.4 server |
|
| Cloudera Impala 4.0 server |
|
| CDATA Connect Cloud |
|
| Databricks |
|
| IBM DB2 11.5.9 server |
|
| IBM DB2 12 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 |
|
| Denodo 8.0.20240306 server |
|
| Denodo 9.0 server |
|
| Dremio 25.0.7 |
|
| Exasol 8.29 server |
|
| Exasol 8.33 server |
|
| Google BigQuery |
|
| IBM Netezza Performance server 11.2.0.0 |
|
| Informix V14.10.XC11 server |
|
| Informix V15.0 server |
|
| MariaDB 10.11.9 server |
|
| MariaDB 11.4.3 server |
|
| MariaDB 11.4.4 server |
|
| MySQL 8.1 server |
|
| MySQL 8.4.3 server |
|
| Oracle Server 19.25 |
|
| Oracle Server 21.15 |
|
| Oracle Server 21.16 |
|
| Oracle Server 23.5 |
|
| VMware Tanzu Greenplum 6.28.2 server |
|
| VMware Tanzu Greenplum 7.4 server |
|
| PostgreSQL Server 15.8 |
|
| PostgreSQL Server 16.4 |
|
| PostgreSQL Server 16.5 |
|
| PostgreSQL Server 17 |
|
| PostgreSQL Server 17.1 |
|
| PostgreSQL Server 17.2 |
|
| Progress DataDirect Autonomous REST |
|
| SAP HANA 2.0 SP06 server |
|
| SAP HANA 2.0 SP07 server |
|
| SingleStore 8.5.22 server |
|
| SingleStore 8.5.36 server |
|
| SingleStore 8.5.38 server |
|
| SingleStore 8.7.9 server |
|
| SingleStore 8.7.12 server |
|
| SingleStore 8.7.19 server |
|
| Snowflake |
|
| SQL Server 2019 CU28 |
|
| SQL Server 2019 CU28 (security update v15.0.4390.2) |
|
| SQL Server 2019 CU29 |
|
| SQL Server 2019 CU30 |
|
| SQL Server 2022 CU14 |
|
| SQL Server 2022 CU15 |
|
| SQL Server 2022 CU16 |
|
| 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 |
|
| Teradata 20 server |
|
| Trino Server 454 |
|
| Trino Server 455 |
|
| Trino Server 457 |
|
| Trino Server 458 |
|
| Trino Server 459 |
|
| Trino Server 460 |
|
| Trino Server 461 |
|
| Trino Server 462 |
|
| Trino Server 463 |
|
| Trino Server 464 |
|
| Trino Server 465 |
|
| Trino Server 466 |
|
| Trino Server 467 |
|
TIBCO Composite Server 8.5 |
|
| Vertica 24.4 server |
|
| watsonx.data server |
|
OLAP Data sources
The following OLAP driver versions were tested using DQM with Cognos Analytics 12.1.0:
Database type | Dynamic Query versions |
| IBM Planning Analytics 12.4.7 Server |
|
| IBM Planning Analytics 2.1.7 Server |
|
| IBM Planning Analytics 2.0.920 Server |
|
| Azure Analysis Services server |
|
| IBM Cognos Powercube |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2022 CU13 server |
|
| MS Analysis Services 2022 CU13 server |
|
| MS Analysis Services 2022 CU13 server |
|
| MS Analysis Services 2022 CU13 server |
|
| MS Analysis Services 2022 CU14 server |
|
| MS Analysis Services 2022 CU15 server |
|
| MS Analysis Services 2022 CU16 server |
|
| MS Analysis Services 2022 CU17 server |
|
| MS Analysis Services 2022 CU17 server |
|
| MS Analysis Services 2019 CU30 server |
|
| MS Analysis Services 2022 CU14 server |
|
| MS Analysis Services 2022 CU15 server |
|
| MS Analysis Services 2022 CU16 server |
|
| MS Analysis Services 2022 CU17 server |
|
SAP BW 7.5 SP30 server |
|
| SAP BW 7.5 SP31 server |
|
[{"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:
03 November 2025
UID
ibm17185328