Data servers no longer supported in Cognos Analytics

Cognos Analytics 12.0.2

The following data servers are not supported as of the 12.0.2 release:

• MySQL 5.6
• Mongo BI 2.13 or earlier
• MariaDB 10.2
• SingleStore 7.1 and 7.3
• Dremio 17
• Db2 LUW 10.1

Cognos Analytics 12.0.1

The following data servers are not supported as of the 12.0.1 release:

• Denodo 6.x
• Vertica 9.x

Cognos Analytics 12.0.0

As of release 12.0.0, the connector for SPARK SQL Thrift data sources is removed from IBM® Cognos® Analytics. If you have existing connections to SPARK SQL Thrift data sources, they will no longer work.

Cognos Analytics 11.2.4

As of release 11.2.4, connectors for Essbase have been removed from IBM Cognos Analytics. Existing connections will no longer work, and the ability to create new Essbase connections has been removed. In addition, support for Essbase has been removed.

Cognos Analytics 11.2.3

The following data servers are not supported as of the 11.2.3 release:

• IBM Weather Company
• TM1
• IBM Planning Analytics versions prior to 2.0.6

  We recommend that you upgrade your Planning Analytics data server to a supported version. For more information, see the Cognos Analytics on Premises 11.2.3 section of the Supported Software Environments page.

• Microsoft Analysis Services (OLEDB) versions prior to SQL Server 2016 Service Pack 2

  We recommend that you upgrade your MSAS (OLEDB) data server to a supported version. For more information, see the Cognos Analytics on Premises 11.2.3 section of the Supported Software Environments page.

Cognos Analytics 11.2.2

The following data servers are not supported as of the 11.2.2 release:

• Vertica releases prior to 9.0
• Greenplum releases prior to 5.2.0
• Exasol releases prior to 7.0
• Mongo BI Connector releases prior to 2.12
• Informix releases prior to 12.10
• Impala releases prior to 3.1
• MariaDB releases prior to 10.2
• MySQL releases prior to 5.6
• Singlestore releases prior to 7.0
• Db2 distributed (LUW) releases prior to 10.5
• Denodo releases prior to 6.0
• SAP Hana 1
• Tibco Data Virtualization releases prior to 7.0.6
• Teradata releases prior to 16.10
• ORACLE 18
• Teradata Presto

The following OLAP data sources are no longer supported by Cognos Analytics:

• IBM Planning Analytics prior to 2.0.6.
• IBM TM1 (all versions)
• Microsoft Analysis Services (OLEDB) prior to SQL Server 2016 Service Pack 2

Cognos Analytics 11.2.0

The following data servers are not supported as of the 11.2.0 release:

• Computer Associates (Brocade) IDMS

Cognos Analytics 11.1.7 FP6

The following data servers are not supported as of the 11.1.7 FP6 release:

• IBM Weather Company

Cognos Analytics 11.1.3

Pivotal HDB data server is no longer supported in Cognos Analytics.

The associated data server type in the administration interfaces, Pivotal Greenplum and HDB, is changed to Pivotal Greenplum.

Cognos Analytics 11.0.8

The following data servers are not supported as of the 11.0.8 release:

• Hitachi Advanced Data Binder Platform (JDBC)
• IBM Domino (JDBC)
• MongoDB Connector for BI version 1

  Update any version 1 connections to use MongoDB Connector for BI version 2.2.1. Also, update existing Cognos models while connected to version 2.2.1. This will ensure that the model metadata reflects differences in data types and scale that were introduced in MongoDB Connector for BI 2.2.1.

Cognos Analytics 11.0.6

The following data servers are not supported as of the 11.0.6 release:

• Actian Matrix (ODBC and JDBC)

  Generic ODBC connection types can be used to refer to an ODBC DSN that uses an ODBC driver on Microsoft Windows operating systems to access an Actian Matrix server. You will not be able to use an existing JDBC connection.

• Actian Vector (ODBC)

  Generic ODBC connection types can be used to refer to an ODBC DSN that uses an ODBC driver on Microsoft Windows operating systems to access an Actian Vector server.

• IBM® IMS™ (JDBC)

Cognos Analytics 11.0.3

The following data servers are not supported as of the 11.0.3 release:

• IBM Cognos Finance - connection type CL
• Microsoft SQL Server Analysis Services 2005 and 2008 (ODBO) - connection types YK and M8

  Applications on Windows operating systems should use the ODBO client that is released with the supported Microsoft Analysis Services version. Applications on non-Windows platforms can use an XMLA (connection type X8) connection. The ODBO clients releases with SQL Server Analysis Services 2005, 2008 and 2008 R2 are no longer supported. Connections for versions 2012 (connection type M12) and 2014 (connection type M14) are both supported. New connections that reference the 2012 or 2014 clients should only be used for version 2012 and 2014 of the corresponding SQL Server Analysis Services servers.

  As of Cognos Analytics 11.0.0, only dynamic query mode servers support SQL Server Analysis Services. The compatible query mode does not support SQL Server Analysis Services.

• Microsoft SQL Server 2005 and 2008 Native Clients, and OLE DB (connection type OL and Provider=SQLNCLI or SQLNCLI10)

  Older versions of the Microsoft SQL Server client libraries are no longer supported ( https://msdn.microsoft.com/en-us/library/cc280510.aspx). For applications that must access SQL Server via OLE DB, you can use Native Client connections that include the Provider=SQLNCLI11. These connections are parallel to the current SQL Server Native Client version 11 that is supported with SQL Server 2016, 2014, and 2012. Alternatively, connections that use the Microsoft ODBC driver for SQL Server can be used.

• SAP ECC

Cognos Analytics 11.0.2

The following data servers are not supported as of the 11.0.2 release:

• Composite (ODBC)

  Composite (connection type CS): Generic ODBC (OD) connection types can be used to refer to an ODBC DSN which may be using a an ODBC driver on Window operation systems to access Siebel servers. Dynamic query mode supports several technologies, including Cisco Information Server and Denodo via JDBC that could potentially be used to provide federated access to Siebel systems.

• IBM Cognos Now! - Real-time Monitoring Cube (connection type LA)

  There is no alternative connection type.

• IBM Cognos Planning - Series 7 (connection type CR)

  There is no alternative connection type.

• IBM Cognos Virtual View Manager (ODBC)
• IBM Red Brick® (ODBC)
• Progress OpenEdge (ODBC)
• Siebel
• Sybase Adaptive Server Enterprise (CT-Lib)