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
  • JDBC driver 1.2.2.1004
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.9
  • Not applicable
Snowflake
  • JDBC driver 3.10.0
  • JDBC driver 3.10.1
  • JDBC driver 3.10.2
  • JDBC driver 3.10.3
  • JDBC driver 3.11.0
  • Not applicable
Amazon Redshift
  • JDBC Driver 1.2.34.1058
  • JDBC Driver 1.2.36.1060
  • JDBC Driver 1.2.37.1061
  • Not applicable
Denodo 7 server
  • JDBC driver version (20190903)
  • Not applicable
Exasol 6.2.1 server
  • Exasol JDBC driver version 6.2.1
  • Not applicable
Presto Server 317
  • Presto JDBC Driver 317
  • Not applicable
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
  • 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
  • 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 7.2.1
  • Not applicable
MariaDB 10.3.18 server
  • MariaDB JDBC driver version 2.4.4
  • Not applicable
MariaDB 10.3.20 server
  • MariaDB JDBC driver version 2.4.4
  • Not applicable
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
  • SAP Hana JDBC driver version 2.0.SP4
  • Not applicable
GreenPlum 6.1 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000270
  • Not applicable
GreenPlum 6.4 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000270
  • Not applicable
MemSQL 7.0.9 server
  • MySQL JDBC driver version 8.0.15
  • Not applicable
TIBCO Composite Server 8.0
  • Tibco Composite JDBC driver version 8.1.0
  • Not applicable
Mongo BI Connector Server 2.11.1
  • MySQL JDBC driver version 5.1.46
  • Not applicable
Mongo BI Connector Server 2.12
  • MySQL JDBC driver version 5.1.46
  • Not applicable
Vertica 9.3 server
  • Vertica JDBC Driver 9.3.0
  • Windows-Vertica Client Driver Version 9.3
  • Linux-x86 -Not Applicable
Teradata 16.20.23 server
  • Teradata JDBC driver version 16.20.00.08
  • Windows-Teradata ODBC Driver Version 16.20.20.00
  • Linux-x86- Teradata ODBC Driver Version 15.00.00.11
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
  • IBM JCC JDBC driver version 4.26.14
  • Windows-IBM Data Server Client 11.5
  • Linux-x86- IBM Data Server Client 11.5
PostgreSQL 12.0 server
  • PostgreSQL JDBC driver version 42.2.8
  • Windows-PostgreSQL ODBC client version 12.0
  • Linux-x86- PostgreSQL ODBC client version 12.0
MySQL 8.0.18 server
  • MySQL JDBC driver version 8.0.18
  • Windows-MySQL Connector/ODBC 8.0.17
  • Linux-x86-MySQL Connector/ODBC 8.0.12
Oracle Server 18.7
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 18.3,
  • Linux-x86- Oracle Client Version 18.3
Oracle Server 19.4
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 19.3
  • 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 CU17
  • Microsoft SQL Server JDBC driver version 7.2.1
  • Windows-Microsoft ODBC Driver 17.4.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 7.2.1
  • Windows-Microsoft ODBC Driver 17.4.2 for SQL Server and OLE DB Driver 18.3
  • Linux-x86- DataDirect Version 8.0.2
Db2 iSeries Server 7.4
  • JTOpen JDBC Driver 9.8
  • IBM i Access ODBC Driver 11.01.0000,
  • Linux-IBM i Access ODBC Driver 11.01.0000
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.XC3 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 15.2.0_32
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
  • 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
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
  • JDBC driver 1.2.1.1001
  • JDBC driver 1.2.2.1004
  • Not applicable
Amazon Athena
  • JDBC driver 2.0.8
  • JDBC driver 2.0.9
  • Not applicable
Snowflake
  • JDBC driver 3.8.2
  • JDBC driver 3.9.0
  • JDBC driver 3.9.2
  • Not applicable
Amazon Redshift
  • JDBC Driver 1.2.32
  • Not applicable
Denodo 7 server
  • JDBC driver version (20190312)
  • Not applicable
Exasol 6.2.1 server
  • Exasol JDBC driver version 6.2.1
  • Not applicable
Presto Server 312
  • Presto JDBC Driver 317
  • 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
  • Not applicable
BigSQL 5.0.4 server
  • IBM JCC JDBC driver version 4.26.14
  • Not applicable
Azure Synapse Analytics 12.00.2531
  • Microsoft SQL Server JDBC driver version 7.2.1
  • Not applicable
MariaDB 10.4.7 server
  • MariaDB JDBC driver version 2.4.2
  • Not applicable
MariaDB 10.3.12 server
  • MariaDB JDBC driver version 2.4.2
  • Not applicable
SAP HANA 2.0 SP04 server
  • SAP Hana JDBC driver version 2.0.SP4
  • Not applicable
GreenPlum 5.20.1 server
  • Pivotal Greenplum JDBC Driver version 5.1.4.000212
  • Not applicable
MemSQL 6.8.1 server
  • MySQL JDBC driver version 8.0.15
  • Not applicable
TIBCO Composite Server 8.0
  • Tibco Composite JDBC driver version 8.1.0
  • Not applicable
Mongo BI Connector Server 2.11
  • MySQL JDBC driver version 5.1.45
  • Not applicable
Vertica 9.2 server
  • Vertica JDBC Driver 9.2.0
  • Windows-Vertica Client Driver Version 9.2
  • Linux-x86 -Not Applicable
Teradata 16.20.23 server
  • Teradata JDBC driver version 16.20.00.08
  • Windows-Teradata ODBC Driver Version 16.20.20.00
  • Linux-x86- Teradata ODBC Driver Version 15.00.00.11
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
PostgreSQL 11.4 server
  • PostgreSQL JDBC driver version 42.2.8
  • Windows-PostgreSQL ODBC client version 12
  • Linux-x86- PostgreSQL ODBC client version 12
PostgreSQL 11.5 server
  • PostgreSQL JDBC driver version 42.2.8
  • Windows-PostgreSQL ODBC client version 12,
  • Linux-x86- PostgreSQL ODBC client version 12
PostgreSQL Server 12.0
  • PostgreSQL JDBC driver version 42.2.8
  • Windows-PostgreSQL ODBC 12.0,
  • Linux-x86-PostgreSQL ODBC 12.0
MySQL 8.0.16 server
  • MySQL JDBC driver version 8.0.16
  • Windows-MySQL Connector/ODBC 8.0.17,
  • Linux-x86-MySQL Connector/ODBC 8.0.12
MySQL 8.0.17 server
  • MySQL JDBC driver version 8.0.17
  • Windows-MySQL Connector/ODBC 8.0.17,
  • Linux-x86- MySQL Connector/ODBC 8.0.12
MySQL 8.0.18 server
  • MySQL JDBC driver version 8.0.18
  • Windows-MySQL Connector/ODBC 8.0.17,
  • Linux-x86- MySQL Connector/ODBC 8.0.12
Oracle Server 18.5
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 18.3,
  • Linux-x86-Oracle Client Version 12.2.0.1
Oracle Server 18.6
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 18.3
  • Linux-x86-Oracle Client Version 12.2.0.1
Oracle Server 19.3
  • Oracle JDBC Driver 19.3.0.0.0
  • Windows-Oracle Client Version 18.3
  • Linux-x86- Oracle Client Version 12.2.0.1
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 CU15
  • Microsoft SQL Server JDBC driver version 7.2.1
  • Windows-Microsoft ODBC Driver 13 for SQL Server and MSSQLNative Client 11.0,
  • Linux-x86- DataDirect Version 7.1.3
SQL Server 2017 CU16
  • Microsoft SQL Server JDBC driver version 7.2.1
  • Windows-Microsoft ODBC Driver 13 for SQL Server and MSSQLNative Client 11.0,
  • Linux-x86- DataDirect Version 7.1.3
Db2 iSeries Server 7.4
  • JTOpen JDBC Driver 9.8
  • IBM i Access ODBC Driver 11.01.0000,
  • Linux-IBM i Access ODBC Driver 11.01.0000
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 V12.10.xC13 server
  • Informix JDBC driver version 4.10.jc12
  • 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 15.2.0_32
 

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
  • 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

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

Page Feedback