IBM Support

DQM testing of vendor-supported client driver versions for each Cognos Analytics 11.2.x release

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

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:
 
Database type
Dynamic Query versions
Amazon Athena
  • JDBC driver 2.0.28.1004
Amazon Redshift
  • JDBC Driver 2.1.0.15
  • JDBC Driver 2.1.0.16
  • JDBC Driver 2.1.0.17
  • JDBC Driver 2.1.0.18
  • JDBC Driver 2.1.0.19
  • JDBC Driver 2.1.0.20
  • JDBC Driver 2.1.0.21
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Azure Synapse
  • Microsoft SQL Server JDBC driver version 12.4.1
Azure SQL
  • Microsoft SQL Server JDBC driver version 12.4.1
BigSQL 7.0 server
  • IBM JCC JDBC driver version 4.32.45
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.32.45
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.32.1041
CDATA Connect Cloud
  • CDATA JDBC driver version 23.0.8565
  • CDATA JDBC driver version 22.0.8669
Databricks
  • Databricks JDBC driver version 2.6.33
  • Databricks JDBC driver version 2.6.34
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.32.45
IBM Db2 11.5.8 server
  • IBM JCC JDBC driver version 4.32.45
Db2 for IBM i server 7.4
  • JTOpen JDBC Driver 20.0.0
  • JTOpen JDBC Driver 20.0.1
  • JTOpen JDBC Driver 20.0.2
  • JTOpen JDBC Driver 20.0.3
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 20.0.0
  • JTOpen JDBC Driver 20.0.1
  • JTOpen JDBC Driver 20.0.2
  • JTOpen JDBC Driver 20.0.3
Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.32.45
Db2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.32.45
Denodo 8.0.20230301 server
  • JDBC driver version 8.0.20230301
Denodo 8.0.20230914 server
  • JDBC driver version 8.0.20230914
Dremio 24.1.1
  • Dremio JDBC Driver 24.1
Dremio 24.2
  • Dremio JDBC Driver 24.2
Dremio 24.2.5
  • Dremio JDBC Driver 24.2
Exasol 7.1.19 server
  • Exasol JDBC driver version 7.1.20
Exasol 8 server
  • Exasol JDBC driver version 7.1.20
Google BigQuery
  • JDBC driver 1.3.3.1004
  • JDBC driver 1.5
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.20
  • IBM Cloud Data Engine JDBC driver 2.7.25
  • IBM Cloud Data Engine JDBC driver 2.7.27
IBM Netezza Performance server 11.2.0.0
  • Netezza nzjdbc 11.2.2.6
  • Netezza nzjdbc 11.2.2.7
Informix V12.10.XC14 server
  • Informix JDBC driver version 4.50.10
Informix V14.10.XC10 server
  • Informix JDBC driver version 4.50.10
MariaDB 10.11.3 server
  • MariaDB JDBC driver version 3.2.0
MariaDB 10.11.4 server
  • MariaDB JDBC driver version 3.2.0
MariaDB 10.11.5 server
  • MariaDB JDBC driver version 3.2.0
Mongo BI Connector Server 2.14.5
  • MySQL JDBC driver version 5.1.47
Mongo BI Connector Server 2.14.10
  • MySQL JDBC driver version 5.1.47
MySQL 8.0.33 server
  • MySQL JDBC driver version 8.0.33
MySQL 8.1 server
  • MySQL JDBC driver version 8.1
Oracle Server 19.19
  • Oracle JDBC Driver 19.18.0.0
  • Oracle JDBC Driver 19.19.0.0
Oracle Server 19.20
  • Oracle JDBC Driver 19.20
Oracle Server 21.10
  • Oracle JDBC Driver 21.10
Oracle Server 21.11
  • Oracle JDBC Driver 21.11
Oracle Server 23.3
  • Oracle JDBC Driver 23.3.0.23.09
VMware Tanzu Greenplum 6.25.1 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
VMware Tanzu Greenplum 6.25.2 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
VMware Tanzu Greenplum 7 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
PostgreSQL Server 15.4
  • PostgreSQL JDBC driver version 42.6.0
PostgreSQL Server 16
  • PostgreSQL JDBC driver version 42.6.0
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.005690
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.17.10
  • SAP Hana JDBC driver version 2.17.11
  • SAP Hana JDBC driver version 2.17.12
  • SAP Hana JDBC driver version 2.17.13
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.17.10
  • SAP Hana JDBC driver version 2.17.11
  • SAP Hana JDBC driver version 2.17.12
  • SAP Hana JDBC driver version 2.17.13
SingleStore 8.1.2 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.3 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.4 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.5 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.6 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.7 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.8 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.9 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.10server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.11 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.12 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.13 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.14 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.15 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.16 server
  • SingleStore JDBC driver version 1.1.5
  • SingleStore JDBC driver version 1.1.6
  • SingleStore JDBC driver version 1.1.7
  • SingleStore JDBC driver version 1.1.8
  • SingleStore JDBC driver version 1.1.9
  • SingleStore JDBC driver version 1.2
SingleStore 8.1.17server
  • SingleStore JDBC driver version 1.1.5
  • SingleStore JDBC driver version 1.1.6
  • SingleStore JDBC driver version 1.1.7
  • SingleStore JDBC driver version 1.1.8
  • SingleStore JDBC driver version 1.1.9
  • SingleStore JDBC driver version 1.2
Snowflake
  • JDBC driver 3.13.31
  • JDBC driver 3.13.32
  • JDBC driver 3.13.33
  • JDBC driver 3.14.0
  • JDBC driver 3.14.1
  • JDBC driver 3.14.2
SQL Server 2019 CU21
  • SQL Server JDBC driver version 12.4.1
SQL Server 2019 CU23
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU4
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU5
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU6
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU7
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU8
  • SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU9
  • SQL Server JDBC driver version 12.4.1
Sybase ASE Server 16 SP04 PL03
  • SAP JConnect JDBC driver version 20.0.0
Sybase ASE Server 16 SP04 PL04
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PLO7
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PLO8
  • SAP JConnect JDBC driver version 20.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 20.00.00.11
  • Teradata JDBC driver version 20.00.00.13
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.11
  • Teradata JDBC driver version 20.00.00.13
Trino Server 418
  • Trino JDBC Driver 418
Trino Server 419
  • Trino JDBC Driver 419
Trino Server 420
  • Trino JDBC Driver 420
Trino Server 421
  • Trino JDBC Driver 421
Trino Server 422
  • Trino JDBC Driver 422
Trino Server 423
  • Trino JDBC Driver 423
Trino Server 424
  • Trino JDBC Driver 424
Trino Server 425
  • Trino JDBC Driver 425
Trino Server 426
  • Trino JDBC Driver 426
Trino Server 427
  • Trino JDBC Driver 427
Trino Server 428
  • Trino JDBC Driver 428
Trino Server 429
  • Trino JDBC Driver 429
Trino Server 430
  • Trino JDBC Driver 430
Trino Server 431
  • Trino JDBC Driver 430
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 12.0.4 server
  • Vertica JDBC Driver 12.0.4
Vertica 23 server
  • Vertica JDBC Driver 23.3
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.82.16
  • MS OLEDB driver for Windows 16.0.90.22
  • MS OLEDB driver for Windows 16.0.95.22
  • MS OLEDB driver for Windows 16.0.99.19
  • MS OLEDB driver for Windows 16.0.104.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 SP26 server
  • SAP 7.5 client (PL10)
  • SAP 7.5 client (PL12)
MS Analysis Services 2019 CU19 server
  • MS OLEDB driver for Windows 16.0.82.16
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU22 server
  • MS OLEDB driver for Windows 16.0.90.22
  • MS OLEDB driver for Windows 16.0.95.22
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • XML/A, no driver needed.
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.99.19
  • MS OLEDB driver for Windows 16.0.104.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • XML/A, no driver needed.
  • 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

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:
 
Database type
Dynamic Query versions
Amazon Athena
  • JDBC driver 2.0.28
Amazon Redshift
  • JDBC Driver 2.1.0.12
  • JDBC Driver 2.1.0.13
  • JDBC Driver 2.1.0.14
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Azure Synapse
  • Microsoft SQL Server JDBC driver version 12.2
Azure SQL
  • Microsoft SQL Server JDBC driver version 12.2
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.32.28
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.30.1036
CDATA Connect Cloud
  • CDATA JDBC driver version 22.0.8462
Databricks
  • Databricks JDBC driver version 2.6.32
IBM Db2 11.5.8 server
  • IBM JCC JDBC driver version 4.32.28
Db2 for IBM i server 7.4
  • JTOpen JDBC Driver 11.2
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 11.2
DB2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.32.28
Db2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.32.28
Denodo 8.0.20230301 server
  • JDBC driver version 8.0.20220815
Dremio 24.0.0
  • Dremio JDBC Driver 24.0.0
Dremio 24.0.1
  • Dremio JDBC Driver 24.0.0
Exasol 7.1.19 server
  • Exasol JDBC driver version 7.1.19
Google BigQuery
  • JDBC driver 1.3.2.1003
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.3
  • IBM Cloud Data Engine JDBC driver 2.7.5
  • IBM Cloud Data Engine JDBC driver 2.7.7
IBM Netezza Performance server 11.2.0.0
  • Netezza nzjdbc 11.2.2.3
Informix V12.10.XC14 server
  • Informix JDBC driver version 4.50.JC7
Informix V14.10.XC10 server
  • Informix JDBC driver version 4.50.JC7
MariaDB 10.7.4 server
  • MariaDB JDBC driver version 3.1.3
  • MariaDB JDBC driver version 3.1.4
MariaDB 10.8.3 server
  • MariaDB JDBC driver version 3.1.3
  • MariaDB JDBC driver version 3.1.4
Mongo BI Connector Server 2.14.5
  • MySQL JDBC driver version 5.1.47
MySQL 8.0.32 server
  • MySQL JDBC driver version 8.0.32
MySQL 8.0.33 server
  • MySQL JDBC driver version 8.0.32
Oracle Server 19.18
  • Oracle JDBC Driver 19.18.0.0
Oracle Server 21.9
  • Oracle JDBC Driver 21.9
  • Oracle JDBC Driver 23.2
VMware Tanzu Greenplum 6.22 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
PostgreSQL Server 14.5
  • PostgreSQL JDBC driver version 42.5.2
  • PostgreSQL JDBC driver version 42.5.3
  • PostgreSQL JDBC driver version 42.5.4
  • PostgreSQL JDBC driver version 42.6.0
PostgreSQL Server 15.2
  • PostgreSQL JDBC driver version 42.5.2
  • PostgreSQL JDBC driver version 42.5.3
  • PostgreSQL JDBC driver version 42.5.4
PostgreSQL Server 15.3
  • PostgreSQL JDBC driver version 42.5.4
  • PostgreSQL JDBC driver version 42.6.0
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.005690
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.15.12
  • SAP Hana JDBC driver version 2.16.10
  • SAP Hana JDBC driver version 2.16.11
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.15.12
  • SAP Hana JDBC driver version 2.16.10
  • SAP Hana JDBC driver version 2.16.11
SingleStore 8.0.6 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 8.0.7 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 8.0.8 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 8.0.9 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 8.0.10 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.11 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.12 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.13 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.14 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.15 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.16 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.17 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.18 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.0.19 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.1.1 server
  • SingleStore JDBC driver version 1.1.5
Snowflake
  • JDBC driver 3.13.27
  • JDBC driver 3.13.28
  • JDBC driver 3.13.29
  • JDBC driver 3.13.30
SQL Server 2019 CU19
  • Microsoft SQL Server JDBC driver version 11.2.3
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2019 CU20
  • Microsoft SQL Server JDBC driver version 11.2.3
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU1
  • Microsoft SQL Server JDBC driver version 11.2.3
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU2
  • Microsoft SQL Server JDBC driver version 11.2.3
  • SQL Server JDBC driver version 12.2
SQL Server 2022 CU3
  • SQL Server JDBC driver version 12.2
Sybase ASE Server 16 SP4 PL03
  • SAP JConnect JDBC driver version 20.0.0
Sybase ASE Server 16 SP4 PL04
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PLO7
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PLO8
  • SAP JConnect JDBC driver version 20.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 20.00.00.10
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.10
Trino Server 407
  • Trino JDBC Driver 407
Trino Server 408
  • Trino JDBC Driver 408
Trino Server 409
  • Trino JDBC Driver 409
Trino Server 410
  • Trino JDBC Driver 410
Trino Server 411
  • Trino JDBC Driver 411
Trino Server 412
  • Trino JDBC Driver 412
Trino Server 413
  • Trino JDBC Driver 413
Trino Server 414
  • Trino JDBC Driver 414
Trino Server 415
  • Trino JDBC Driver 415
Trino Server 416
  • Trino JDBC Driver 416
Trino Server 417
  • Trino JDBC Driver 417
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 12.0.3 server
  • Vertica JDBC Driver 12.0.3.0
Vertica 12.0.4 server
  • Vertica JDBC Driver 12.0.4.0
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.70.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 SP25 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU19 server
  • MS OLEDB driver for Windows 16.0.70.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • XML/A, no driver needed.
MS Analysis Services 2019 CU20 server
  • MS OLEDB driver for Windows 16.0.70.21

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:
 
Database type
Dynamic Query versions
Google BigQuery
  • JDBC driver 1.3.0.1001
Amazon Athena
  • JDBC driver 2.0.28
Snowflake
  • JDBC driver 3.13.23
  • JDBC driver 3.13.24
  • JDBC driver 3.13.25
  • JDBC driver 3.13.26
Amazon Redshift
  • JDBC Driver 2.1.0.10
Denodo 8.0.20221220 server
  • JDBC driver version 8.0 20220815
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.1.7
  • Exasol JDBC driver version 7.1.14
  • Exasol JDBC driver version 7.1.16
  • Exasol JDBC driver version 7.1.17
Trino Server 395
  • Trino JDBC Driver 395
Trino Server 396
  • Trino JDBC Driver 396
Trino Server 397
  • Trino JDBC Driver 397
Trino Server 398
  • Trino JDBC Driver 398
Trino Server 399
  • Trino JDBC Driver 399
Trino Server 400
  • Trino JDBC Driver 400
Trino Server 401
  • Trino JDBC Driver 401
Trino Server 402
  • Trino JDBC Driver 402
Trino Server 403
  • Trino JDBC Driver 403
Trino Server 405
  • Trino JDBC Driver 405
Trino Server 406
  • Trino JDBC Driver 406
VMware Tanzu Greenplum 6.22 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.29.1035
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.29.1035
CDATA Connect Cloud
  • CDATA JDBC driver version 22.0.8327
Databricks server
  • Databricks JDBC driver version 2.6.32
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.31.10
  • IBM JCC JDBC driver version 4.32.28
Azure Synapse Datawarehouse
  • Microsoft SQL Server JDBC driver version 11.2.0
Azure SQL
  • Microsoft SQL Server JDBC driver version 11.2.0
MariaDB 10.8.3 server
  • MariaDB JDBC driver version 3.0.8
  • MariaDB JDBC driver version 3.0.9
  • MariaDB JDBC driver version 3.1.2
SingleStore 7.8.11 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 7.8.12 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 7.8.13 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 7.8.14 server
  • SingleStore JDBC driver version 1.1.4
SingleStore 8.0.5 server
  • SingleStore JDBC driver version 1.1.4
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.14.7
  • SAP Hana JDBC driver version 2.14.9
  • SAP Hana JDBC driver version 2.14.10
  • SAP Hana JDBC driver version 2.15.8
  • SAP Hana JDBC driver version 2.15.10
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.14.7
  • SAP Hana JDBC driver version 2.14.9
  • SAP Hana JDBC driver version 2.14.10
  • SAP Hana JDBC driver version 2.15.8
  • SAP Hana JDBC driver version 2.15.10
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
Mongo BI Connector Server 2.14.5
  • MySQL JDBC driver version 5.1.47
Vertica 12.0 server
  • Vertica JDBC Driver 12.0.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 20.00.00.10
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.10
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
  • JTOpen JDBC Driver 11.1
IBM Db2 Z Server 13
  • IBM JCC JDBC driver version 4.31.10
  • IBM JCC JDBC driver version 4.32.28
IBM Db2 11.5.8 server
  • IBM JCC JDBC driver version 4.31.10
  • IBM JCC JDBC driver version 4.32.28
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.0
Dremio 22.1.5
  • Dremio JDBC Driver 22.0.0
Dremio 23.0.1
  • Dremio JDBC Driver 23.0.1
PostgreSQL Server 15.0
  • PostgreSQL JDBC driver version 42.4.2
  • PostgreSQL JDBC driver version 42.5.1
PostgreSQL Server 15.1
  • PostgreSQL JDBC driver version 42.4.2
  • PostgreSQL JDBC driver version 42.5.1
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
MySQL 8.0.30 server
  • MySQL JDBC driver version 8.0.30
MySQL 8.0.31 server
  • MySQL JDBC driver version 8.0.31
Oracle Server 19.16
  • Oracle JDBC Driver 19.16
Oracle Server 19.17
  • Oracle JDBC Driver 19.17.0.0
Oracle Server 21.7
  • Oracle JDBC Driver 21.7.0.0
Oracle Server 21.8
  • Oracle JDBC Driver 21.8.0.0
SQL Server 2019 CU17
  • Microsoft SQL Server JDBC driver version 11.2.0
  • Microsoft SQL Server JDBC driver version 11.2.1
SQL Server 2022
  • Microsoft SQL Server JDBC driver version 11.2.0
  • Microsoft SQL Server JDBC driver version 11.2.1
Informix V12.10.XC14 server
  • Informix JDBC driver version 4.50.JC7
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
  • SAP JConnect JDBC driver version 20.0.0
Sybase ASE Server 16 SP4
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5
  • SAP JConnect JDBC driver version 20.0.0
IBM Netezza Performance server 11.2.0.0
  • Netezza nzjdbc 11.2.2.3
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows
    • 16.0.49.19
    • 16.0.51.20
    • 16.0.56.19
    • 16.0.61.18
    • 16.0.65.17
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver for Windows
    • 16.0.49.19
    • 16.0.51.20
    • 16.0.56.19
    • 16.0.61.18
    • 16.0.65.17
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.

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:
 
Database type
Dynamic Query versions
Google BigQuery
  • JDBC driver 1.2.25.1029
  • JDBC driver 1.3.0.1001
Amazon Athena
  • JDBC driver 2.0.28
Snowflake
  • JDBC driver 3.13.19
  • JDBC driver 3.13.20
  • JDBC driver 3.13.21
  • JDBC driver 3.13.22
Amazon Redshift
  • JDBC Driver 2.1.0.8
  • JDBC Driver 2.1.0.9
Denodo 8.0.20220815 server
  • JDBC driver version 8.0 20220815
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.1.10
  • Exasol JDBC driver version 7.1.11
Trino Server 380
  • Trino JDBC Driver 380
Trino Server 381
  • Trino JDBC Driver 381
Trino Server 382
  • Trino JDBC Driver 382
Trino Server 383
  • Trino JDBC Driver 383
Trino Server 384
  • Trino JDBC Driver 384
Trino Server 385
  • Trino JDBC Driver 385
Trino Server 386
  • Trino JDBC Driver 386
Trino Server 387
  • Trino JDBC Driver 387
Trino Server 388
  • Trino JDBC Driver 388
Trino Server 389
  • Trino JDBC Driver 389
Trino Server 390
  • Trino JDBC Driver 390
Trino Server 391
  • Trino JDBC Driver 391
Trino Server 392
  • Trino JDBC Driver 392
Trino Server 393
  • Trino JDBC Driver 393
Trino Server 394
  • Trino JDBC Driver 394
VMware Tanzu Greenplum 6.21 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
VMware Tanzu Greenplum 6.22 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.28.1034
  • Cloudera JDBC driver version 2.6.29.1035
CDATA Connect Cloud
  • CDATA JDBC driver version 22.0.8327
Databricks server
  • Databricks JDBC driver version 2.6.29
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.31.10
Azure Synapse Datawarehouse
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
Azure SQL
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
MariaDB 10.7.4 server
  • MariaDB JDBC driver version 3.0.4
  • MariaDB JDBC driver version 3.0.5
  • MariaDB JDBC driver version 3.0.6
  • MariaDB JDBC driver version 3.0.7
MariaDB 10.8.3 server
  • MariaDB JDBC driver version 3.0.4
  • MariaDB JDBC driver version 3.0.5
  • MariaDB JDBC driver version 3.0.6
  • MariaDB JDBC driver version 3.0.7
SingleStore 7.8.3 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.4 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.5 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.6 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.7 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.8 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.9 server
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.10 server
  • SingleStore JDBC driver version 1.1.3
  • SingleStore JDBC driver version 1.1.4
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.12.9
  • SAP Hana JDBC driver version 2.13.5
  • SAP Hana JDBC driver version 2.13.9
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.12.9
  • SAP Hana JDBC driver version 2.13.5
  • SAP Hana JDBC driver version 2.13.9
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
Vertica 11.1.1-3 server
  • Vertica JDBC Driver 11.1.1
Vertica 12.0 server
  • Vertica JDBC Driver 12.0.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 17.20.00.08
Teradata 17.20 server
  • Teradata JDBC driver version 17.20.00.08
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
  • JTOpen JDBC Driver 11
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.31.10
IBM Db2 Z Server 13
  • IBM JCC JDBC driver version 4.31.10
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.31.10
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.5.49
  • IBM Cloud Data Engine JDBC driver 2.7.0
Dremio 21.1.2
  • Dremio JDBC Driver 21.1.2
Dremio 21.2.0
  • Dremio JDBC Driver 21.2.0
Dremio 22.1.2
  • Dremio JDBC Driver 22.0.0
PostgreSQL Server 12.11
  • PostgreSQL JDBC driver version 42.3.5
PostgreSQL Server 13.7
  • PostgreSQL JDBC driver version 42.3.5
PostgreSQL Server 14.3
  • PostgreSQL JDBC driver version 42.3.6
PostgreSQL Server 14.4
  • PostgreSQL JDBC driver version 42.4.0
  • PostgreSQL JDBC driver version 42.4.1
  • PostgreSQL JDBC driver version 42.5.0
PostgreSQL Server 14.5
  • PostgreSQL JDBC driver version 42.4.0
  • PostgreSQL JDBC driver version 42.4.1
  • PostgreSQL JDBC driver version 42.5.0
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
MySQL 8.0.30 server
  • MySQL JDBC driver version 8.0.30
Oracle Server 19.15
  • Oracle JDBC Driver 19.15.0.0.1
Oracle Server 19.16
  • Oracle JDBC Driver 19.15.0.0.1
Oracle Server 21.6
  • Oracle JDBC Driver 21.6.0.0.1
Oracle Server 21.7
  • Oracle JDBC Driver 21.7.0.0
Netezza Server 7.2.1
  • Not tested
SQL Server 2017 CU30
  • Microsoft SQL Server JDBC driver version 10.2.0
SQL Server 2019 CU16
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
SQL Server 2019 CU17
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
Informix V14.10.XC7 server
  • Informix JDBC driver version 4.50.JC7
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5
  • SAP JConnect JDBC driver version 20.0.0
IBM Netezza Performance server 11.2.0.0
  • Netezza nzjdbc 11.2.2.1
  • Netezza nzjdbc 11.2.2.3
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver version 16.0.28.203 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 16.0.20.201 for Windows
  • MS OLEDB driver version 16.0.28.203 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.

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:
 
Database type
Dynamic Query versions
Google BigQuery
  • JDBC driver 1.2.22.1026
  • JDBC driver 1.2.23.1027
Amazon Athena
  • JDBC driver 2.0.27
  • JDBC driver 2.0.28
Snowflake
  • JDBC driver 3.13.12
  • JDBC driver 3.13.13
  • JDBC driver 3.13.14
  • JDBC driver 3.13.15
  • JDBC driver 3.13.16
  • JDBC driver 3.13.17
  • JDBC driver 3.13.18
Amazon Redshift
  • JDBC Driver 2.1.0.3
  • JDBC Driver 2.1.0.4
  • JDBC Driver 2.1.0.5
  • JDBC Driver 2.1.0.6
  • JDBC Driver 2.1.0.7
  • JDBC Driver 2.1.0.9
Denodo 8.0.20220126 server
  • JDBC driver version 8.0 20220126
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.1.3
  • Exasol JDBC driver version 7.1.4
Trino Server 366
  • Trino JDBC Driver 366
Trino Server 367
  • Trino JDBC Driver 367
Trino Server 368
  • Trino JDBC Driver 368
Trino Server 369
  • Trino JDBC Driver 369
Trino Server 370
  • Trino JDBC Driver 370
Trino Server 371
  • Trino JDBC Driver 371
Trino Server 372
  • Trino JDBC Driver 372
Trino Server 373
  • Trino JDBC Driver 373
Trino Server 374
  • Trino JDBC Driver 374
Trino Server 375
  • Trino JDBC Driver 375
Trino Server 376
  • Trino JDBC Driver 376
Trino Server 377
  • Trino JDBC Driver 377
Trino Server 378
  • Trino JDBC Driver 378
Trino Server 379
  • Trino JDBC Driver 379
VMware Tanzu Greenplum 6.18.2 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000181
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.27.1032
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.31.10
Azure Synapse Analytics
  • Microsoft SQL Server JDBC driver version 10.2.0
Azure SQL
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Microsoft SQL Server JDBC driver version 10.2.0
MariaDB 10.6.7 server
  • MariaDB JDBC driver version 2.7.4
  • MariaDB JDBC driver version 2.7.5
  • MariaDB JDBC driver version 3.0.3
  • MariaDB JDBC driver version 3.0.4
MariaDB 10.7.3 server
  • MariaDB JDBC driver version 2.7.5
  • MariaDB JDBC driver version 3.0.3
  • MariaDB JDBC driver version 3.0.4
SingleStore 7.6.7 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.6.8 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.6.9 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.6.10 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.6.11 server
  • MariaDB JDBC driver version 2.7.3
  • MariaDB JDBC driver version 2.7.4
  • MariaDB JDBC driver version 2.7.5
  • SingleStore JDBC driver version 1.1.3
SingleStore 7.8.2 server
  • MariaDB JDBC driver version 2.7.5
  • SingleStore JDBC driver version 1.1.3
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.10.10
  • SAP Hana JDBC driver version 2.12.7
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
Vertica 11.0.2 server
  • Vertica JDBC Driver 11.1.0
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.24
  • Teradata JDBC driver version 17.10.00.25
  • Teradata JDBC driver version 17.10.00.26
  • Teradata JDBC driver version 17.10.00.27
  • Teradata JDBC driver version 17.20
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
  • JTOpen JDBC Driver 11
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.31.10
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.31.10
IBM Cloud Data Engine Dynamic Query
  • IBM Cloud Data Engine JDBC driver 2.5.46
  • IBM Cloud Data Engine JDBC driver 2.5.49
Dremio 19.2.0
  • Dremio JDBC Driver 19.0.0-202110270341120595-3e3e05e7
Dremio 20.0
  • Dremio JDBC Driver 20.1.0-202202061055110045-36733c65
Dremio 20.1
  • Dremio JDBC Driver 19.3.0
  • Dremio JDBC Driver 20.1.0-202202061055110045-36733c65
  • Dremio JDBC Driver 21.1.1
Dremio 20.1.1
  • Dremio JDBC Driver 21.1.1
PostgreSQL Server 14.2
  • PostgreSQL JDBC driver version 42.3.1
  • PostgreSQL JDBC driver version 42.3.3
  • PostgreSQL JDBC driver version 42.3.4
  • PostgreSQL JDBC driver version 42.3.5
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
MySQL 8.0.28 server
  • MySQL JDBC driver version 8.0.28
MySQL 8.0.29 server
  • MySQL JDBC driver version 8.0.29
Oracle Server 19.14
  • Oracle JDBC Driver 19.14.0.0.0
Oracle Server 19.15
  • Oracle JDBC Driver 19.14.0.0.0
Oracle Server 21.4
  • Oracle JDBC Driver 21.4.0.0.1
Oracle Server 21.5
  • Oracle JDBC Driver 21.5.0.0.0
Oracle Server 21.6
  • Oracle JDBC Driver 21.5.0.0.0
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
SQL Server 2017 CU28
  • Microsoft SQL Server JDBC driver version 9.4.0
SQL Server 2019 CU15
  • Microsoft SQL Server JDBC driver version 10.2.0
SQL Server 2019 CU16
  • Microsoft SQL Server JDBC driver version 10.2.0
Informix V14.10.XC7 server
  • Informix JDBC driver version 4.50.JC7
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5
  • SAP JConnect JDBC driver version 20.0.0
IBM Performance server/Netezza 11.2.0.0 server
  • Netezza nzjdbc 11.2.1.1
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver version 16.0.20.201 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 16.0.17.23 for Windows
  • MS OLEDB driver version 16.0.20.201 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client

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:
 
Database type
Dynamic Query versions
Amazon Athena
  • JDBC driver 2.0.23
  • JDBC driver 2.0.24
Amazon Redshift
  • JDBC Driver 2.0.0.6
  • JDBC Driver 2.0.0.7
  • JDBC Driver 2.1.0.1
  • JDBC Driver 2.1.0.2
Apache Hive Server 3.1.3000.7.1.6.0-297
  • Hive JDBC Driver 3.1.3000.7.1.6.0-297
Azure SQL
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
Azure Synapse Datawarehouse
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Microsoft SQL Server JDBC driver version 10.2.1
  • Microsoft SQL Server JDBC driver version 11.2.0
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.31.10
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.23.1028
  • Cloudera JDBC driver version 2.6.24.1029
Denodo 8.0.20211129 server
  • JDBC driver version 8.0 20210209
  • JDBC driver version 8.0 20210715
Dremio 19.0.0
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
Dremio 19.1.0
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
  • Dremio JDBC Driver 18.0.0-202109101536100970-a32fc9f4
  • Dremio JDBC Driver 19.0.0-202110270341120595-3e3e05e7
  • Dremio JDBC Driver 19.1.0-202111160130570172-0ee00450
Dremio 19.2.0
  • Dremio JDBC Driver 19.1.0-202111160130570172-0ee00450
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.0.11
  • Exasol JDBC driver version 7.1.0
  • Exasol JDBC driver version 7.1.1
Google BigQuery
  • JDBC driver 1.2.18.1022
  • JDBC driver 1.2.21.1025
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.29.24
IBM Db2 iSeries Server 7.4
  • JTOpen JDBC Driver 10.7
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.29.24
IBM Netezza Performance Server 11.2.0.0 server
  • Netezza nzjdbc 11.2.1.1
  • Netezza nzjdbc 11.2.2.0
Informix V14.10.XC7 server
  • Informix JDBC driver version 4.50.JC6
MariaDB 10.5.10 server
  • MariaDB JDBC driver version 2.7.3
MariaDB 10.6.0 server
  • MariaDB JDBC driver version 2.7.3
MariaDB 10.6.3 server
  • MariaDB JDBC driver version 2.7.3
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
MySQL 8.0.26 server
  • MySQL JDBC driver version 8.0.26
MySQL 8.0.27 server
  • MySQL JDBC driver version 8.0.27
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
Oracle Server 19.12
  • Oracle JDBC Driver 19.12.0.0.0
Oracle Server 19.13
  • Oracle JDBC Driver 19.13.0.0.1
Oracle Server 21.3
  • Oracle JDBC Driver 21.1.0.0.0
  • Oracle JDBC Driver 21.3.0.0.0
PostgreSQL Server 12.8
  • PostgreSQL JDBC driver version 42.2.23
PostgreSQL Server 13.4
  • PostgreSQL JDBC driver version 42.2.23
PostgreSQL Server 14.0
  • PostgreSQL JDBC driver version 42.2.24
PostgreSQL Server 14.1
  • PostgreSQL JDBC driver version 42.2.24
  • PostgreSQL JDBC driver version 42.3.0
  • PostgreSQL JDBC driver version 42.3.2
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.0.SP5
  • SAP Hana JDBC driver version 2.10.10
SingleStore 7.3.12 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.3.13 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.5.9 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.5.10 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.5.11 server
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.5.12 server
  • MariaDB JDBC driver version 2.7.3
Snowflake
  • JDBC driver 3.13.7
  • JDBC driver 3.13.8
  • JDBC driver 3.13.9
  • JDBC driver 3.13.10
  • JDBC driver 3.13.11
SQL Server 2019 CU11
  • Microsoft SQL Server JDBC driver version 9.2.0
SQL Server 2019 CU12
  • Microsoft SQL Server JDBC driver version 9.2.0
SQL Server 2019 CU13
  • Microsoft SQL Server JDBC driver version 9.2.0
SQL Server 2019 CU14
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
Sybase IQ Server 16.1 SP4 SAP JConnect JDBC driver version 20.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.17
  • Teradata JDBC driver version 17.10.00.20
  • Teradata JDBC driver version 17.10.00.22
  • Teradata JDBC driver version 17.10.00.23
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Trino Server 360
  • Trino JDBC Driver 351
Trino Server 361
  • Trino JDBC Driver 352
Trino Server 362
  • Trino JDBC Driver 353
Trino Server 363
  • Trino JDBC Driver 354
Trino Server 364
  • Trino JDBC Driver 355
Trino Server 365
  • Trino JDBC Driver 356
Vertica 11.00 server
  • Vertica JDBC Driver 11.00.0000
VMware Tanzu Greenplum 6.18.2 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000181
 

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
  • MS OLEDB driver version 15.1.86.19 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
IBM Planning Analytics 2.0.9.12 Server
  • No driver needed
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 15.1.86.19 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 16.0.4.17 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
 

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
  • JDBC driver 1.2.14.1017
  • JDBC driver 1.2.16.1020
  • JDBC driver 1.2.18.1022
  • JDBC driver 1.2.19.1023
Amazon Athena
  • JDBC driver 2.0.23
Snowflake
  • JDBC driver 3.12.17
  • JDBC driver 3.13.0
  • JDBC driver 3.13.1
  • JDBC driver 3.13.2
  • JDBC driver 3.13.3
  • JDBC driver 3.13.4
  • JDBC driver 3.13.5
  • JDBC driver 3.13.6
Amazon Redshift
  • JDBC Driver 1.2.51.1078
  • JDBC Driver 1.2.54.1082
  • JDBC Driver 1.2.55.1083
  • JDBC Driver 2.0.0.5
Denodo 8 server
  • JDBC driver version 8.0 20210209
Exasol 7.0.10 server
  • Exasol JDBC driver version 7.0.4
  • Exasol JDBC driver version 7.0.7
Trino Server 351
  • Trino JDBC Driver 351
Trino Server 352
  • Trino JDBC Driver 352
Trino Server 353
  • Trino JDBC Driver 353
Trino Server 354
  • Trino JDBC Driver 354
Trino Server 355
  • Trino JDBC Driver 355
Trino Server 356
  • Trino JDBC Driver 356
Trino Server 357
  • Trino JDBC Driver 357
Trino Server 358
  • Trino JDBC Driver 358
Trino Server 359
  • Trino JDBC Driver 359
VMware Tanzu Greenplum 6.16.0 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
Apache Hive Server 3.1
  • Hive JDBC Driver 3.1.0.3.1.5.0-152
Apache Hive Server 3.1.3000.7.1.6.0-297
  • Hive JDBC Driver 3.1.3000.7.1.6.0-297
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.18.1021
  • Cloudera JDBC driver version 2.6.20.1024
  • Cloudera JDBC driver version 2.6.23.1028
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.28.11
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.29.24
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 9.2.0
Azure SQL 12.00.2000
  • Microsoft SQL Server JDBC driver version 9.2.0
MariaDB 10.4.16 server
  • MariaDB JDBC driver version 2.7.2
MariaDB 10.4.17 server
  • MariaDB JDBC driver version 2.7.2
MariaDB 10.4.18 server
  • MariaDB JDBC driver version 2.7.2
MariaDB 10.5.7 server
  • MariaDB JDBC driver version 2.7.2
MariaDB 10.5.8 server
  • MariaDB JDBC driver version 2.7.2
MariaDB 10.5.9 server
  • MariaDB JDBC driver version 2.7.2
  • MariaDB JDBC driver version 2.7.3
SingleStore 7.3.6 server
  • MariaDB JDBC driver version 2.7.2
SingleStore 7.3.9 server
  • MariaDB JDBC driver version 2.7.2
SingleStore 7.3.10 server
  • MariaDB JDBC driver version 2.7.2
SingleStore 7.3.11 server
  • MariaDB JDBC driver version 2.7.2
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
TIBCO Composite Server 8.4
  • Tibco Composite JDBC driver version 8.4.0
Mongo BI Connector Server 2.14.1
  • MySQL JDBC driver version 5.1.47
Mongo BI Connector Server 2.14.3
  • MySQL JDBC driver version 5.1.47
Vertica 10.1.0 server
  • Vertica JDBC Driver 10.00.0100
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.14
IBM Db2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.4
IBM Db2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.6
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.28.11
  • IBM JCC JDBC driver version 4.29.24
IBM Db2 11.5.5 server
  • IBM JCC JDBC driver version 4.28.11
IBM Db2 11.5.6 server
  • IBM JCC JDBC driver version 4.29.24
Dremio 15.7
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
Dremio 16.0
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
Dremio 17.0.0
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
IBM Cloud SQL Query
  • IBM Cloud SQL JDBC driver 2.5.31
PostgreSQL Server 12.6
  • PostgreSQL JDBC driver version 42.2.18
PostgreSQL Server 12.7
  • PostgreSQL JDBC driver version 42.2.18
PostgreSQL Server 13.2
  • PostgreSQL JDBC driver version 42.2.18
PostgreSQL Server 13.3
  • PostgreSQL JDBC driver version 42.2.19
  • PostgreSQL JDBC driver version 42.2.20
  • PostgreSQL JDBC driver version 42.2.21
  • PostgreSQL JDBC driver version 42.2.22
  • PostgreSQL JDBC driver version 42.2.23
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
MySQL 8.0.23 server
  • MySQL JDBC driver version 8.0.23
MySQL 8.0.24 server
  • MySQL JDBC driver version 8.0.24
MySQL 8.0.25 server
  • MySQL JDBC driver version 8.0.25
Oracle Server 19.10
  • Oracle JDBC Driver 19.10.0.0.0
Oracle Server 19.11
  • Oracle JDBC Driver 19.11.0.0.0
Oracle Server 21.1
  • Oracle JDBC Driver 21.1.0.0.0
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
SQL Server 2017 14.00.3391
  • Microsoft SQL Server JDBC driver version 9.2.0
SQL Server 2019 15.0.4073.23
  • Microsoft SQL Server JDBC driver version 9.2.0
Informix V14.10.XC5 server
  • Informix JDBC driver version 4.50.JC4W1
Informix V14.10.XC6 server
  • Informix JDBC driver version 4.50.JC4W1
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
Sybase IQ Server 16.1 SP4
  • SAP JConnect JDBC driver version 16.1.3
IBM Performance server/Netezza 11.2.0.0 server
  • Netezza nzjdbc 11.2.0.0
  • Netezza nzjdbc 11.0.7.0
  • Netezza nzjdbc 11.0.7.1
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client

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
  • JDBC driver 1.2.4.1007
  • JDBC driver 1.2.11.1014
  • JDBC driver 1.2.11.1015
Amazon Athena
  • JDBC driver 2.0.13
  • JDBC driver 2.0.14
  • JDBC driver 2.0.15
  • JDBC driver 2.0.16
Snowflake
  • JDBC driver 3.12.4
  • JDBC driver 3.12.5
  • JDBC driver 3.12.6
  • JDBC driver 3.12.7
  • JDBC driver 3.12.8
  • JDBC driver 3.12.9
  • JDBC driver 3.12.10
  • JDBC driver 3.12.11
  • JDBC driver 3.12.12
  • JDBC driver 3.12.13
  • JDBC driver 3.12.14
  • JDBC driver 3.12.15
  • JDBC driver 3.12.16
Amazon Redshift
  • JDBC Driver 1.2.41.1065
  • JDBC Driver 1.2.45.1069
  • JDBC Driver 1.2.47.1071
  • JDBC Driver 1.2.50.1077
  • JDBC Driver 1.2.51.1078
Denodo 8 server
  • JDBC driver version 8.0
Exasol 6.2.7 server
  • Exasol JDBC driver version 6.2.3
  • Exasol JDBC driver version 6.2.5
Exasol 7.0.4 server
  • Exasol JDBC driver version 7.0.4
Exasol 7.0.6 server
  • Exasol JDBC driver version 7.0.4
Presto Server 333
  • Presto JDBC Driver 333
Presto Server 334
  • Presto JDBC Driver 334
Presto Server 335
  • Presto JDBC Driver 335
Presto Server 336
  • Presto JDBC Driver 336
Presto Server 337
  • Presto JDBC Driver 337
Presto Server 338
  • Presto JDBC Driver 338
Presto Server 339
  • Presto JDBC Driver 339
Presto Server 340
  • Presto JDBC Driver 340
Presto Server 341
  • Presto JDBC Driver 341
Presto Server 342
  • Presto JDBC Driver 342
Presto Server 343
  • Presto JDBC Driver 343
Presto Server 344
  • Presto JDBC Driver 344
Presto Server 345
  • Presto JDBC Driver 345
Presto Server 346
  • Presto JDBC Driver 346
Presto Server 347
  • Presto JDBC Driver 347
Presto Server 348
  • Presto JDBC Driver 347
Presto Server 350
  • Presto JDBC Driver 347
Greenplum 6.8.1 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
Greenplum 6.10.1 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
Greenplum 6.12.0 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
Greenplum 6.13.0 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
Apache Hive Server 3.1
  • Hive JDBC Driver 3.1.0.3.1.5.0-152
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.17.1020
BigSQL 7.0.0 server
  • IBM JCC JDBC driver version 4.27.25
BigSQL 7.1.0 server
  • IBM JCC JDBC driver version 4.27.25
BigSQL 7.1.0 server
  • IBM JCC JDBC driver version 4.28.11
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 8.4.1
Azure SQL 12.00.2000
  • Microsoft SQL Server JDBC driver version 8.4.1
MariaDB 10.5.4 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
MariaDB 10.5.5 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
MariaDB 10.5.6 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • MariaDB JDBC driver version 2.7.1
MemSQL 7.1.7 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
MemSQL 7.1.11 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • MariaDB JDBC driver version 2.7.1
SAP HANA 2.00.050.00 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
TIBCO Composite Server 8.3
  • Tibco Composite JDBC driver version 8.3.0
Mongo BI Connector Server 2.14.0
  • MySQL JDBC driver version 5.1.47
Vertica 10.0 server
  • Vertica JDBC Driver 10.0.0
Vertica 10.0 server
  • Vertica JDBC Driver 10.00.0100
Teradata 17.0 server
  • Teradata JDBC driver version 17.00.00.02
Teradata 17.0 server
  • Teradata JDBC driver version 17.00.00.02
Teradata 17.0 server
  • Teradata JDBC driver version 17.00.00.02
Teradata 17.0 server
  • Teradata JDBC driver version 17.00.00.03
Teradata 17.05.02.01 server
  • Teradata JDBC driver version 17.00.00.03
IBM Db2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.4
IBM Db2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.6
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.28.11
IBM Db2 11.5.4 server
  • IBM JCC JDBC driver version 4.27.25
IBM Db2 11.5.4 server
  • IBM JCC JDBC driver version 4.28.11
IBM Db2 11.5.5 server
  • IBM JCC JDBC driver version 4.28.11
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.10
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.11
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.12
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.13
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.14
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.15
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.16
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.10
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.11
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.12
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.13
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.14
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.15
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.16
PostgreSQL Server 12.3
  • PostgreSQL JDBC driver version 42.2.10
  • PostgreSQL JDBC driver version 42.2.11
  • PostgreSQL JDBC driver version 42.2.12
  • PostgreSQL JDBC driver version 42.2.13
  • PostgreSQL JDBC driver version 42.2.14
  • PostgreSQL JDBC driver version 42.2.15
  • PostgreSQL JDBC driver version 42.2.16
PostgreSQL Server 12.4
  • PostgreSQL JDBC driver version 42.2.16
  • PostgreSQL JDBC driver version 42.2.17
  • PostgreSQL JDBC driver version 42.2.18
PostgreSQL Server 13.0
  • PostgreSQL JDBC driver version 42.2.16
  • PostgreSQL JDBC driver version 42.2.17
  • PostgreSQL JDBC driver version 42.2.18
PostgreSQL Server 13.1
  • PostgreSQL JDBC driver version 42.2.16
PostgreSQL Server 13.1
  • PostgreSQL JDBC driver version 42.2.17
PostgreSQL Server 13.1
  • PostgreSQL JDBC driver version 42.2.18
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.003967
MySQL 8.0.20 server
  • MySQL JDBC driver version 8.0.20
MySQL 8.0.21 server
  • MySQL JDBC driver version 8.0.21
MySQL 8.0.22 server
  • MySQL JDBC driver version 8.0.22
Oracle Server 18.10
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
Oracle Server 19.7
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
Oracle Server 19.8
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
Oracle Server 19.8
  • Oracle JDBC Driver 19.8.0.0.0
SQL Server 2017 CU20
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Microsoft SQL Server JDBC driver version 8.4.0
SQL Server 2017 CU21
  • Microsoft SQL Server JDBC driver version 8.4.0
  • Microsoft SQL Server JDBC driver version 8.4.1
SQL Server 2019 CU5
  • Microsoft SQL Server JDBC driver version 8.4.1
SQL Server 2019 CU6
  • Microsoft SQL Server JDBC driver version 8.4.0
  • Microsoft SQL Server JDBC driver version 8.4.1
SQL Server 2019 CU8
  • Microsoft SQL Server JDBC driver version 8.4.1
Informix V14.10.XC4 server
  • Informix JDBC driver version 4.50.JC4W1
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
IBM Performance server/Netezza 11.1.1.0 server
  • Netezza nzjdbc 11.0.6.1
IBM Performance server/Netezza 11.1.1.0 server
  • Netezza nzjdbc 11.1.1.0
 

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
  • No driver needed
IBM Planning Analytics 2.0.9.3 Server
  • No driver needed
IBM Planning Analytics 2.0.9.4 Server
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
SAP BW 7.5 server
  • SAP 7.5 client (build 753, patch 225, changelist 1868726)
MS Analysis Services 2017 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2017 server
  • XML/A, no driver needed.
MS Analysis Services 2019 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 server
  • XML/A, no driver needed.
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client

[{"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"}]

Document Information

Modified date:
30 January 2024

UID

ibm16441017