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.0.x release.
Content
- DQM-tested drivers for Release 12.0.3 [Relational] | [OLAP]
- DQM-tested drivers for Release 12.0.2 [Relational] | [OLAP]
- DQM-tested drivers for Release 12.0.1 [Relational] | [OLAP]
- DQM-tested drivers for Release 12.0.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 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
- You can also view a list of CQM-tested drivers for release 12.0.3
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.3
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.0.3:
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.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 |
|
Denodo 7.0.20230621 server |
|
Denodo 8.0.20230914 server |
|
Denodo 8.0.20230130 server |
|
Dremio 24.2.5 |
|
Dremio 24.3.1 |
|
Dremio 24.3.3 |
|
Exasol 7.1.19 server |
|
Exasol 8.24 server |
|
Google BigQuery |
|
IBM Cloud Data Engine |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MariaDB 10.11.5 server |
|
MariaDB 10.11.6 server |
|
MySQL 8.0.3 server |
|
MySQL 8.1 server |
|
Oracle Server 19.21 |
|
Oracle Server 21.10 |
|
Oracle Server 21.11 |
|
Oracle Server 23.3 |
|
VMware Tanzu Greenplum 6.25.2 server |
|
VMware Tanzu Greenplum 7.0.0 server |
|
PostgreSQL Server 15.5 |
|
PostgreSQL Server 16.1 |
|
PostgreSQL Server 16.2 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP06 server |
|
SAP HANA 2.0 SP07 server |
|
SingleStore 8.1.27 server |
|
SingleStore 8.5.1 server |
|
Snowflake |
|
SQL Server 2019 CU23 |
|
SQL Server 2019 CU24 |
|
SQL Server 2022 CU9 |
|
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 |
|
Trino Server 427 |
|
Trino Server 428 |
|
Trino Server 429 |
|
Trino Server 430 |
|
Trino Server 431 |
|
Trino Server 432 |
|
Trino Server 433 |
|
Trino Server 434 |
|
Trino Server 435 |
|
Trino Server 436 |
|
Trino Server 437 |
|
Trino Server 438 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12 server |
|
Vertica 24 server |
|
watsonx.data server |
|
OLAP Data sources
The following OLAP driver versions were tested using DQM with Cognos Analytics 12.0.3:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.19 Server |
|
Azure Analysis Services server |
|
Azure Analysis Services server |
|
Azure Analysis Services server |
|
Azure Analysis Services server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2022 CU1 server |
|
MS Analysis Services 2022 CU2 server |
|
MS Analysis Services 2022 CU3 server |
|
MS Analysis Services 2022 CU4 server |
|
MS Analysis Services 2022 CU5 server |
|
MS Analysis Services 2022 CU6 server |
|
MS Analysis Services 2022 CU7 server |
|
MS Analysis Services 2022 CU8 server |
|
MS Analysis Services 2022 CU9 server |
|
MS Analysis Services 2022 CU10 server |
|
MS Analysis Services 2022 CU11 server |
|
MS Analysis Services 2019 CU23 server |
|
MS Analysis Services 2022 CU8 server |
|
MS Analysis Services 2022 CU9 server |
|
MS Analysis Services 2022 CU10 server |
|
MS Analysis Services 2022 CU11 server |
|
SAP BW 7.5 SP27 server
|
|
SAP BW 7.5 SP28 server
|
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.2
Note:
You can also view a list of CQM-tested drivers for release 12.0.2
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.0.2:
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.7 server |
|
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 |
|
Denodo 7.0.20230621 server |
|
Denodo 8.0.20230914 server |
|
Dremio 24.2 |
|
Exasol 7.1.19 server |
|
Exasol 8 server |
|
Google BigQuery |
|
IBM Cloud Data Engine |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MariaDB 10.8.3 server |
|
MariaDB 10.11.4 server |
|
Mongo BI Connector Server 2.14.5 |
|
Mongo BI Connector Server 2.14.10 |
|
MySQL 8.0.33 server |
|
MySQL 8.1 server |
|
Oracle Server 19.20 |
|
Oracle Server 21.10 |
|
Oracle Server 21.11 |
|
Oracle Server 23.3 |
|
VMware Tanzu Greenplum 6.25.2 server |
|
VMware Tanzu Greenplum 7.0.0 server |
|
PostgreSQL Server 15.4 |
|
PostgreSQL Server 16.0 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP07 server |
|
SingleStore 8.1.7 server |
|
SingleStore 8.1.8 server |
|
SingleStore 8.1.9 server |
|
SingleStore 8.1.10server |
|
SingleStore 8.1.11 server |
|
SingleStore 8.1.12 server |
|
SingleStore 8.1.13 server |
|
SingleStore 8.1.14 server |
|
SingleStore 8.1.15 server |
|
SingleStore 8.1.16 server |
|
SingleStore 8.1.17 server |
|
Snowflake |
|
SQL Server 2019 CU21 |
|
SQL Server 2022 CU6 |
|
SQL Server 2022 CU7 |
|
SQL Server 2022 CU8 |
|
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 |
|
Trino Server 421 |
|
Trino Server 422 |
|
Trino Server 423 |
|
Trino Server 424 |
|
Trino Server 425 |
|
Trino Server 426 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12 server |
|
Vertica 23 server |
|
watsonx.data server |
|
OLAP Data sources
The following OLAP driver versions were tested using DQM with Cognos Analytics 12.0.2:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.18 Server |
|
Azure Analysis Services server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 SP26 server |
|
SAP BW 7.5 SP26 server |
|
MS Analysis Services 2019 CU20 server |
|
MS Analysis Services 2019 CU22 server |
|
MS Analysis Services 2019 CU22 server |
|
MS Analysis Services 2022 CU1 server |
|
MS Analysis Services 2022 CU2 server |
|
MS Analysis Services 2022 CU3 server |
|
MS Analysis Services 2022 CU4 server |
|
MS Analysis Services 2022 CU5 server |
|
MS Analysis Services 2022 CU6 server |
|
MS Analysis Services 2022 CU7 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.1
Note:
You can also view a list of CQM-tested drivers for release 12.0.1
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.0.1:
OLAP Data sources
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 server |
|
Cloudera Impala 3.4 server |
|
Cloudera Impala 4.0 server |
|
CDATA Connect Cloud |
|
Databricks |
|
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 |
|
Denodo 8.0.20230712 server |
|
Dremio 24.0.1 |
|
Dremio 24.1.1 |
|
Exasol 7.1.19 server |
|
Google BigQuery |
|
IBM Cloud Data Engine |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC10 server |
|
MariaDB 10.8.3 server |
|
MariaDB 10.11.3 server |
|
MariaDB 10.11.4 server |
|
Mongo BI Connector Server 2.14.4 |
|
Mongo BI Connector Server 2.14.5 |
|
MySQL 8.0.32 server |
|
MySQL 8.0.33 server |
|
Oracle Server 19.19 |
|
Oracle Server 21.9 |
|
VMware Tanzu Greenplum 6.25.1 server |
|
PostgreSQL Server 14.5 |
|
PostgreSQL Server 15.3 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP07 server |
|
SingleStore 8.06 server |
|
SingleStore 8.07 server |
|
SingleStore 8.08 server |
|
SingleStore 8.09 server |
|
SingleStore 8.0.10 server |
|
SingleStore 8.0.11 server |
|
SingleStore 8.0.12 server |
|
SingleStore 8.0.13 server |
|
SingleStore 8.0.14 server |
|
SingleStore 8.0.15 server |
|
SingleStore 8.0.16 server |
|
SingleStore 8.0.17 server |
|
SingleStore 8.0.18 server |
|
SingleStore 8.0.19 server |
|
SingleStore 8.1.1 server |
|
SingleStore 8.1.2 server |
|
SingleStore 8.1.3 server |
|
SingleStore 8.1.4 server |
|
SingleStore 8.1.5 server |
|
SingleStore 8.1.6 server |
|
Snowflake |
|
SQL Server 2019 CU20 |
|
SQL Server 2019 CU21 |
|
SQL Server 2022 CU2 |
|
SQL Server 2022 CU3 |
|
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 |
|
Trino Server 409 |
|
Trino Server 410 |
|
Trino Server 411 |
|
Trino Server 412 |
|
Trino Server 413 |
|
Trino Server 414 |
|
Trino Server 415 |
|
Trino Server 416 |
|
Trino Server 417 |
|
Trino Server 418 |
|
Trino Server 419 |
|
Trino Server 420 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12.0.4 server |
|
watsonx.data server |
|
OLAP Data sources
The following OLAP client driver versions were tested using DQM with Cognos Analytics 12.0.1:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.18 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 SP25 server |
|
SAP BW 7.5 SP26 server |
|
MS Analysis Services 2019 CU20 server |
|
MS Analysis Services 2022 CU1 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.0
Note:
You can also view a list of CQM-tested drivers for release 12.0.0
Relational Data Sources
The following driver versions were tested using DQM with Cognos Analytics 12.0.0:
OLAP Data sources
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 server |
|
Cloudera Impala 3.4 server |
|
Cloudera Impala 4.0 server |
|
CDATA Connect Cloud |
|
Databricks |
|
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 |
|
Denodo 8.0.20230301 server |
|
Dremio 22.1.5 |
|
Dremio 23.0.1 |
|
Dremio 24.0.0 |
|
Exasol 7.1.3 server |
|
Google BigQuery |
|
IBM Cloud Data Engine |
|
IBM Netezza Performance server 11.2.0.0 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC9 server |
|
MariaDB 10.7.4 server |
|
MariaDB 10.8.3 server |
|
Mongo BI Connector Server 2.14.4 |
|
Mongo BI Connector Server 2.14.5 |
|
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 |
|
VMware Tanzu Greenplum 6.22 server |
|
PostgreSQL Server 14.5 |
|
PostgreSQL Server 15.0 |
|
PostgreSQL Server 15.1 |
|
PostgreSQL Server 15.2 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP06 server |
|
SingleStore 7.8.11 server |
|
SingleStore 7.8.12 server |
|
SingleStore 7.8.13 server |
|
SingleStore 7.8.14 server |
|
SingleStore 8.0.5 server |
|
Snowflake |
|
SQL Server 2019 CU19 |
|
SQL Server 2022 |
|
SQL Server 2022 CU1 |
|
Sybase ASE Server 16 SP4 |
|
Sybase IQ Server 16.1 SP5 PLO7 |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
Trino Server 395 |
|
Trino Server 396 |
|
Trino Server 397 |
|
Trino Server 398 |
|
Trino Server 399 |
|
Trino Server 400 |
|
Trino Server 401 |
|
Trino Server 402 |
|
Trino Server 403 |
|
Trino Server 405 |
|
Trino Server 406 |
|
Trino Server 407 |
|
Trino Server 408 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12.0.3 server |
|
OLAP Data sources
The following OLAP driver versions were tested using DQM with Cognos Analytics 12.0.0:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.16 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU19 server |
|
[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"12.0.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
25 April 2024
UID
ibm16989513