Set Database Connection Properties for the Content Store

You must specify the database server information to ensure that Content Manager can connect to the database you use for the content store. Content Manager uses the database logon to access the content store. After you set the database connection properties, you can test the connection between Content Manager and the content store.

Content store configuration after an upgrade

If you are upgrading from IBM® Cognos® Business Intelligence or an earlier release of IBM Cognos Analytics with Watson, configure IBM Cognos Analytics with Watson to point to a copy of the existing content store database. After you save the configuration and start the IBM Cognos service, the data in the content store is automatically upgraded and cannot be used by the earlier version. By using a copy of the original database with the new version, you can keep IBM Cognos Analytics with Watson or the earlier version running with the original data.

Advanced properties

In Cognos Configuration, you can associate a database resource with each of the following services:

  • Content Manager
  • Mobile
  • Notification
  • Logging

Cognos Configuration provides connection editors for each of the supported databases. At runtime, services use the information entered in the connection editors to connect to the database using the vendor's JDBC driver. Each connection editor has an Advanced properties box in which you can specify vendor-specific name-value pairs that are supported by the JDBC driver.

The configuration requirements of the database system that you use determine whether you must enter any name-value pairs in the Advanced properties box.

For information about the description and purpose of name-value pairs supported by a database, see the JDBC driver documentation of the applicable database vendor.

Examples

Following are two examples of name-value pairs entered in the Advanced properties box:

Example 1

A SQL Server JDBC driver requires a connection that includes this name-value pair:

trustServerCertificate true
Example 2

An ORACLE JDBC driver requires a connection that includes multiple name-value pairs:

oracle.net.ssl_server_dn_match true
javax.net.ssl.trustStorePassword mysecret
javax.net.ssl.trustStore C:/myfolder/truststore.jks
javax.net.ssl.keyStore C:/myfolder/keystore.jks
javax.net.ssl.keyStorePassword mysecret