Data servers no longer supported in Cognos Analytics

The list of supported data servers is continuously evaluated. New data servers are added, and some of the previously supported data servers are removed.

All data server connections that were defined in previous releases of Cognos® Analytics remain in the content store until they are manually deleted or changed to a supported type where applicable. These connections are visible in the product administration interfaces. When such connections are opened in IBM Cognos Administration, they appear in the connection editor of type Other type. This connection editor provides a limited interface to view or edit the connections, and to access the associated signons.

Each data server connection in the content store is represented by a string with various custom names and values. This string is visible in the connection editors in Cognos Analytics. For example, when testing a connection, a string such as the following one is displayed: 

^User ID:^?Password:;LOCAL;PG;DSN=MyDataSourceName;
UID=%s;PWD=%s;MyODBCDSN@ASYNC=0@0/0@COLSEQ=

The connection type in the string is shown after the value LOCAL. In the above example, the connection type is PG.

If your current version of Cognos Analytics is using connections to data servers that are no longer supported, in some cases you can change the connections to the supported types.

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)