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 release.

NOTE: Please refer to the vendor documentation with respect to 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 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 SQL Datawarehouse 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-x86- PostgreSQL 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 SQL Datawarehouse 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.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 SQL Datawarehouse 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 SQL Datawarehouse 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

Related Information

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Component":"","Platform":[{"code":"PF033","label":"Windows"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
19 January 2021

UID

ibm11106607