IBM Support

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

Content

 

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

Relational Data Sources
The following client driver versions were tested using DQM with Cognos Analytics 12.2.0:
Database Versions
JDBC Driver Versions
Amazon Athena
  • JDBC Driver 3.7.0
Amazon Athena
  • JDBC Driver 3.8.0
Amazon Redshift
  • JDBC Driver 2.2.7
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
Azure Fabric
  • Microsoft SQL Server JDBC driver version 12.10 (JRE 11)
Azure Synapse
  • Microsoft SQL Server JDBC driver version 12.10 (JRE 11)
Azure SQL
  • Microsoft SQL Server JDBC driver version 12.10 (JRE 11)
BigSQL 7.1.0.9 server
  • IBM JCC JDBC driver version 4.38.7
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.39
Cloudera Impala 4.0 server
  • Cloudera JDBC driver version 2.6.39
CDATA Connect Cloud
  • CDATA JDBC driver version 24.0.9175
Databricks
  • Databricks JDBC driver version 3.4.2
IBM Data Virtualization
  • IBM JCC JDBC driver version 4.35.11
IBM DB2 11.5.9 server
  • IBM JCC JDBC driver version 4.38.7
IBM DB2 12.1.4 server
  • IBM JCC JDBC driver version 4.38.7
IBM DB2 12.1.5 server
  • IBM JCC JDBC driver version 4.38.7
Db2 for IBM i server 7.5
  • JTOpen JDBC Driver 21.0.7 (JRE 11)
Db2 for IBM i server 7.6
  • JTOpen JDBC Driver 21.0.7 (JRE 11)
DB2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.38.7
DB2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.38.7
Denodo 8.0 server
  • JDBC driver version 9.3.1
Denodo 9.3 server
  • JDBC driver version 9.3.1
Dremio 25.2.19
  • Dremio JDBC Driver 26.0.5
Exasol 8.33 server
  • Exasol JDBC driver version 25.2.4
Google BigQuery
  • JDBC driver 1.7.0.1001
IBM Netezza Performance server 11.2.0.0
  • Netezza nzjdbc 11.2.2.11
Informix V14.10.FC13 server
  • Informix JDBC driver version 15.0.1.3
Informix V15.0.1.0 server
  • Informix JDBC driver version 15.0.1.3
MariaDB 11.8.7 server
  • MariaDB JDBC driver version 3.5.9
MariaDB 12.0.2 server
  • MariaDB JDBC driver version 3.5.9
MariaDB 12.3.2 server
  • MariaDB JDBC driver version 3.5.9
MongoDB Atlas SQL
  • MongoDB JDBC Driver version 3.0.8
MySQL 8.4.11 server
  • MySQL JDBC driver version 9.7.0
MySQL 9.7.2 server
  • MySQL JDBC driver version 9.7.0
Oracle Server 19.32
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
Oracle Server 19.31
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
Oracle Server 21.23
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
Oracle Server 21.22
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
Oracle Server 23.26.1.0.0
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
Oracle Server 23.9
  • Oracle JDBC Driver 23.26.3.0.0 (ojdbc17)
VMware Tanzu Greenplum 6.29.0 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
VMware Tanzu Greenplum 7.4.1 server
  • VMware Tanzu Greenplum JDBC Driver 6.0.0.000109
PostgreSQL Server 17.10
  • PostgreSQL JDBC driver version 42.7.12
PostgreSQL Server 18.0
  • PostgreSQL JDBC driver version 42.7.12
PostgreSQL Server 18.4
  • PostgreSQL JDBC driver version 42.7.12
Progress DataDirect Autonomous REST
  • Progress DataDirect Autonomus REST JDBC driver 6.0.1.006190
SAP HANA 2.0 SP07 server
  • SAP Hana JDBC driver version 2.28.8
SAP HANA 2.0 SP08 server
  • SAP Hana JDBC driver version 2.28.8
SingleStore 8.7.43 server
  • SingleStore JDBC driver version 1.2.7
SingleStore 8.9.47 server
  • SingleStore JDBC driver version 1.2.7
SingleStore 8.9.52 server
  • SingleStore JDBC driver version 1.2.7
SingleStore 9.0.10 server
  • SingleStore JDBC driver version 1.2.7
SingleStore 9.0.27 server
  • SingleStore JDBC driver version 1.2.7
Snowflake
  • JDBC driver 4.3.1
SQL Server 2019 CU31
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
SQL Server 2019 CU32
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
SQL Server 2022 CU21
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
SQL Server 2022 CU22
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
SQL Server 2022 CU23
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
SQL Server 2022 CU24
  • Microsoft SQL Server JDBC driver version 13.4.0 (JRE 11)
Sybase IQ Server 16.1 SP5 PL14
  • SAP JConnect JDBC driver version 20.0.0
Sybase IQ Server 16.1 SP5 PL15
  • SAP JConnect JDBC driver version 20.0.0
Teradata 17.20.03.39 server
  • Teradata JDBC driver version 20.00.00.58
Teradata 20.00 server
  • Teradata JDBC driver version 20.00.00.58
Trino Server 478
  • Trino JDBC Driver 481
Trino Server 479
  • Trino JDBC Driver 481
Trino Server 481
  • Trino JDBC Driver 481
Trino Server 482
  • Trino JDBC Driver 481
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
Vertica 25.1 server
  • Vertica JDBC Driver 24.4
  • Vertica JDBC Driver 25.3
watsonx.data server
  • Presto JDBC Driver 0.295
 

OLAP Data sources
 

The following OLAP driver versions were tested using DQM with Cognos Analytics 12.2.0:

Database type
Dynamic Query versions
IBM Planning Analytics as a Service 12.4.7 Server
  • No driver needed
IBM Planning Analytics 2.1.12 Server
  • No driver needed
IBM Planning Analytics 2.0.920 Server
  • No driver needed
IBM Cognos PowerCube
  • No driver needed
  • Dashboards only
Azure Analysis Services server
  • MS OLEDB driver for Windows 16.0.127.28
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU31 server
  • MS OLEDB driver for Windows 17.0.9.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU32 server
  • MS OLEDB driver for Windows 17.0.12.18
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU32 server
  • MS OLEDB driver for Windows 17.0.21.18
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU18 server
  • MS OLEDB driver for Windows 17.0.9.20
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU19 server
  • MS OLEDB driver for Windows 17.0.12.18
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2022 CU20 server
  • MS OLEDB driver for Windows 17.0.21.18
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
MS Analysis Services 2019 CU31 server
  • XML/A, no driver needed
MS Analysis Services 2019 CU32 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU18 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU19 server
  • XML/A, no driver needed
MS Analysis Services 2022 CU20 server
  • XML/A, no driver needed
SAP BW 7.5 SP31 server
  • SAP 7.5 client (PL15)
SAP BW/4Hana server
  • SAPJCo 3.1.12 (SAP Java connector)
 
 

[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEP7J","label":"IBM Cognos Analytics"},"ARM Category":[{"code":"a8m50000000Cl6sAAC","label":"Install-\u003EConfigure"}],"Platform":[{"code":"PF033","label":"Windows"}],"Version":"and future releases;12.2.0"}]

Document Information

Modified date:
04 November 2026

UID

ibm17290477

Page Feedback