Configuring a Microsoft SQL Server, Oracle, Db2, Informix, or PostgreSQL content store in IBM Cognos Configuration

If you received a CM-CFG-5036 or IBM CONTENT MANAGER-CFG-5063 error code, the content store might not be configured correctly. To resolve the issue, reconfigure the content store.

Procedure

  1. In the Explorer window, go to Data Access > Content Manager. Right-click Content Store, and click Delete.

    The default content store is deleted. Content Manager must be configured to access only one content store.

  2. Right-click Content Manager, and then click New resource > Database.
  3. In the Name box, type a name for the database.
  4. In the Type box, select the type of database, and click OK.
    Tip: If you want to use Oracle Net8 keyword-value pair to manage the database connection, select Oracle database (Advanced).
  5. In the Properties window, provide values depending on your database type:
    • If you use a Microsoft SQL Server database, type the appropriate values for the Database server with port number or instance name and Database name properties.

      For the Database server with port number or instance name property, include the port number if you use nondefault ports. Include the instance name if there are multiple instances of Microsoft SQL Server.

      To connect to a named instance, you must specify the instance name as a Java™ Database Connectivity (JDBC) URL property or a data source property. For example, you can type localhost\instance1. If no instance name property is specified, a connection to the default instance is created.

      The properties specified for the named instance, along with the user ID and password, and database name, are used to create a JDBC URL. Here is an example:

      jdbc:JSQLConnect://localhost\\instance1/user=sa/more properties as required
    • If you use a DB2® database, for the Database name property, type the database alias.
    • If you use an Oracle database, type the appropriate values for the Database server and port number and Service name properties.
    • If you use an advanced Oracle database, for the Database specifier property, type the Oracle Net8 keyword-value pair for the connection.

      Here is an example:

      (description=(address=(host=myhost)(protocol=tcp)(port=1521) (connect_data=(sid=(orcl)))))

    • If you use a PostgreSQL database, type the appropriate values for the Database server and port number, Database name, and Schema name properties.
  6. If you want to change the logon credentials, specify a user ID and password in the following way:
    • Click the Value box next to the User ID and password property and then click the edit icon when it is displayed.
    • Type the appropriate values and click OK.
  7. From the File menu, click Save.

    The logon credentials are immediately encrypted.