IBM Support

Vendor-supported client driver versions that were tested for each Cognos Analytics 11.1.x release

Detailed System Requirements


Abstract

This document lists the vendor-supported client driver versions that were tested for each Cognos Analytics 11.1.x release.

NOTE: See the vendor documentation regarding their statement of forward and backward compatibility of client and server versions.

Content

Vendor-supported client driver versions that were tested with Cognos Analytics on Premises 11.1.7 Fix Pack 6

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7 FP6:
 
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
  • JDBC driver 1.2.22.1026
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.28
  • Not applicable
Amazon Redshift
  • Amazon Redshift JDBC Driver 2.1.0.3
  • Not applicable
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
  • Not applicable
Snowflake
  • JDBC driver 3.13.14
  • Not applicable
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
  • JDBC Driver 2.1.0.3
  • Not applicable
Denodo 8.0.20220815 server
  • JDBC driver version 8.0 20220815
  • Not applicable
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.1.1
  • Not applicable
Trino Server 375
  • Trino JDBC Driver 365
  • Not applicable
Trino Server 376
  • Trino JDBC Driver 376
  • Not applicable
Trino Server 377
  • Trino JDBC Driver 377
  • Not applicable
Trino Server 378
  • Trino JDBC Driver 378
  • Not applicable
Trino Server 379
  • Trino JDBC Driver 379
  • Not applicable
Trino Server 380
  • Trino JDBC Driver 380
  • Not applicable
Trino Server 381
  • Trino JDBC Driver 381
  • Not applicable
Trino Server 382
  • Trino JDBC Driver 382
  • Not applicable
Trino Server 383
  • Trino JDBC Driver 383
  • Not applicable
Trino Server 384
  • Trino JDBC Driver 384
  • Not applicable
Trino Server 385
  • Trino JDBC Driver 385
  • Not applicable
Trino Server 386
  • Trino JDBC Driver 386
  • Not applicable
Trino Server 387
  • Trino JDBC Driver 387
  • Not applicable
Trino Server 388
  • Trino JDBC Driver 388
  • Not applicable
Trino Server 389
  • Trino JDBC Driver 389
  • Not applicable
Trino Server 390
  • Trino JDBC Driver 390
  • Not applicable
Trino Server 391
  • Trino JDBC Driver 391
  • Not applicable
VMware Tanzu Greenplum 6.21 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
  • Not applicable
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
  • Not applicable
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.27.1032
  • Not applicable
BigSQL 7.10 server
  • IBM JCC JDBC driver version 4.31.10
  • Not applicable
Azure Synapse Datawarehouse
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Not applicable
Azure SQL
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Not applicable
MariaDB 10.7.3 server
  • MariaDB JDBC driver version 2.7.5
  • Not applicable
SingleStore 7.8.2 server
  • MariaDB JDBC driver version 2.7.5
  • Not applicable
SingleStore 7.8.3 server
  • MariaDB JDBC driver version 2.7.5
  • Not applicable
SingleStore 7.8.4 server
  • MariaDB JDBC driver version 2.7.5
  • Not applicable
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.10.10
  • SAP Hana JDBC driver version 2.12.7
  • Not applicable
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
  • Not applicable
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 11.1.1-3 server
  • Vertica JDBC Driver 11.1.0
  • Windows ODBC Driver Version11.00.0200
  • Linux-x86- ODBC Driver Version 9.2.1
Vertica 12.0 server
  • Vertica JDBC Driver 11.1.0
  • Windows ODBC Driver Version11.00.0200
  • Linux-x86- ODBC Driver Version 9.2.1
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.27
  • Windows Teradata ODBC Driver Version 17.20.00.002
  • Linux-x86-Teradata ODBC Driver Version 17.20.00.003
IBM Db2 iSeries Server 7.4
IBM Db2 iSeries Server 7.5
  • JTOpen JDBC Driver 10.7
  • Windows IBM Data Server Client 11.05.07
  • Linux-x86 - IBM Data Server Client 11.05.04
  • Windows - DB2 iSeries ODBC Driver 07.01.026
  • Linux-x86 - DB2 iSeries ODBC Driver: 07.01.025
IBM Db2 Z Server 12.1.5
IBM Db2 Z Server 13.1.5
  • IBM JCC JDBC driver version 4.31.10
  • Windows - IBM Data Server Client 11.05.07
  • Linux-x86- IBM Data Server Client 11.05.04
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.31.10
  • Windows DB2 Data Server Client 11.05.07
  • Linux-x86-DB2 Data Server Client 11.05.04
Dremio 21.1.1
Dremio 21.1.2
Dremio 21.2.0
  • Dremio JDBC Driver 20.1.0-202202061055110045-36733c65
  • Not applicable
PostgreSQL Server 14.0
  • PostgreSQL JDBC driver version 42.2.24
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.02.0000
PostgreSQL Server 14.2
  • PostgreSQL JDBC driver version 42.3.3
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.02.000
PostgreSQL Server 14.3
  • PostgreSQL JDBC driver version 42.3.3
  • Windows ODBC driver 13.02.000
  • Linux-x86-ODBC driver 13.02.000
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
  • Not applicable
MySQL 8.0.28 server
  • MySQL JDBC driver version 8.0.28
  • Windows-MySQL Connector/ODBC 8.00.0030
  • Linux-x86-MySQL Connector/ODBC 8.00.0028
Oracle Server 21.5
  • Oracle JDBC Driver 21.5.0.0.0
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
  • Windows-Netezza ODBC Driver 11.2.1.4
  • Linux-x86-Netezza ODBC Driver 7.2.1.11
SQL Server 2019 CU15
  • Microsoft SQL Server JDBC driver version 10.2.0
  • OLE DB Driver 19 for SQL Server (MSOLEDBSQL19.DLL)
  • ODBC Driver 18 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux-x86-DataDirect ODBC Driver 8.0.2
Informix V14.10.XC7 server
  • Informix JDBC driver version 4.50.JC7
  • Windows-Informix Client Software Development Kit 4.10 TC15
  • Linux-x86-Informix Client Software Development Kit 4.10 UC15
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 20.0.0
  • Windows-SAP Client-Library/20.0
  • Linux-x86-SAP Client-Library/20.0
Sybase IQ Server 16.1 SP5
  • SAP JConnect JDBC driver version 20.0.0.0
  • Windows-SAP Sybase IQ 16.1SP05 - 16.00.2195
  • Linux-x86-SAP Sybase IQ 16.0SP11 - 16.00.2014
IBM Netezza Performance server 11.2.0.0 server
  • Netezza nzjdbc 11.2.2.0
  • Windows- Netezza ODBC Driver 11.2.1.4
 

OLAP Data sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7 FP6:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9.14 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 16.0.20.201 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • Not Applicable
IBM Cognos PowerCube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 16.0.20.201 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
  • Not Applicable

Vendor-supported client driver versions that were tested with Cognos Analytics on Premises 11.1.7 Fix Pack 5

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7 FP5:
 
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
  • JDBC driver 1.2.21.1025
  • JDBC driver 1.2.22.1026
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.24
  • JDBC driver 2.0.25
  • JDBC driver 2.0.27
  • JDBC driver 2.0.28
  • Not applicable
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
  • JDBC driver 3.13.12
  • JDBC driver 3.13.13
  • JDBC driver 3.13.14
  • Not applicable
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
  • JDBC Driver 2.1.0.3
  • Not applicable
Denodo 8.0.20211129 server
  • JDBC driver version 8.0 20210209
  • Not applicable
Denodo 8.0.20220126 server
  • JDBC driver version 8.0 20210715
  • JDBC driver version 8.0 20220126
  • Not applicable
Exasol 7.1.3 server
  • Exasol JDBC driver version 7.1.0
  • Exasol JDBC driver version 7.1.1
  • Not applicable
Trino Server 363
  • Trino JDBC Driver 360
  • Trino JDBC Driver 361
  • Trino JDBC Driver 362
  • Trino JDBC Driver 363
  • Not applicable
Trino Server 364
  • Trino JDBC Driver 364
  • Not applicable
Trino Server 365
  • Trino JDBC Driver 365
  • Not applicable
Trino Server 366
  • Trino JDBC Driver 366
  • Not applicable
Trino Server 367
  • Trino JDBC Driver 367
  • Not applicable
Trino Server 368
  • Trino JDBC Driver 368
  • Not applicable
Trino Server 369
  • Trino JDBC Driver 369
  • Not applicable
Trino Server 370
  • Trino JDBC Driver 370
  • Not applicable
Trino Server 371
  • Trino JDBC Driver 371
  • Not applicable
Trino Server 372
  • Trino JDBC Driver 372
  • Not applicable
Trino Server 373
  • Trino JDBC Driver 373
  • Not applicable
Trino Server 374
  • Trino JDBC Driver 374
  • Not applicable
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
  • Not applicable
Apache Hive Server 3.1.3000.7.1.7.0-551
  • Hive JDBC Driver 3.1.3000.7.1.7.0-551
  • Not applicable
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.24.1029
  • Cloudera JDBC driver version 2.6.26.1031
  • Cloudera JDBC driver version 2.6.27.1032
  • Not applicable
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.29.24
  • IBM JCC JDBC driver version 4.31.10
  • Not applicable
Azure Synapse Analytics
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Not applicable
Azure SQL
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Microsoft SQL Server JDBC driver version 10.2.0
  • Not applicable
MariaDB 10.6.7 server
  • MariaDB JDBC driver version 2.7.3
  • MariaDB JDBC driver version 2.7.4
  • MariaDB JDBC driver version 2.7.5
  • MariaDB JDBC driver version 3.0.3
  • Not applicable
MariaDB 10.7.3 server
  • MariaDB JDBC driver version 2.7.5
  • Not applicable
SingleStore 7.5.9 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.10 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.11 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.12 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.6.7 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.6.8 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.6.9 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.6.10 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
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
  • Not applicable
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
  • Not applicable
SAP HANA 2.0 SP06 server
  • SAP Hana JDBC driver version 2.10.10
  • SAP Hana JDBC driver version 2.12.7
  • Not applicable
TIBCO Composite Server 8.5
  • Tibco Composite JDBC driver version 8.5.0
  • Not applicable
Mongo BI Connector Server 2.14.4
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 11.0.0 server
  • Vertica JDBC Driver 11.0.0
  • Vertica JDBC Driver 11.1.0
  • Windows ODBC Driver Version11.02
  • Linux-x86- ODBC Driver Version 9.2
Vertica 11.0.2 server
  • Vertica JDBC Driver 11.1.0
  • Not applicable
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.20
  • Teradata JDBC driver version 17.10.00.22
  • Teradata JDBC driver version 17.10.00.23
  • 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
  • Windows Teradata ODBC Driver Version 17.10.17
  • Linux-x86-Teradata ODBC Driver Version 17.10
IBM Db2 iSeries Server 7.4
  • JTOpen JDBC Driver 10.7
  • Windows DB2 Data Server Client 11.05.07
  • Linux-x86 - DB2 Data Server Client 11.05.04
  • Windows - DB2 iSeries ODBC Driver 07.01.025
  • Linux-x86 - DB2 iSeries ODBC Driver: 07.01.025
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.29.24
  • IBM JCC JDBC driver version 4.31.10
  • Windows - DB2 Data Server Client 11.05.07
  • Linux-x86- DB2 Data Server Client 11.05.04
IBM Db2 11.5.7 server
  • IBM JCC JDBC driver version 4.29.24
  • IBM JCC JDBC driver version 4.31.10
  • Windows DB2 Data Server Client 11.05.07
  • Linux-x86-DB2 Data Server Client 11.05.04
Dremio 19.1.0
  • Dremio JDBC Driver 18.0.0-202109101536100970-a32fc9f4
  • Not applicable
Dremio 19.2.0
  • 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 JDBC Driver 20.1.0-202202061055110045-36733c65
  • Not applicable
Dremio 20.0
  • Dremio JDBC Driver 20.1.0-202202061055110045-36733c65
  • Not applicable
Dremio 20.1
  • Dremio JDBC Driver 20.1.0-202202061055110045-36733c65
  • Not applicable
PostgreSQL Server 14.0
  • PostgreSQL JDBC driver version 42.2.24
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.0000
PostgreSQL Server 14.1
  • PostgreSQL JDBC driver version 42.2.24
  • PostgreSQL JDBC driver version 42.3.0
  • PostgreSQL JDBC driver version 42.3.1
  • PostgreSQL JDBC driver version 42.3.2
  • Windows ODBC driver 13.02.0000
  • Linux-x86-ODBC driver 13.01.000
PostgreSQL Server 14.2
  • PostgreSQL JDBC driver version 42.3.3
  • Windows ODBC driver 13.02.000
  • Linux-x86-ODBC driver 13.01.000
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
  • Not applicable
MySQL 8.0.27 server
  • MySQL JDBC driver version 8.0.27
  • Windows-MySQL Connector/ODBC 8.00.0028
  • Linux-x86-MySQL Connector/ODBC 8.00.0027
MySQL 8.0.28 server
  • MySQL JDBC driver version 8.0.28
  • Windows-MySQL Connector/ODBC 8.00.0028
  • Linux-x86-MySQL Connector/ODBC 8.00.0028
Oracle Server 19.13
  • Oracle JDBC Driver 19.13.0.0.1
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Instant Client 19.12
Oracle Server 19.14
  • Oracle JDBC Driver 19.14.0.0.0
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Oracle Server 21.3
  • Oracle JDBC Driver 21.3.0.0.0
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Oracle Server 21.4
  • Oracle JDBC Driver 21.4.0.0.1
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Oracle Server 21.5
  • Oracle JDBC Driver 21.5.0.0.0
  • Windows-Oracle Database 21c Client (21.3) - 21.3.0.0.0
  • Linux-x86-Oracle Database 21c Client (21.3) - 21.3.0.0.0
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
  • Windows-Netezza ODBC Driver 11.2.1.4
  • Linux-x86-Netezza ODBC Driver 7.2.1.11
SQL Server 2017 CU28
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
SQL Server 2019 CU13
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
SQL Server 2019 CU14
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
SQL Server 2019 CU15
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Microsoft SQL Server JDBC driver version 10.2.0
  • OLE DB Driver 18 for SQL Server (MSOLEDBSQL.DLL 18.6.0000.0)
  • ODBC Driver 18 for SQL Server (MSODBCSQL18.DLL 18.00.0001)
  • Linux-x86-DataDirect ODBC Driver 8.0.2
Informix V14.10.XC7 server
  • Informix JDBC driver version 4.50.JC6
  • Informix JDBC driver version 4.50.JC7
  • Windows-Informix Client Software Development Kit 4.10 TC15
  • Linux-x86-Informix Client Software Development Kit 4.10 UC15
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 20.0.0
  • Windows-SAP Client-Library/20.0/P/PC
  • Linux-x86-SAP Client-Library/16.0 SP04
Sybase IQ Server 16.1 SP5
  • SAP JConnect JDBC driver version 20.0.0.0
  • Windows-SAP Sybase IQ 16.1SP04 - 16.00.2195
  • Linux-x86-SAP Sybase IQ 16.0SP11 - 16.00.2014
IBM Performance server/Netezza 11.2.0.0 server
  • Netezza nzjdbc 11.2.1.1
  • Netezza nzjdbc 11.2.2.0
  • Windows- Netezza ODBC Driver 11.2.1.4
 

OLAP Data sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7 FP5:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9.12 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 16.0.20.201 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 16.0.4.17 for Windows
  • MS OLEDB driver version 16.0.9.17 for Windows
  • 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
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
  • Not Applicable
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Vendor-supported client driver versions that were tested with Cognos Analytics on Premises 11.1.7 Fix Pack 4

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7 FP4:
 
 
Database type
Dynamic Query versions
Compatible 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
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.23
  • Not applicable
Snowflake
  • 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
  • Not applicable
Amazon Redshift
  • JDBC Driver 1.2.54.1082
  • JDBC Driver 1.2.55.1083
  • JDBC Driver 2.0.0.5
  • Not applicable
Denodo 8 server
  • JDBC driver version 8.0 20210209
  • Not applicable
Exasol 7.0.10 server
  • Exasol JDBC driver version 7.0.7
  • Exasol JDBC driver version 7.0.11
  • Not applicable
Trino Server 353
  • Trino JDBC Driver 351
  • Trino JDBC Driver 352
  • Trino JDBC Driver 353
  • Not applicable
Trino Server 354
  • Trino JDBC Driver 354
  • Not applicable
Trino Server 355
  • Trino JDBC Driver 355
  • Not applicable
Trino Server 356
  • Trino JDBC Driver 356
  • Not applicable
Trino Server 357
  • Trino JDBC Driver 357
  • Not applicable
Trino Server 358
  • Trino JDBC Driver 358
  • Not applicable
Trino Server 359
  • Trino JDBC Driver 359
  • Not applicable
Trino Server 360
  • Trino JDBC Driver 360
  • Not applicable
VMware Tanzu Greenplum 6.16.0 server
  • VMware Tanzu Greenplum JDBC Driver 5.1.4.000275
  • Not applicable
Apache Hive Server 3.1.3000.7.1.6.0-297
  • Hive JDBC Driver 3.1.3000.7.1.6.0-297
  • Not applicable
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
  • Not applicable
BigSQL 7.1 server
  • IBM JCC JDBC driver version 4.29.24
  • Not applicable
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
Azure SQL 12.00.2255
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
MariaDB 10.4.17 server
  • MariaDB JDBC driver version 2.7.2
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.4.18 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.5.8 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.5.9 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.5.10 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.6.0 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
MariaDB 10.6.3 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.6 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.9 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.10 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.11 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.12 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.3.13 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.6 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.7 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SingleStore 7.5.8 server
  • MariaDB JDBC driver version 2.7.3
  • Not applicable
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
  • Not applicable
TIBCO Composite Server 8.4
  • Tibco Composite JDBC driver version 8.4.0
  • Not applicable
Mongo BI Connector Server 2.14.3
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 11.0.0 server
  • Vertica JDBC Driver 10.00.0100
  • Windows ODBC Driver Version 10.01
  • Linux-x86- ODBC Driver Version 9.2.1
Teradata 17.10 server
  • Teradata JDBC driver version 17.10.00.14
  • Teradata JDBC driver version 17.10.00.17
  • Windows Teradata ODBC Driver Version 17.10.00.10
  • Linux-x86-Teradata ODBC Driver Version 17.10.00.10
IBM Db2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.6
  • Windows DB2 Data Server Client 11.05.0400
  • Linux-x86 - DB2 Data Server Client 11.05.0400
IBM Db2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.29.24
  • Windows - DB2 Data Server Client 11.05.0400
  • Linux-x86- DB2 Data Server Client 11.05.0400
IBM Db2 11.5.6 server
  • IBM JCC JDBC driver version 4.29.24
  • Windows DB2 Data Server Client 11.05.0400
  • Linux-x86-DB2 Data Server Client 11.05.0400
Dremio 17.0.0
  • Dremio JDBC Driver 17.0.0-202107060524010627-31b5222b
  • Not applicable
PostgreSQL Server 12.7
  • PostgreSQL JDBC driver version 42.2.23
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.02.000
PostgreSQL Server 12.8
  • PostgreSQL JDBC driver version 42.2.23
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.02.000
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
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.02.000
PostgreSQL Server 13.4
  • PostgreSQL JDBC driver version 42.2.23
  • Windows ODBC driver 13.01.000
  • Linux-x86-ODBC driver 13.02.000
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.004291
  • Not applicable
MySQL 8.0.24 server
  • MySQL JDBC driver version 8.0.24
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.24
MySQL 8.0.25 server
  • MySQL JDBC driver version 8.0.25
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.25
MySQL 8.0.26 server
  • MySQL JDBC driver version 8.0.26
  • Windows-MySQL Connector/ODBC 8.0.26
  • Linux-x86-MySQL Connector/ODBC 8.0.26
Oracle Server 19.10
  • Oracle JDBC Driver 19.10.0.0.0
  • Windows-Oracle Client Version 19.3.0
  • Linux-x86-Oracle Client Version 19.3.0
Oracle Server 19.11
  • Oracle JDBC Driver 19.11.0.0.0
  • Windows-Oracle Client Version 19.3.0
  • Linux-x86-Oracle Client Version 19.3.0.0
Oracle Server 19.12
  • Oracle JDBC Driver 19.12.0.0.0
  • Windows-Oracle Client Version 19.3.0
  • Linux-x86-Oracle Client Version 19.12.0.0
Oracle Server 21.1
  • Oracle JDBC Driver 21.1.0.0.0
  • Windows-Oracle Client Version 19.10
  • Linux-x86-Oracle Client Version 19.12
Oracle Server 21.3
  • Oracle JDBC Driver 21.1.0.0.0
  • Windows-Oracle Client Version 19.10
  • Linux-x86-Oracle Client Version 19.12
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
  • Windows-IBM Netezza ODBC driver Version 7.2.1.11
  • Linux-x86-IBM Netezza ODBC driver Version-7.2.1.11
SQL Server 2017 CU24
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Windows-SQL Server Native Client 11 (SQLNCLI11.DLL)
  • Windows-ODBC Driver for SQL Server 17
  • Linux-x86-DataDirect ODBC Driver 8.0.2
SQL Server 2019 CU10
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Windows-Microsoft OLE DB Driver for SQL Server 18.6 (MSOLEDBSQL.DLL)
  • Windows-ODBC Driver for SQL Server 17
  • Linux-x86-DataDirect ODBC Driver 8.0.2
SQL Server 2019 CU11
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Windows-Microsoft ODBC Driver 17.05 for SQL Server
  • Linux-x86-DataDirect Version 08.02
SQL Server 2019 CU12
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Windows-Microsoft ODBC Driver 17.05 for SQL Server
  • Linux-x86-DataDirect Version 08.02
Informix V14.10.XC5 server
  • Informix JDBC driver version 4.50.JC4W1
  • Windows-Informix SDK 4.10 TC14
  • Linux-x86-Informix SDK 4.10 TC15
Informix V14.10.XC6 server
  • Informix JDBC driver version 4.50.JC4W1
  • Windows-Informix SDK 4.10 TC14
  • Linux-x86-Informix SDK 4.10 TC15
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • SAP JConnect JDBC driver version 20.0.0
  • Windows-SAP Client-Library 16.0
  • Linux-x86-SAP Client-Library 16.0 SP4
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SAP IQ ODBC driver 16.0SP11
  • Linux-x86-SAP IQ ODBC driver 16.0 SP11
Sybase IQ Server 16.1 SP4
  • SAP JConnect JDBC driver version 20.0.0
  • Windows-SAP IQ ODBC driver 16.0SP11
  • Linux-x86-SAP IQ ODBC driver 16.0 SP11
IBM Performance server/Netezza 11.2.0.0 server
  • Netezza nzjdbc 11.2.0.0
  • Windows- ODBC driver 11.2.0.0
  • Linux-x86- ODBC driver 11.2.1.1
 

OLAP Data sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7 FP4:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9.10 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 15.1.86.19 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client (PL08)
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 15.1.86.19 for Windows
  • Linux-x86 -Not Applicable
  • AIX -Not Applicable
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A, no driver needed.
  • Not Applicable
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Vendor-supported client driver versions that were tested with Cognos Analytics on Premises 11.1.7 Fix Pack 3

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7 FP3:
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
  • JDBC driver 1.2.12.1015
  • JDBC driver 1.2.13.1016
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.16
  • Not applicable
Snowflake
  • JDBC driver 3.12.15
  • JDBC driver 3.12.16
  • JDBC driver 3.12.17
  • Not applicable
Amazon Redshift
  • JDBC Driver 1.2.51.1078
  • Not applicable
Denodo 8 server
  • JDBC driver version 8.0 20210209
  • Not applicable
Exasol 7.0.4 server
  • Exasol JDBC driver version 7.0.4
  • Not applicable
Exasol 7.0.6 server
  • Exasol JDBC driver version 7.0.4
  • Not applicable
Exasol 7.0.10 server
  • Exasol JDBC driver version 7.0.4
  • Not applicable
Presto Server 347
  • Presto JDBC Driver 347
  • Not applicable
Presto Server 348
  • Presto JDBC Driver 347
  • Not applicable
Presto Server 350
  • Presto JDBC Driver 347
  • Not applicable
Greenplum 6.12.0 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
  • Not applicable
Greenplum 6.13.0 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
  • Not applicable
Greenplum 6.16.0 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
  • Not applicable
Apache Hive Server 3.1
  • Hive JDBC Driver 3.1.0.3.1.5.0-152
  • Not applicable
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.17.1020
  • Not applicable
BigSQL 7.0.0 server
  • IBM JCC JDBC driver version 4.27.25
  • Not applicable
BigSQL 7.1.1 server
  • IBM JCC JDBC driver version 4.28.11
  • Not applicable
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Not applicable
Azure SQL 12.00.2000
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Not applicable
MariaDB 10.5.9 server
  • MariaDB JDBC driver version 2.7.1
  • Not applicable
MemSQL 7.1.11 server
  • MariaDB JDBC driver version 2.7.1
  • Not applicable
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
  • Not applicable
TIBCO Composite Server 8.3
  • Tibco Composite JDBC driver version 8.3.0
  • Not applicable
Mongo BI Connector Server 2.14.1
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 10.01 server
  • Vertica JDBC Driver 10.00.0100
  • Windows-Vertica Client Driver Version 10.0.1
  • Linux-x86-Not applicable
Teradata 17.05.02.01 server
  • Teradata JDBC driver version 17.00.00.03
  • Windows-Teradata ODBC Driver Version 17.00.00.20
  • Linux-x86-Teradata ODBC Driver Version 17.00.00.20
IBM DB2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.4
  • Windows-IBM i Access ODBC Driver 7.01.022
  • Linux-x86-IBM i Access ODBC Driver 7.01.023
IBM DB2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.6
  • Windows-IBM i Access ODBC Driver 7.01.022
  • Linux-x86-IBM i Access ODBC Driver 7.01.023
IBM DB2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.28.11
  • Windows-IBM Data Server Client 11.1
  • Linux-x86-IBM Data Server Client 11.1
IBM DB2 11.5.5 server
  • IBM JCC JDBC driver version 4.28.11
  • Windows-IBM Data Server Client 11.5.5
  • Linux-x86-IBM Data Server Client 11.5.4
PostgreSQL Server 12.6
  • PostgreSQL JDBC driver version 42.2.18
  • Windows-PostgreSQL ODBC 13.1
  • Linux-x86-PostgreSQL ODBC 13.1
PostgreSQL Server 13.1
  • PostgreSQL JDBC driver version 42.2.18
  • Windows-PostgreSQL ODBC 13.1
  • Linux-x86-PostgreSQL ODBC 13.1
PostgreSQL Server 13.2
  • PostgreSQL JDBC driver version 42.2.18
  • Windows-PostgreSQL ODBC 13.1
  • Linux-x86-PostgreSQL ODBC 13.1
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.003967
  • Not applicable
MySQL 8.0.23 server
  • MySQL JDBC driver version 8.0.23
  • Windows-MySQL Connector/ODBC 8.0.24
  • Linux-x86-MySQL Connector/ODBC 8.0.24
Oracle Server 19.9
  • Oracle JDBC Driver 19.9.0.0.0
  • Windows-Oracle Client Version 19.9
  • Linux-x86-Oracle Client Version 19.9
Oracle Server 19.10
  • Oracle JDBC Driver 19.10.0.0.0
  • Windows-Oracle Client Version 19.10
  • Linux-x86-Oracle Client Version 19.10
Oracle Server 21.1
  • Oracle JDBC Driver 21.1.0.0.0
  • Windows-Oracle Client Version 19.10
  • Linux-x86-Oracle Client Version 19.10
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
  • Windows-IBM Netezza ODBC driver Version 7.2.1.10
  • Linux-x86-IBM Netezza ODBC driverVersion- 7.2.1.10
SQL Server 2019 15.0.4073.23
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 15.0.4073.23
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
Informix V14.10.XC4 server
  • Informix JDBC driver version 4.50.JC4W1
  • Windows-Informix Client Version:4.10.14
  • Linux-x86-Informix Client Version: 4.50.FC4W1
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SDK for SAP ASE Version 16.0
  • Linux-x86-SDK for SAP ASE Version 16.0
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SAP IQ Network Client 16.0
  • Linux-x86-SAP IQ Network Client 16.0
IBM Performance server/Netezza 11.2.0.0 server
  • Netezza nzjdbc 11.2.0.0
  • Windows-IBM Netezza ODBC driver Version 11.2.0.0
  • Linux-x86 IBM Netezza ODBC driver version 11.2.0.0
  • Netezza nzjdbc 11.0.7.0
  • Windows-IBM Netezza ODBC driver Version 11.0.7.1
  • Linux-x86 IBM Netezza ODBC driver version 11.0.7.1
  • Netezza nzjdbc 11.0.7.1
  • Windows-IBM Netezza ODBC driver Version 11.7.0.0
  • Linux-x86 IBM Netezza ODBC driver version 11.0.7.0
 

OLAP Data Sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7 FP3:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9.7 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client (build 753, patch 225, changelist 1868726)
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A-no driver needed.
  • Not Applicable
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Vendor-supported client driver versions that were tested with Cognos Analytics on Premises 11.1.7 Fix Pack 2

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7 FP2:
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
  • JDBC driver 1.2.4.1007
  • JDBC driver 1.2.11.1014
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.13
  • JDBC driver 2.0.14
  • JDBC driver 2.0.15
  • Not applicable
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
  • Not applicable
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
  • Not applicable
Denodo 8 server
  • JDBC driver version 8.0
  • Not applicable
Exasol 6.2.7 server
  • Exasol JDBC driver version 6.2.3
  • Exasol JDBC driver version 6.2.5
  • Not applicable
Presto Server 334
  • Presto JDBC Driver 334
  • Not applicable
Presto Server 335
  • Presto JDBC Driver 335
  • Not applicable
Presto Server 336
  • Presto JDBC Driver 336
  • Not applicable
Presto Server 337
  • Presto JDBC Driver 337
  • Not applicable
Presto Server 338
  • Presto JDBC Driver 338
  • Not applicable
Presto Server 339
  • Presto JDBC Driver 339
  • Not applicable
Presto Server 340
  • Presto JDBC Driver 340
  • Not applicable
Presto Server 341
  • Presto JDBC Driver 341
  • Not applicable
Presto Server 342
  • Presto JDBC Driver 342
  • Not applicable
Presto Server 343
  • Presto JDBC Driver 343
  • Not applicable
Presto Server 344
  • Presto JDBC Driver 344
  • Not applicable
Presto Server 345
  • Presto JDBC Driver 345
  • Not applicable
Presto Server 346
  • Presto JDBC Driver 346
  • Not applicable
Greenplum 6.10.1 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000275
  • Not applicable
Apache Hive Server 3.1
  • Hive JDBC Driver 3.1.0.3.1.5.0-152
  • Not applicable
Cloudera Impala 3.4 server
  • Cloudera JDBC driver version 2.6.17.1020
  • Not applicable
BigSQL 7.0.0 server
  • IBM JCC JDBC driver version 4.27.25
  • Not applicable
BigSQL 7.1.0 server
  • IBM JCC JDBC driver version 4.27.25
  • Not applicable
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Not applicable
Azure SQL 12.00.2000
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Not applicable
MariaDB 10.5.4 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • Not applicable
MariaDB 10.5.5 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • Not applicable
MariaDB 10.5.6 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • Not applicable
MemSQL 7.1.7 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • Not applicable
MemSQL 7.1.11 server
  • MariaDB JDBC driver version 2.6.2
  • MariaDB JDBC driver version 2.7.0
  • Not applicable
SAP HANA 2.0 SP05 server
  • SAP Hana JDBC driver version 2.0.SP5
  • Not applicable
TIBCO Composite Server 8.3
  • Tibco Composite JDBC driver version 8.3.0
  • Not applicable
Mongo BI Connector Server 2.14.0
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 10.0 server
  • Vertica JDBC Driver 10.00.0100
  • Windows-Vertica Client Driver Version 10.0.1
  • Linux-x86 -Not applicable
Teradata 17.0 server
  • Teradata JDBC driver version 17.00.00.02
  • Windows-Teradata ODBC Driver Version 16.20.00.98
  • Windows-Teradata ODBC Driver Version 17.00.00.19
  • Linux-x86- Teradata ODBC Driver Version 16.20.00.98
  • Linux-x86- Teradata ODBC Driver Version 17.00.00.18
IBM DB2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.4
  • Windows-IBM i Access ODBC Driver 7.01.022
  • Linux-x86 - IBM i Access ODBC Driver 7.01.023
IBM DB2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.26.14
  • Windows-IBM Data Server Client 11.1
  • Linux-x86- IBM Data Server Client 11.1
IBM DB2 11.5.4 server
  • IBM JCC JDBC driver version 4.27.25
  • Windows-IBM Data Server Client 11.5.4
  • Linux-x86- IBM Data Server Client 11.5.4
PostgreSQL Server 11.8
  • PostgreSQL JDBC driver version 42.2.16
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86- PostgreSQL ODBC 12.2
PostgreSQL Server 11.9
  • PostgreSQL JDBC driver version 42.2.16
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
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
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86PostgreSQL ODBC 12.2
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
  • Windows PostgreSQL ODBC 12.2
  • Linux-x86- PostgreSQL ODBC 12.2
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
  • Windows-PostgreSQL ODBC 12.2
  • Linux-x86-PostgreSQL ODBC 12.2
Progress DataDirect Autonomous REST
  • JDBC driver 6.0.0.003701
  • Not applicable
MySQL 8.0.20 server
  • MySQL JDBC driver version 8.0.20
  • Windows-MySQL Connector/ODBC 8.0.20
  • Linux-x86-MySQL Connector/ODBC 8.0.20
MySQL 8.0.21 server
  • MySQL JDBC driver version 8.0.21
  • Windows-MySQL Connector/ODBC 8.0.21
  • Linux-x86- MySQL Connector/ODBC 8.0.21
MySQL 8.0.22 server
  • MySQL JDBC driver version 8.0.22
  • Windows-MySQL Connector/ODBC 8.0.22
  • Linux-x86-MySQL Connector/ODBC 8.0.22
Oracle Server 18.10
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
  • Oracle JDBC Driver 19.8.0.0.0
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
Oracle Server 19.7
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
  • Oracle JDBC Driver 19.8.0.0.0
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
Oracle Server 19.8
  • Oracle JDBC Driver 19.6.0.0.0
  • Oracle JDBC Driver 19.7.0.0.0
  • Windows-Oracle Client Version 19.6
  • Linux-x86-Oracle Client Version 19.3
  • Oracle JDBC Driver 19.8.0.0.0
  • Windows Oracle Client Version 19.8
  • Linux-x86-Oracle Client Version 19.6
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.10
  • Windows-IBM Netezza ODBC driver Version 7.2.1.10
  • Linux-x86-IBM Netezza ODBC driverVersion-7.2.1.10
SQL Server 2017 CU20
  • Microsoft SQL Server JDBC driver version 8.4.0
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2017 CU21
  • Microsoft SQL Server JDBC driver version 8.4.0
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU5
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU6
  • Microsoft SQL Server JDBC driver version 8.4.0
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2019 CU8
  • Microsoft SQL Server JDBC driver version 8.4.1
  • Windows-Microsoft ODBC Driver 17.6.1 for SQL Server and OLE DB Driver 11.0
  • Linux-x86-DataDirect Version 8.0.2
Informix V14.10.XC4 server
  • Informix JDBC driver version 4.50.JC4W1
  • Windows-Informix Client Version:4.10.14
  • Linux-x86-Informix Client Version: 4.50.FC4W1
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SDK for SAP ASE Version 16.0
  • Linux-x86-SDK for SAP ASE Version 16.0
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SAP IQ Network Client 16.0
  • Linux-x86-SAP IQ Network Client 16.0
IBM Performance server/Netezza 11.1.1.0 server
  • Netezza nzjdbc 11.0.6.1
  • Windows-IBM Netezza ODBC driver Version 11.0.6.1
  • Linux-x86 IBM Netezza ODBC driver version 11.0.6.1
  • Netezza nzjdbc 11.1.1.0
  • Windows-IBM Netezza ODBC driver Version 11.0.6.1
  • Linux-x86 IBM Netezza ODBC driver version 11.1.1.0
  • Windows-IBM Netezza ODBC driver Version 11.1.1.0
  • Linux-x86 IBM Netezza ODBC driver version 11.1.1.0
 

OLAP Data Sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7 FP2:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9 IF4 Server
  • No driver needed
  • Not Applicable
IBM Planning Analytics 2.0.91 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86-Not Applicable
  • AIX - Not Applicable
  • Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client, Windows tested
  • Not Applicable
MS Analysis Services 2017 CU21 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86-Not Applicable
  • AIX - Not Applicable
  • Not Applicable
MS Analysis Services 2017 CU21 server
  • XML/A-no driver needed.
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • MS OLEDB driver version 15.1.69.20 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
MS Analysis Services 2019 CU8 server
  • XML/A-no driver needed.
  • Not Applicable
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Cognos Analytics on Premises 11.1.7 - vendor-supported client driver versions that were tested with Cognos Analytics

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.7:
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
  • JDBC driver 1.2.2.1004
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.9
  • Not applicable
Snowflake
  • JDBC driver 3.11.1
  • JDBC driver 3.12.0
  • JDBC driver 3.12.1
  • JDBC driver 3.12.2
  • JDBC driver 3.12.3
  • Not applicable
Amazon Redshift
  • JDBC Driver 1.2.37.1061
  • Not applicable
Denodo 7 server
  • JDBC driver version (20200310)
  • Not applicable
Exasol 6.2.1 server
  • Exasol JDBC driver version 6.2.1
  • Not applicable
Presto Server 325
  • Presto JDBC Driver 325
  • Not applicable
Presto Server 326
  • Presto JDBC Driver 326
  • Not applicable
Presto Server 327
  • Presto JDBC Driver 327
  • Not applicable
Presto Server 328
  • Presto JDBC Driver 328
  • Not applicable
Presto Server 329
  • Presto JDBC Driver 329
  • Not applicable
Presto Server 330
  • Presto JDBC Driver 330
  • Not applicable
Presto Server 331
  • Presto JDBC Driver 331
  • Not applicable
Presto Server 332
  • Presto JDBC Driver 332
  • Not applicable
Greenplum 6.4 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000270
  • Not applicable
Greenplum 6.6 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000270
  • Not applicable
Apache Hive Server 3.1
  • Hive JDBC Driver 3.1.0.3.1.0.0-78
  • Not applicable
Cloudera Impala 3.2 server
  • Cloudera JDBC driver version 2.6.12.1013
  • Cloudera JDBC driver version 2.6.15.1017
  • Cloudera JDBC driver version 2.6.17.1020
  • Not applicable
BigSQL 6.0.0 server
  • IBM JCC JDBC driver version 4.26.14
  • Not applicable
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
Azure SQL 12.00.2255
  • Microsoft SQL Server JDBC driver version 9.2.0
  • Microsoft SQL Server JDBC driver version 9.4.0
  • Not applicable
MariaDB 10.3.22 server
  • MariaDB JDBC driver version 2.5.4
  • MariaDB JDBC driver version 2.6.0
  • Not applicable
MariaDB 10.4.12 server
  • MariaDB JDBC driver version 2.5.4
  • MariaDB JDBC driver version 2.6.0
  • Not applicable
MemSQL 7.0.12 server
  • MariaDB JDBC driver version 2.6.0
  • Not applicable
SAP HANA 2.0 SP04 server
  • SAP Hana JDBC driver version 2.0.SP4
  • Not applicable
TIBCO Composite Server 8.2
  • Tibco Composite JDBC driver version 8.2.0
  • Not applicable
Mongo BI Connector Server 2.13.3
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Mongo BI Connector Server 2.13.4
  • MySQL JDBC driver version 5.1.47
  • Not applicable
Vertica 9.3 server
  • Vertica JDBC Driver 9.3.0
  • Windows-Vertica Client Driver Version 9.3
  • Linux-x86 -Vertica ODBC Driver Version 9.3.0
Vertica 10.0 server
  • Vertica JDBC Driver 10.0.0
  • Windows-Vertica Client Driver Version 10.0.0
  • Linux-x86 -Vertica ODBC Driver Version 10.0.0
Teradata 16.20.45 server
  • Teradata JDBC driver version 16.20.00.13
  • Windows-Teradata ODBC Driver Version 16.20.28.00
  • Linux-x86- Teradata ODBC Driver Version 16.20.00.68
IBM DB2 11.5 server
  • IBM JCC JDBC driver version 4.26.14
  • Windows-IBM Data Server Client 11.5
  • Linux-x86- IBM Data Server Client 11.5
IBM DB2 11.1.4.5
  • IBM JCC JDBC driver version 4.26.14
  • IBM Data Server Client 11.1.4.5
  • Linux-x86- IBM Data Server Client 11.5
PostgreSQL Server 12.2
  • PostgreSQL JDBC driver version 42.2.10
  • Windows-PostgreSQL ODBC 12.1
  • Linux-x86- PostgreSQL ODBC 12.0
MySQL 8.0.19 server
  • MySQL JDBC driver version 8.0.19
  • Windows-MySQL Connector/ODBC 8.0.20
  • Linux-x86- MySQL Connector/ODBC 8.0.20
Oracle Server 19.6
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 19.6
  • Linux-x86- Oracle Client Version 19.3
Netezza Server 7.2.1
  • Netezza JDBC driver 7.2.1.8
  • Windows-IBM Netezza ODBC driver Version 7.2.1
  • Linux-x86- IBM Netezza ODBC driverVersion- 7.2.1
SQL Server 2017 CU18
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86-DataDirect Version 8.0.2
SQL Server 2017 CU19
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
SQL Server 2019 CU2
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
SQL Server 2019 CU3
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
SQL Server 2019 CU4
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
SQL Server 2019
  • Microsoft SQL Server JDBC driver version 8.2.0
  • Windows-Microsoft ODBC Driver 17.5.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
DB2 iSeries JT400 Server 7.3
  • JTOpen JDBC Driver 10.2
  • IBM i Access ODBC Driver 7.01.022
  • Linux-IBM i Access ODBC Driver 7.01.023
DB2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.2
  • IBM i Access ODBC Driver 7.01.022
  • Linux-IBM i Access ODBC Driver 7.01.023
DB2 iSeries JT400 Server 7.3
  • JTOpen JDBC Driver 10.3
  • IBM i Access ODBC Driver 7.01.022
  • Linux-IBM i Access ODBC Driver 7.01.023
DB2 iSeries JT400 Server 7.4
  • JTOpen JDBC Driver 10.3
  • IBM i Access ODBC Driver 7.01.022
  • Linux-IBM i Access ODBC Driver 7.01.023
DB2 Z Server 12.1.5
  • IBM JCC JDBC driver version 4.26.14
  • Windows-IBM Data Server Client 11.1
  • Linux-x86- IBM Data Server Client 11.1
Informix V14.10.XC14 server
  • Informix JDBC driver version 4.50.jc1x2
  • Windows-Informix Client Version:4.10.13
  • Linux-x86- Informix Client Version: 4.10.13
Sybase ASE Server 16 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SDK for SAP ASE Version 16.0
  • Linux-x86- SDK for SAP ASE Version 16.0
Sybase IQ Server 16.1 SP3
  • SAP JConnect JDBC driver version 16.1.3
  • Windows-SAP IQ Network Client 16.0
  • Linux-x86- SAP IQ Network Client 16.0
IBM Performance server/Netezza
  • Netezza nzjdbc11.0.2
  • Windows-IBM Netezza ODBC driver Version 11.0.3.1
  • Linux-x86 IBM Netezza ODBC driver version 11.0.5.0
 

OLAP Data Sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.7:
Database type
Dynamic Query versions
Compatible Query versions
IBM Planning Analytics 2.0.9 IF4 Server
  • No driver needed
  • Not Applicable
IBM Planning Analytics 2.0.91 Server
  • No driver needed
  • Not Applicable
Azure Analysis Services server
  • MS OLEDB driver version 15.1.5.15 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
IBM Cognos Powercube
  • No driver needed
  • (Dashboards only)
  • No driver needed
SAP BW 7.5 server
  • SAP 7.5 client, Windows tested
  • Not Applicable
MS Analysis Services 2017 server
  • MS OLEDB driver version 15.1.5.15 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
MS Analysis Services 2017 server
  • XML/A-no driver needed.
  • Not Applicable
MS Analysis Services 2019 server
  • MS OLEDB driver version 15.0.33.23 for Windows
  • Linux-x86 -Not Applicable
  • AIX - Not Applicable
  • Not Applicable
MS Analysis Services 2019 server
  • XML/A-no driver needed.
  • Not Applicable
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Cognos Analytics on Premises 11.1.6 - vendor-supported client driver versions that were tested with Cognos Analytics

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.6:
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
Amazon Athena
Snowflake
Amazon Redshift
Denodo 7 server
Exasol 6.2.1 server
Presto Server 317
Presto Server 319     
  • Presto JDBC Driver 319
  • Not applicable
 
Presto Server 320   
  • Presto JDBC Driver 320
  • Not applicable
Presto Server 323   
  • Presto JDBC Driver 323
  • Not applicable
Presto Server 324    
  • Presto JDBC Driver 324
  • Not applicable
Apache Hive Server 3.1
Cloudera Impala 3.2 server
BigSQL 6.0.0 server
Azure Synapse Analytics 12.00.2531
MariaDB 10.3.18 server
MariaDB 10.3.20 server
MariaDB 10.3.21 server
  • MariaDB JDBC driver version 2.4.4
  • Not applicable
MariaDB 10.4.8 server
  • MariaDB JDBC driver version 2.4.4
  • Not applicable
MariaDB 10.4.10 server
  • MariaDB JDBC driver version 2.4.4
  • Not applicable
MariaDB 10.4.11 server
  • MariaDB JDBC driver version 2.5.3
  • Not applicable
SAP HANA 2.0 SP04 server
GreenPlum 6.1 server
GreenPlum 6.4 server
MemSQL 7.0.9 server
TIBCO Composite Server 8.0
Mongo BI Connector Server 2.11.1
Mongo BI Connector Server 2.12
  • MySQL JDBC driver version 5.1.46
  • Not applicable
Vertica 9.3 server
Teradata 16.20.23 server
IBM DB2 11.1.4.5 server
  • IBM JCC JDBC driver version 4.26.14
  • Windows-IBM Data Server Client 11.1.4.5
IBM DB2 11.5 server
PostgreSQL 12.0 server
MySQL 8.0.18 server
Oracle Server 18.7
Oracle Server 19.4
Netezza Server 7.2.1
SQL Server 2017 CU17
SQL Server 2019
Db2 iSeries Server 7.4
DB2 Z  Server 12.1.5
Informix V14.10.XC3 server
Sybase ASE Server 16 SP3
Sybase IQ Server 16.1 SP3
IBM Performance server/Netezza
  • Netezza nzjdbc11.0.2
  • Windows-IBM Netezza ODBC driver Version 11.0.3.1_
 

OLAP Data Sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.6:
Database type
Dynamic Query versions
Compatible Query versions
TMR (PA) 2.0.9 Server
Azure Analysis Services server
IBM Cognos Powercube
SAP BW 7.5 server
MS Analysis Services 2017 server
Oracle Essbase 11.1.2.4 server
  • 11.1.2.4.000.164 client
  • Not Applicable

Cognos Analytics on Premises 11.1.5 - vendor-supported client driver versions that were tested with Cognos Analytics

Relational Data Sources
The following vendor-supported client driver versions were tested with Cognos Analytics 11.1.5:
 
Database type
Dynamic Query versions
Compatible Query versions
Google BigQuery
Amazon Athena
Snowflake
Amazon Redshift
Denodo 7 server
Exasol 6.2.1 server
Presto Server 312
Apache Hive Server 3.1
Cloudera Impala 3.2 server
BigSQL 5.0.4 server
Azure Synapse Analytics 12.00.2531
MariaDB 10.4.7 server
MariaDB 10.3.12 server
SAP HANA 2.0 SP04 server
GreenPlum 5.20.1 server
MemSQL 6.8.1 server
TIBCO Composite Server 8.0
Mongo BI Connector Server 2.11
Vertica 9.2 server
Teradata 16.20.23 server
IBM DB2 11.5 server
PostgreSQL 11.4 server
PostgreSQL 11.5 server
PostgreSQL Server 12.0
MySQL 8.0.16 server
MySQL 8.0.17 server
MySQL 8.0.18 server
Oracle Server 18.5
Oracle Server 18.6
Oracle Server 19.3
Netezza Server 7.2.1
SQL Server 2017 CU15
SQL Server 2017 CU16
Db2 iSeries Server 7.4
DB2 Z  Server 12.1.5
Informix V12.10.xC13 server
Sybase ASE Server 16 SP3
Sybase IQ Server 16.1 SP3
 

OLAP Data Sources
The following vendor-supported OLAP driver versions were tested with Cognos Analytics 11.1.5:
Database type
Dynamic Query versions
Compatible Query versions
TMR (PA) 2.0.9 Server
Azure Analysis Services server
IBM Cognos Powercube
SAP BW 7.5 server
MS Analysis Services 2017 server

[{"Type":"MASTER","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":"a8m0z000000TN4sAAG","label":"Installation and Configuration-\u003EDatabase"}],"ARM Case Number":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"11.1.5;11.1.6;11.1.7"}]

Document Information

Modified date:
14 October 2022

UID

ibm11106607