IBM Support

DQM testing of vendor-supported client driver versions for each Cognos Analytics 12.0.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 12.0.x release.

Content

 

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
  • JDBC driver 2.0.28.1004
Amazon Redshift
  • JDBC Driver 2.1.0.20
  • JDBC Driver 2.1.0.21
  • JDBC Driver 2.1.0.22
  • JDBC Driver 2.1.0.23
  • JDBC Driver 2.1.0.24
  • JDBC Driver 2.1.0.25
  • JDBC Driver 2.1.0.26
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.6.0
Azure SQL
  • Microsoft SQL Server JDBC driver version 12.6.0
BigSQL 7.1.0 server
  • IBM JCC JDBC driver version 4.32.45
  • IBM JCC JDBC driver version 4.33.31
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.33.1062
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.33.1062
CDATA Connect Cloud
  • CDATA JDBC driver version 23.0.8669
  • CDATA JDBC driver version 23.0.8770
Databricks
  • Databricks JDBC driver version 2.6.34
IBM Db2 11.5.8 server
  • IBM JCC JDBC driver version 4.32.45
  • IBM JCC JDBC driver version 4.33.31
IBM Db2 11.5.9 server
  • IBM JCC JDBC driver version 4.32.45
  • IBM JCC JDBC driver version 4.33.31
Db2 for IBM i server 7.4
  • JTOpen JDBC Driver 20.0.1
  • JTOpen JDBC Driver 20.0.2
  • JTOpen JDBC Driver 20.0.3
  • JTOpen JDBC Driver 20.0.6
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 20.0.0
  • JTOpen JDBC Driver 20.0.2
  • JTOpen JDBC Driver 20.0.3
  • JTOpen JDBC Driver 20.0.6
Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.32.45
  • IBM JCC JDBC driver version 4.33.31
Db2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.32.45
  • IBM JCC JDBC driver version 4.33.31
Denodo 7.0.20230621 server
  • JDBC driver version 7.0.20200310
Denodo 8.0.20230914 server
  • JDBC driver version 8.0.20230914
Denodo 8.0.20230130 server
  • JDBC driver version 8.0.20230914
Dremio 24.2.5
  • Dremio JDBC Driver 24.2.5
Dremio 24.3.1
  • Dremio JDBC Driver 24.2.6
  • Dremio JDBC Driver 24.3.0
  • Dremio JDBC Driver 24.3.2
Dremio 24.3.3
  • Dremio JDBC Driver 24.3.2
Exasol 7.1.19 server
  • Exasol JDBC driver version 7.1.20
Exasol 8.24 server
  • Exasol JDBC driver version 7.1.20
Google BigQuery
  • JDBC driver 1.5.2
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.29
  • IBM Cloud Data Engine JDBC driver 2.7.30
  • IBM Cloud Data Engine JDBC driver 2.7.33
IBM Netezza Performance server 11.2.0.0
  • 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.5 server
  • MariaDB JDBC driver version 3.3.1
  • MariaDB JDBC driver version 3.3.2
MariaDB 10.11.6 server
  • MariaDB JDBC driver version 3.3.1
  • MariaDB JDBC driver version 3.3.2
MySQL 8.0.3 server
  • MySQL JDBC driver version 8.1
  • MySQL JDBC driver version 8.2
  • MySQL JDBC driver version 8.3
MySQL 8.1 server
  • MySQL JDBC driver version 8.1
  • MySQL JDBC driver version 8.2
  • MySQL JDBC driver version 8.3
Oracle Server 19.21
  • Oracle JDBC Driver 19.21
Oracle Server 21.10
  • Oracle JDBC Driver 21.10.0.0.0
Oracle Server 21.11
  • Oracle JDBC Driver 21.11.0.0.0
Oracle Server 23.3
  • Oracle JDBC Driver 23.3.0.23.09
VMware Tanzu Greenplum 6.25.2 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
VMware Tanzu Greenplum 7.0.0 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
PostgreSQL Server 15.5
  • PostgreSQL JDBC driver version 42.7.0
  • PostgreSQL JDBC driver version 42.7.1
PostgreSQL Server 16.1
  • PostgreSQL JDBC driver version 42.7.0
  • PostgreSQL JDBC driver version 42.7.1
  • PostgreSQL JDBC driver version 42.7.2
PostgreSQL Server 16.2
  • PostgreSQL JDBC driver version 42.7.2
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.006190
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.17.12
  • SAP Hana JDBC driver version 2.18.11
  • SAP Hana JDBC driver version 2.18.13
  • SAP Hana JDBC driver version 2.18.16
  • SAP Hana JDBC driver version 2.19.11
  • SAP Hana JDBC driver version 2.19.15
  • SAP Hana JDBC driver version 2.19.16
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.17.12
  • SAP Hana JDBC driver version 2.18.11
  • SAP Hana JDBC driver version 2.18.13
  • SAP Hana JDBC driver version 2.18.16
  • SAP Hana JDBC driver version 2.19.11
  • SAP Hana JDBC driver version 2.19.15
  • SAP Hana JDBC driver version 2.19.16
SingleStore 8.1.27 server
  • SingleStore JDBC driver version 1.2.1
SingleStore 8.5.1 server
  • SingleStore JDBC driver version 1.2.1
Snowflake
  • JDBC driver 3.14.3
  • JDBC driver 3.14.4
  • JDBC driver 3.14.5
SQL Server 2019 CU23
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2019 CU24
  • Microsoft SQL Server JDBC driver version 12.4.1
  • Microsoft SQL Server JDBC driver version 12.6.0
SQL Server 2022 CU9
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU10
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU11
  • Microsoft SQL Server JDBC driver version 12.4.1
  • Microsoft SQL Server JDBC driver version 12.6.0
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.13
  • Teradata JDBC driver version 20.00.00.15
  • Teradata JDBC driver version 20.00.00.16
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.13
  • Teradata JDBC driver version 20.00.00.15
  • Teradata JDBC driver version 20.00.00.16
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 431
Trino Server 432
  • Trino JDBC Driver 432
Trino Server 433
  • Trino JDBC Driver 433
Trino Server 434
  • Trino JDBC Driver 434
Trino Server 435
  • Trino JDBC Driver 435
Trino Server 436
  • Trino JDBC Driver 436
Trino Server 437
  • Trino JDBC Driver 437
Trino Server 438
  • Trino JDBC Driver 438
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 12 server
  • Vertica JDBC Driver 23.4
  • Vertica JDBC Driver 24.1
Vertica 24 server
  • Vertica JDBC Driver 23.4
  • Vertica JDBC Driver 24.1
watsonx.data server
  • Presto JDBC Driver 0.284
  • Presto JDBC Driver 0.285
 
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.99.19
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.104.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.108.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.113.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
IBM Cognos Powercube
  • No driver needed
  • Dashboards only
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.99.19
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.104.21
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.108.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.113.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU23 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU1 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU2 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU3 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU4 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU5 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU6 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU7 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU8 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU9 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU10 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU11 server
  • MS OLEDB driver for Windows 16.0.121.23
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU23 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU8 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU9 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU10 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU11 server
  • XML/A, no driver needed
SAP BW 7.5 SP27 server
  • SAP 7.5 client (PL12)
SAP BW 7.5 SP28 server
  • SAP 7.5 client (PL12)

Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 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
  • JDBC driver 2.0.28.1004
Amazon Redshift
  • JDBC Driver 2.1.0.20
  • JDBC Driver 2.1.0.21
  • JDBC Driver 2.1.0.19
  • JDBC Driver 2.1.0.19
  • JDBC Driver 2.1.0.19
  • JDBC Driver 2.1.0.19
  • JDBC Driver 2.1.0.19
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.1.0 server
  • IBM JCC JDBC driver version 4.32.45
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.32.1041
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.32.1041
CDATA Connect Cloud
  • CDATA JDBC driver version 23.0.8565
Databricks
  • 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
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 20.0.0
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 7.0.20230621 server
  • JDBC driver version 7.0.20200310
Denodo 8.0.20230914 server
  • JDBC driver version 8.0.20230914
Dremio 24.2
  • 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.5
IBM Cloud Data Engine
  • 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.8.3 server
  • MariaDB JDBC driver version 3.1.3
MariaDB 10.11.4 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.1
MySQL 8.1 server
  • MySQL JDBC driver version 8.1
Oracle Server 19.20
  • Oracle JDBC Driver 19.20
Oracle Server 21.10
  • Oracle JDBC Driver 21.10.0.0.0
Oracle Server 21.11
  • Oracle JDBC Driver 21.11.0.0.0
Oracle Server 23.3
  • Oracle JDBC Driver 23.3.0.23.09
VMware Tanzu Greenplum 6.25.2 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
VMware Tanzu Greenplum 7.0.0 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
PostgreSQL Server 15.4
  • PostgreSQL JDBC driver version 42.6
PostgreSQL Server 16.0
  • PostgreSQL JDBC driver version 42.6
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.005690
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.17.10
SingleStore 8.1.7 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.8 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.9 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.10server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.11 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.12 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.13 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.14 server
  • SingleStore JDBC driver version 1.1.6
SingleStore 8.1.15 server
  • SingleStore JDBC driver version 1.1.7
SingleStore 8.1.16 server
  • 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.17 server
  • 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.33
  • JDBC driver 3.14.0
  • JDBC driver 3.14.1
  • JDBC driver 3.14.2
SQL Server 2019 CU21
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU6
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU7
  • Microsoft SQL Server JDBC driver version 12.4.1
SQL Server 2022 CU8
  • Microsoft SQL Server JDBC driver version 12.4.1
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.11
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.11
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
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 12 server
  • Vertica JDBC Driver 23.3
Vertica 23 server
  • Vertica JDBC Driver 23.3
watsonx.data server
  • Presto JDBC Driver 0.283
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.90.22
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.95.22
  • 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 BW 7.5 SP26 server
  • SAP 7.5 client (PL12)
MS Analysis Services 2019 CU20 server
  • MS OLEDB driver for Windows 16.0.90.22
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU22 server
  • MS OLEDB driver for Windows 16.0.95.22
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU22 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU1 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU2 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU3 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU4 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU5 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU6 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU7 server
  • XML/A, no driver needed

Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.1

Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.0.1:
 
Database type
Dynamic Query versions
Amazon Athena
  • JDBC driver 2.0.28
Amazon Redshift
  • JDBC Driver 2.1.0.13
  • JDBC Driver 2.1.0.14
  • JDBC Driver 2.1.0.15
  • JDBC Driver 2.1.0.16
  • JDBC Driver 2.1.0.17
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
  • IBM JCC JDBC driver version 4.32.45
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.32.1041
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.32.1041
CDATA Connect Cloud
  • CDATA JDBC driver version 22.0.8462
  • CDATA JDBC driver version 23.0.8565
Databricks
  • Databricks JDBC driver version 2.6.33
IBM Db2 11.5.8 server
  • IBM JCC JDBC driver version 4.32.28
  • IBM JCC JDBC driver version 4.32.45
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
  • IBM JCC JDBC driver version 4.32.45
Db2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.32.28
  • IBM JCC JDBC driver version 4.32.45
Denodo 8.0.20230712 server
  • JDBC driver version 8.0.20230301
Dremio 24.0.1
  • Dremio JDBC Driver 24.1
Dremio 24.1.1
  • Dremio JDBC Driver 24.1
Exasol 7.1.19 server
  • Exasol JDBC driver version 7.1.19
  • Exasol JDBC driver version 7.1.20
Google BigQuery
  • JDBC driver 1.3.2.1003
  • JDBC driver 1.3.3.1004
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.5
  • IBM Cloud Data Engine JDBC driver 2.7.7
  • IBM Cloud Data Engine JDBC driver 2.7.20
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.10
Informix V14.10.XC10 server
  • Informix JDBC driver version 4.50.10
MariaDB 10.8.3 server
  • MariaDB JDBC driver version 3.1.3
MariaDB 10.11.3 server
  • MariaDB JDBC driver version 3.1.4
MariaDB 10.11.4 server
  • MariaDB JDBC driver version 3.1.4
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
MySQL 8.0.32 server
  • MySQL JDBC driver version 8.0.33
MySQL 8.0.33 server
  • MySQL JDBC driver version 8.0.33
Oracle Server 19.19
  • Oracle JDBC Driver 19.19
Oracle Server 21.9
  • Oracle JDBC Driver 23.2.0.0.0
VMware Tanzu Greenplum 6.25.1 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
PostgreSQL Server 14.5
  • PostgreSQL JDBC driver version 42.6
PostgreSQL Server 15.3
  • PostgreSQL JDBC driver version 42.6
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.005690
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.16.10
  • SAP Hana JDBC driver version 2.16.11
SingleStore 8.06 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.07 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.08 server
  • SingleStore JDBC driver version 1.1.5
SingleStore 8.09 server
  • SingleStore JDBC driver version 1.1.5
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
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
Snowflake
  • JDBC driver 3.13.27
  • JDBC driver 3.13.28
  • JDBC driver 3.13.30
  • JDBC driver 3.13.31
  • JDBC driver 3.13.32
SQL Server 2019 CU20
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2019 CU21
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU2
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU3
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU4
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022 CU5
  • Microsoft 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.06
  • Teradata JDBC driver version 20.00.00.10
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.06
  • Teradata JDBC driver version 20.00.00.10
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
Trino Server 418
  • Trino JDBC Driver 418
Trino Server 419
  • Trino JDBC Driver 419
Trino Server 420
  • Trino JDBC Driver 420
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 12.0.4 server
  • Vertica JDBC Driver 12.0.4
watsonx.data server
  • Presto JDBC Driver 0.282
 

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
  • No driver needed
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.82.16
  • 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)
SAP BW 7.5 SP26 server
  • SAP 7.5 client (PL08)
MS Analysis Services 2019 CU20 server
  • MS OLEDB driver for Windows 16.0.82.16
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • XML/A, no driver needed.
MS Analysis Services 2022 CU1 server
  • XML/A, no driver needed.

Vendor-supported client driver versions that were tested using DQM with Cognos Analytics on Premises 12.0.0

Relational Data Sources
The following  driver versions were tested using DQM with Cognos Analytics 12.0.0:
 
Database type
Dynamic Query versions
Amazon Athena
  • JDBC driver 2.0.28
Amazon Redshift
  • JDBC Driver 2.1.0.10
  • JDBC Driver 2.1.0.12
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 11.2.1
Azure SQL
  • Microsoft SQL Server JDBC driver version 11.2.1
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.32.28
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.29.1035
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.30.1036
CDATA Connect Cloud
  • CDATA JDBC driver version 22.0.8327
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.1
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 11.1
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 22.1.5
  • Dremio JDBC Driver 22.0.0
Dremio 23.0.1
  • Dremio JDBC Driver 23.0.1
Dremio 24.0.0
  • Dremio JDBC Driver 24.0.0
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
Google BigQuery
  • JDBC driver 1.3.0.1001
IBM Cloud Data Engine
  • IBM Cloud Data Engine JDBC driver 2.7.3
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.XC9 server
  • Informix JDBC driver version 4.50.JC7
MariaDB 10.7.4 server
  • MariaDB JDBC driver version 3.0.8
  • MariaDB JDBC driver version 3.0.9
  • MariaDB JDBC driver version 3.1.2
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
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
MySQL 8.0.31 server
  • MySQL JDBC driver version 8.0.31
MySQL 8.0.32 server
  • MySQL JDBC driver version 8.0.32
Oracle Server 19.17
  • Oracle JDBC Driver 19.16
  • Oracle JDBC Driver 19.17.0.0
Oracle Server 19.18
  • Oracle JDBC Driver 19.18.0.0
Oracle Server 21.8
  • Oracle JDBC Driver 21.8.0.0
Oracle Server 21.9
  • Oracle JDBC Driver 21.9.0.0
VMware Tanzu Greenplum 6.22 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
PostgreSQL Server 14.5
  • PostgreSQL JDBC driver version 42.4.2
PostgreSQL Server 15.0
  • PostgreSQL JDBC driver version 42.4.2
PostgreSQL Server 15.1
  • PostgreSQL JDBC driver version 42.4.2
PostgreSQL Server 15.2
  • PostgreSQL JDBC driver version 42.5.1
  • PostgreSQL JDBC driver version 42.5.2
  • PostgreSQL JDBC driver version 42.5.3
  • PostgreSQL JDBC driver version 42.5.4
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.1.005690
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
  • SAP Hana JDBC driver version 2.15.12
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
Snowflake
  • JDBC driver 3.13.23
  • JDBC driver 3.13.24
  • JDBC driver 3.13.25
  • JDBC driver 3.13.26
  • JDBC driver 3.13.29
SQL Server 2019 CU19
  • Microsoft SQL Server JDBC driver version 11.2.1
  • Microsoft SQL Server JDBC driver version 11.2.3
  • Microsoft SQL Server JDBC driver version 12.2
SQL Server 2022
  • Microsoft SQL Server JDBC driver version 11.2.1
SQL Server 2022 CU1
  • Microsoft SQL Server JDBC driver version 11.2.3
  • Microsoft SQL Server JDBC driver version 12.2
Sybase ASE Server 16 SP4
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PLO7
  • SAP JConnect JDBC driver version 20.0.0
Teradata 17.10 server
  • Teradata JDBC driver version 20.00.00.06
  • Teradata JDBC driver version 20.00.00.10
Teradata 17.20 server
  • Teradata JDBC driver version 20.00.00.10
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
Trino Server 407
  • Trino JDBC Driver 407
Trino Server 408
  • Trino JDBC Driver 408
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
 

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
  • 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
    • 16.0.70.21
  • 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 CU19 server
  • MS OLEDB driver for Windows
    • 16.0.70.21
  • XML/A, no driver needed.

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

Document Information

Modified date:
25 April 2024

UID

ibm16989513

Page Feedback