Cognos Analytics 11.0.9 - new and changed features

The changes improve IBM® Cognos® Analytics server performance and ensure compliance with supported database products.

Teradata JDBC connections - improved query concurrency

Dynamic query mode was changed to ensure that only one query can be running against a Teradata JDBC connection. This change improves query concurrency, as described in the multi-threading section of the Teradata JDBC Driver Reference.

Database administrators who monitor their database workloads might notice an increase in the number of database connections comparing to previous releases of Cognos Analytics.

Snowflake connections - changed driver class name

In prior releases of Cognos Analytics, the default driver class name for new Snowflake connections was com.snowflake.client.jdbc.SnowflakeDriver. Starting with Cognos Analytics version 11.0.9, the default driver class name for new Snowflake connections is net.snowflake.client.jdbc.SnowflakeDriver.

Existing connections will continue to reference the Snowflake driver class com.snowflake.client.jdbc.SnowflakeDriver. When Snowflake removes that class name from the driver, those connections will require the Driver class name property to be changed to net.snowflake.client.jdbc.SnowflakeDriver.

Tip: To edit a data server connection, go to Manage > Administration console. On the Configuration tab, select Data source connections. Find the data server connection and open it. You cannot edit existing connections from Manage > Data server connections.

Amazon Redshift connections - changed driver class name

In previous releases of Cognos Analytics, the default driver class name for new Amazon Redshift connections was com.amazon.redshift.jdbc41.Driver, which required the RedshiftJDBC41.*.jar file.

Starting with Cognos Analytics version 11.0.9, the default driver class name for new Amazon Redshift connections is com.amazon.redshift.jdbc.Driver. This driver class name is used by Amazon JDBC driver version 1.2.1 or higher. The associated driver file is RedshiftJDBC.jar.

You can update existing connections by changing the Driver class name property to com.amazon.redshift.jdbc.Driver.

Tip: To edit a data server connection, go to Manage > Administration console. On the Configuration tab, select Data source connections. Find the data server connection and open it. You cannot edit existing connections from Manage > Data server connections.

PostgreSQL connections can be used with Amazon Aurora PostgreSQL

Starting with this release, you can use the existing PostgreSQL connection editor and JDBC driver to create and maintain data server connections to Amazon Aurora PostgreSQL.