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 11.2.x release.
Content
- Release 11.2.4 FP3 [Relational] | [OLAP]
- Release 11.2.4 FP2 [Relational] | [OLAP]
- Release 11.2.4 FP1 [Relational] | [OLAP]
- Release 11.2.4 [Relational] | [OLAP]
- Release 11.2.3 [Relational] | [OLAP]
- Release 11.2.2 [Relational] | [OLAP]
- Release 11.2.1 [Relational] | [OLAP]
- Release 11.2.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 11.2.x release
- IBM Cognos Analytics on Premises 11.2.x: Supported Software Environments
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 11.2.4 FP3
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP3:
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.0 server |
|
BigSQL 7.1 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 8.0.20230301 server |
|
Denodo 8.0.20230914 server |
|
Dremio 24.1.1 |
|
Dremio 24.2 |
|
Dremio 24.2.5 |
|
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.11.3 server |
|
MariaDB 10.11.4 server |
|
MariaDB 10.11.5 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.19 |
|
Oracle Server 19.20 |
|
Oracle Server 21.10 |
|
Oracle Server 21.11 |
|
Oracle Server 23.3 |
|
VMware Tanzu Greenplum 6.25.1 server |
|
VMware Tanzu Greenplum 6.25.2 server |
|
VMware Tanzu Greenplum 7 server |
|
PostgreSQL Server 15.4 |
|
PostgreSQL Server 16 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP06 server |
|
SAP HANA 2.0 SP07 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 |
|
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.17server |
|
Snowflake |
|
SQL Server 2019 CU21 |
|
SQL Server 2019 CU23 |
|
SQL Server 2022 CU4 |
|
SQL Server 2022 CU5 |
|
SQL Server 2022 CU6 |
|
SQL Server 2022 CU7 |
|
SQL Server 2022 CU8 |
|
SQL Server 2022 CU9 |
|
Sybase ASE Server 16 SP04 PL03 |
|
Sybase ASE Server 16 SP04 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 418 |
|
Trino Server 419 |
|
Trino Server 420 |
|
Trino Server 421 |
|
Trino Server 422 |
|
Trino Server 423 |
|
Trino Server 424 |
|
Trino Server 425 |
|
Trino Server 426 |
|
Trino Server 427 |
|
Trino Server 428 |
|
Trino Server 429 |
|
Trino Server 430 |
|
Trino Server 431 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12.0.4 server |
|
Vertica 23 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP3:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.19 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 SP26 server |
|
MS Analysis Services 2019 CU19 server |
|
MS Analysis Services 2019 CU22 server |
|
MS Analysis Services 2019 CU23 server |
|
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 11.2.4 FP2
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP2:
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 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 24.0.0 |
|
Dremio 24.0.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.7.4 server |
|
MariaDB 10.8.3 server |
|
Mongo BI Connector Server 2.14.5 |
|
MySQL 8.0.32 server |
|
MySQL 8.0.33 server |
|
Oracle Server 19.18 |
|
Oracle Server 21.9 |
|
VMware Tanzu Greenplum 6.22 server |
|
PostgreSQL Server 14.5 |
|
PostgreSQL Server 15.2 |
|
PostgreSQL Server 15.3 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP06 server |
|
SAP HANA 2.0 SP07 server |
|
SingleStore 8.0.6 server |
|
SingleStore 8.0.7 server |
|
SingleStore 8.0.8 server |
|
SingleStore 8.0.9 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 |
|
Snowflake |
|
SQL Server 2019 CU19 |
|
SQL Server 2019 CU20 |
|
SQL Server 2022 CU1 |
|
SQL Server 2022 CU2 |
|
SQL Server 2022 CU3 |
|
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 407 |
|
Trino Server 408 |
|
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 |
|
TIBCO Composite Server 8.5
|
|
Vertica 12.0.3 server |
|
Vertica 12.0.4 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP2:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.17 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 SP25 server |
|
MS Analysis Services 2019 CU19 server |
|
MS Analysis Services 2019 CU20 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 11.2.4 FP1
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP1:
OLAP Data sources
Database type
|
Dynamic Query versions
|
Google BigQuery |
|
Amazon Athena |
|
Snowflake |
|
Amazon Redshift |
|
Denodo 8.0.20221220 server |
|
Exasol 7.1.3 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 |
|
VMware Tanzu Greenplum 6.22 server |
|
Apache Hive Server 3.1.3000.7.1.7.0-551 |
|
Cloudera Impala 3.4 server |
|
Cloudera Impala 4.0 server |
|
CDATA Connect Cloud |
|
Databricks server |
|
BigSQL 7.1 server |
|
Azure Synapse Datawarehouse |
|
Azure SQL |
|
MariaDB 10.8.3 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 |
|
SAP HANA 2.0 SP05 server |
|
SAP HANA 2.0 SP06 server |
|
TIBCO Composite Server 8.5
|
|
Mongo BI Connector Server 2.14.4 |
|
Mongo BI Connector Server 2.14.5 |
|
Vertica 12.0 server |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
|
|
IBM Db2 Z Server 13 |
|
IBM Db2 11.5.8 server |
|
IBM Cloud Data Engine |
|
Dremio 22.1.5 |
|
Dremio 23.0.1 |
|
PostgreSQL Server 15.0 |
|
PostgreSQL Server 15.1 |
|
Progress DataDirect Autonomous REST |
|
MySQL 8.0.30 server |
|
MySQL 8.0.31 server |
|
Oracle Server 19.16
|
|
Oracle Server 19.17 |
|
Oracle Server 21.7 |
|
Oracle Server 21.8 |
|
SQL Server 2019 CU17 |
|
SQL Server 2022 |
|
Informix V12.10.XC14 server |
|
Informix V14.10.XC8 server | Informix JDBC driver version 4.50.JC7 |
Informix V14.10.XC9 server | Informix JDBC driver version 4.50.JC7 |
Sybase ASE Server 16 SP3 |
|
Sybase ASE Server 16 SP4 |
|
Sybase IQ Server 16.1 SP5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4 FP1:
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 CU8 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 11.2.4
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4:
OLAP Data sources
Database type
|
Dynamic Query versions
|
Google BigQuery |
|
Amazon Athena |
|
Snowflake |
|
Amazon Redshift |
|
Denodo 8.0.20220815 server |
|
Exasol 7.1.3 server |
|
Trino Server 380 |
|
Trino Server 381 |
|
Trino Server 382 |
|
Trino Server 383 |
|
Trino Server 384 |
|
Trino Server 385 |
|
Trino Server 386 |
|
Trino Server 387 |
|
Trino Server 388 |
|
Trino Server 389 |
|
Trino Server 390 |
|
Trino Server 391 |
|
Trino Server 392 |
|
Trino Server 393 |
|
Trino Server 394 |
|
VMware Tanzu Greenplum 6.21 server |
|
VMware Tanzu Greenplum 6.22 server |
|
Apache Hive Server 3.1.3000.7.1.7.0-551 |
|
Cloudera Impala 3.4 server |
|
CDATA Connect Cloud |
|
Databricks server |
|
BigSQL 7.1 server |
|
Azure Synapse Datawarehouse |
|
Azure SQL |
|
MariaDB 10.7.4 server |
|
MariaDB 10.8.3 server |
|
SingleStore 7.8.3 server |
|
SingleStore 7.8.4 server |
|
SingleStore 7.8.5 server |
|
SingleStore 7.8.6 server |
|
SingleStore 7.8.7 server |
|
SingleStore 7.8.8 server |
|
SingleStore 7.8.9 server |
|
SingleStore 7.8.10 server |
|
SAP HANA 2.0 SP05 server |
|
SAP HANA 2.0 SP06 server |
|
TIBCO Composite Server 8.5
|
|
Mongo BI Connector Server 2.14.4 |
|
Vertica 11.1.1-3 server |
|
Vertica 12.0 server |
|
Teradata 17.10 server |
|
Teradata 17.20 server |
|
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
|
|
IBM Db2 Z Server 12.1.5 |
|
IBM Db2 Z Server 13 |
|
IBM Db2 11.5.7 server |
|
IBM Cloud Data Engine |
|
Dremio 21.1.2 |
|
Dremio 21.2.0 |
|
Dremio 22.1.2 |
|
PostgreSQL Server 12.11 |
|
PostgreSQL Server 13.7 |
|
PostgreSQL Server 14.3 |
|
PostgreSQL Server 14.4 |
|
PostgreSQL Server 14.5 |
|
Progress DataDirect Autonomous REST |
|
MySQL 8.0.30 server |
|
Oracle Server 19.15
|
|
Oracle Server 19.16 |
|
Oracle Server 21.6 |
|
Oracle Server 21.7 |
|
Netezza Server 7.2.1
|
|
SQL Server 2017 CU30 |
|
SQL Server 2019 CU16 |
|
SQL Server 2019 CU17 |
|
Informix V14.10.XC7 server |
|
Sybase ASE Server 16 SP3 |
|
Sybase IQ Server 16.1 SP5 |
|
IBM Netezza Performance server 11.2.0.0 |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.4:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.15 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU8 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 11.2.3
Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.3:
OLAP Data sources
Database type
|
Dynamic Query versions
|
Google BigQuery |
|
Amazon Athena |
|
Snowflake |
|
Amazon Redshift |
|
Denodo 8.0.20220126 server |
|
Exasol 7.1.3 server |
|
Trino Server 366 |
|
Trino Server 367 |
|
Trino Server 368 |
|
Trino Server 369 |
|
Trino Server 370 |
|
Trino Server 371 |
|
Trino Server 372 |
|
Trino Server 373 |
|
Trino Server 374 |
|
Trino Server 375 |
|
Trino Server 376 |
|
Trino Server 377 |
|
Trino Server 378 |
|
Trino Server 379 |
|
VMware Tanzu Greenplum 6.18.2 server |
|
Apache Hive Server 3.1.3000.7.1.7.0-551 |
|
Cloudera Impala 3.4 server |
|
BigSQL 7.1 server |
|
Azure Synapse Analytics |
|
Azure SQL |
|
MariaDB 10.6.7 server |
|
MariaDB 10.7.3 server |
|
SingleStore 7.6.7 server |
|
SingleStore 7.6.8 server |
|
SingleStore 7.6.9 server |
|
SingleStore 7.6.10 server |
|
SingleStore 7.6.11 server |
|
SingleStore 7.8.2 server |
|
SAP HANA 2.0 SP05 server |
|
SAP HANA 2.0 SP06 server |
|
TIBCO Composite Server 8.5
|
|
Mongo BI Connector Server 2.14.4 |
|
Vertica 11.0.2 server |
|
Teradata 17.10 server |
|
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
|
|
IBM Db2 Z Server 12.1.5 |
|
IBM Db2 11.5.7 server |
|
IBM Cloud Data Engine Dynamic Query |
|
Dremio 19.2.0 |
|
Dremio 20.0 |
|
Dremio 20.1 |
|
Dremio 20.1.1 |
|
PostgreSQL Server 14.2 |
|
Progress DataDirect Autonomous REST |
|
MySQL 8.0.28 server |
|
MySQL 8.0.29 server |
|
Oracle Server 19.14
|
|
Oracle Server 19.15 |
|
Oracle Server 21.4 |
|
Oracle Server 21.5 |
|
Oracle Server 21.6 |
|
Netezza Server 7.2.1
|
|
SQL Server 2017 CU28 |
|
SQL Server 2019 CU15 |
|
SQL Server 2019 CU16 |
|
Informix V14.10.XC7 server |
|
Sybase ASE Server 16 SP3 |
|
Sybase IQ Server 16.1 SP5 |
|
IBM Performance server/Netezza 11.2.0.0 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.3:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.14 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU8 server |
|
Oracle Essbase 11.1.2.4 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics 11.2.2
Relational Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.2:
OLAP Data sources
OLAP Data sources
OLAP Data sources
Database type
|
Dynamic Query versions
|
Amazon Athena |
|
Amazon Redshift |
|
Apache Hive Server 3.1.3000.7.1.6.0-297 |
|
Azure SQL |
|
Azure Synapse Datawarehouse |
|
BigSQL 7.1 server |
|
Cloudera Impala 3.4 server |
|
Denodo 8.0.20211129 server |
|
Dremio 19.0.0 |
|
Dremio 19.1.0 |
|
Dremio 19.2.0 |
|
Exasol 7.1.3 server |
|
Google BigQuery |
|
IBM Db2 11.5.7 server |
|
IBM Db2 iSeries Server 7.4 |
|
IBM Db2 Z Server 12.1.5 |
|
IBM Netezza Performance Server 11.2.0.0 server |
|
Informix V14.10.XC7 server |
|
MariaDB 10.5.10 server |
|
MariaDB 10.6.0 server |
|
MariaDB 10.6.3 server |
|
Mongo BI Connector Server 2.14.4 |
|
MySQL 8.0.26 server |
|
MySQL 8.0.27 server |
|
Netezza Server 7.2.1
|
|
Oracle Server 19.12
|
|
Oracle Server 19.13 |
|
Oracle Server 21.3 |
|
PostgreSQL Server 12.8 |
|
PostgreSQL Server 13.4 |
|
PostgreSQL Server 14.0 |
|
PostgreSQL Server 14.1 |
|
Progress DataDirect Autonomous REST |
|
SAP HANA 2.0 SP05 server |
|
SAP HANA 2.0 SP06 server |
|
SingleStore 7.3.12 server |
|
SingleStore 7.3.13 server |
|
SingleStore 7.5.9 server |
|
SingleStore 7.5.10 server |
|
SingleStore 7.5.11 server |
|
SingleStore 7.5.12 server |
|
Snowflake |
|
SQL Server 2019 CU11 |
|
SQL Server 2019 CU12 |
|
SQL Server 2019 CU13 |
|
SQL Server 2019 CU14 |
|
Sybase ASE Server 16 SP3 |
|
Sybase IQ Server 16.1 SP3 |
|
Sybase IQ Server 16.1 SP4 | SAP JConnect JDBC driver version 20.0.0 |
Teradata 17.10 server |
|
TIBCO Composite Server 8.5 |
|
Trino Server 360 |
|
Trino Server 361 |
|
Trino Server 362 |
|
Trino Server 363 |
|
Trino Server 364 |
|
Trino Server 365 |
|
Vertica 11.00 server |
|
VMware Tanzu Greenplum 6.18.2 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.2:
Database type
|
Dynamic Query versions
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
IBM Planning Analytics 2.0.9.12 Server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU8 server |
|
Oracle Essbase 11.1.2.4 server |
|
SAP BW 7.5 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics 11.2.1
Relational Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.1:
Database type
|
Dynamic Query versions
|
Google BigQuery |
|
Amazon Athena |
|
Snowflake |
|
Amazon Redshift |
|
Denodo 8 server |
|
Exasol 7.0.10 server |
|
Trino Server 351 |
|
Trino Server 352 |
|
Trino Server 353 |
|
Trino Server 354 |
|
Trino Server 355 |
|
Trino Server 356 |
|
Trino Server 357 |
|
Trino Server 358 |
|
Trino Server 359 |
|
VMware Tanzu Greenplum 6.16.0 server |
|
Apache Hive Server 3.1 |
|
Apache Hive Server 3.1.3000.7.1.6.0-297 |
|
Cloudera Impala 3.4 server |
|
BigSQL 7.1 server |
|
BigSQL 7.1 server |
|
Azure Synapse Analytics 12.00.2531 |
|
Azure SQL 12.00.2000 |
|
MariaDB 10.4.16 server |
|
MariaDB 10.4.17 server |
|
MariaDB 10.4.18 server |
|
MariaDB 10.5.7 server |
|
MariaDB 10.5.8 server |
|
MariaDB 10.5.9 server |
|
SingleStore 7.3.6 server |
|
SingleStore 7.3.9 server |
|
SingleStore 7.3.10 server |
|
SingleStore 7.3.11 server |
|
SAP HANA 2.0 SP05 server |
|
TIBCO Composite Server 8.4 |
|
Mongo BI Connector Server 2.14.1 |
|
Mongo BI Connector Server 2.14.3 |
|
Vertica 10.1.0 server |
|
Teradata 17.10 server |
|
IBM Db2 iSeries JT400 Server 7.4 |
|
IBM Db2 iSeries JT400 Server 7.4 |
|
IBM Db2 Z Server 12.1.5 |
|
IBM Db2 11.5.5 server |
|
IBM Db2 11.5.6 server |
|
Dremio 15.7 |
|
Dremio 16.0 |
|
Dremio 17.0.0 |
|
IBM Cloud SQL Query |
|
PostgreSQL Server 12.6 |
|
PostgreSQL Server 12.7 |
|
PostgreSQL Server 13.2 |
|
PostgreSQL Server 13.3 |
|
Progress DataDirect Autonomous REST |
|
MySQL 8.0.23 server |
|
MySQL 8.0.24 server |
|
MySQL 8.0.25 server |
|
Oracle Server 19.10
|
|
Oracle Server 19.11 |
|
Oracle Server 21.1 |
|
Netezza Server 7.2.1
|
|
SQL Server 2017 14.00.3391 |
|
SQL Server 2019 15.0.4073.23 |
|
Informix V14.10.XC5 server |
|
Informix V14.10.XC6 server |
|
Sybase ASE Server 16 SP3 |
|
Sybase IQ Server 16.1 SP4 |
|
IBM Performance server/Netezza 11.2.0.0 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.1:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.9 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 server |
|
MS Analysis Services 2019 CU8 server |
|
MS Analysis Services 2019 CU8 server |
|
Oracle Essbase 11.1.2.4 server |
|
Vendor-supported client driver versions that were tested using DQM with Cognos Analytics 11.2.0
Relational Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.0:
Database type
|
Dynamic Query versions
|
Google BigQuery |
|
Amazon Athena |
|
Snowflake |
|
Amazon Redshift |
|
Denodo 8 server |
|
Exasol 6.2.7 server |
|
Exasol 7.0.4 server |
|
Exasol 7.0.6 server |
|
Presto Server 333 |
|
Presto Server 334 |
|
Presto Server 335 |
|
Presto Server 336 |
|
Presto Server 337 |
|
Presto Server 338 |
|
Presto Server 339 |
|
Presto Server 340 |
|
Presto Server 341 |
|
Presto Server 342 |
|
Presto Server 343 |
|
Presto Server 344 |
|
Presto Server 345 |
|
Presto Server 346 |
|
Presto Server 347 |
|
Presto Server 348 |
|
Presto Server 350 |
|
Greenplum 6.8.1 server |
|
Greenplum 6.10.1 server |
|
Greenplum 6.12.0 server |
|
Greenplum 6.13.0 server |
|
Apache Hive Server 3.1 |
|
Cloudera Impala 3.4 server |
|
BigSQL 7.0.0 server |
|
BigSQL 7.1.0 server |
|
BigSQL 7.1.0 server |
|
Azure Synapse Analytics 12.00.2531 |
|
Azure SQL 12.00.2000 |
|
MariaDB 10.5.4 server |
|
MariaDB 10.5.5 server |
|
MariaDB 10.5.6 server |
|
MemSQL 7.1.7 server |
|
MemSQL 7.1.11 server |
|
SAP HANA 2.00.050.00 SP05 server |
|
TIBCO Composite Server 8.3 |
|
Mongo BI Connector Server 2.14.0 |
|
Vertica 10.0 server |
|
Vertica 10.0 server |
|
Teradata 17.0 server |
|
Teradata 17.0 server |
|
Teradata 17.0 server |
|
Teradata 17.0 server |
|
Teradata 17.05.02.01 server |
|
IBM Db2 iSeries JT400 Server 7.4 |
|
IBM Db2 iSeries JT400 Server 7.4 |
|
IBM Db2 Z Server 12.1.5 |
|
IBM Db2 11.5.4 server |
|
IBM Db2 11.5.4 server |
|
IBM Db2 11.5.5 server |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.8 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 11.9 |
|
PostgreSQL Server 12.3 |
|
PostgreSQL Server 12.4 |
|
PostgreSQL Server 13.0 |
|
PostgreSQL Server 13.1 |
|
PostgreSQL Server 13.1 |
|
PostgreSQL Server 13.1 |
|
Progress DataDirect Autonomous REST |
|
MySQL 8.0.20 server |
|
MySQL 8.0.21 server |
|
MySQL 8.0.22 server |
|
Oracle Server 18.10
|
|
Oracle Server 19.7 |
|
Oracle Server 19.8 |
|
Oracle Server 19.8 |
|
SQL Server 2017 CU20 |
|
SQL Server 2017 CU21 |
|
SQL Server 2019 CU5 |
|
SQL Server 2019 CU6 |
|
SQL Server 2019 CU8 |
|
Informix V14.10.XC4 server |
|
Sybase ASE Server 16 SP3 |
|
Sybase IQ Server 16.1 SP3 |
|
IBM Performance server/Netezza 11.1.1.0 server |
|
IBM Performance server/Netezza 11.1.1.0 server |
|
OLAP Data sources
The following client driver versions were tested using DQM with Cognos Analytics 11.2.0:
Database type
|
Dynamic Query versions
|
IBM Planning Analytics 2.0.9.2 Server |
|
IBM Planning Analytics 2.0.9.3 Server |
|
IBM Planning Analytics 2.0.9.4 Server |
|
Azure Analysis Services server |
|
IBM Cognos Powercube |
|
SAP BW 7.5 server |
|
MS Analysis Services 2017 server |
|
MS Analysis Services 2017 server |
|
MS Analysis Services 2019 server |
|
MS Analysis Services 2019 server |
|
Oracle Essbase 11.1.2.4 server |
|
[{"Type":"SW","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTSF6","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6nAAC","label":"Installation and Configuration-\u003EData Sources"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.2.0;and future releases"}]
Was this topic helpful?
Document Information
Modified date:
30 January 2024
UID
ibm16441017