Configure the Cognos Controller database

Before you can run IBM® Cognos Controller, you must configure the Cognos Controller database.

You configure the Cognos Controller database using Controller Configuration.

Important: Controller Configuration is not the same tool as was used to configure and start the server components. Ensure that you start Controller Configuration rather than IBM Cognos® Configuration.

Procedure

  1. From the Start menu, start Controller Configuration.

    If you are using a Microsoft Windows operating system with User Account Control (UAC) turned on and installed the product to the Program Files directory, IBM Cognos Controller Configuration is identified as an administrative application. You must run it with elevated administrative privileges. To save the configuration settings, the UAC prompts for credentials if you are using a standard account.

  2. In the Explorer window, click Database Connections, and then click File > New.
  3. In the Properties window, click the Database type box, and then use the drop-down arrow to select the database type.

    You can choose DB2, Oracle or SQL Server.

  4. In the Name box, type a name for the database connection.
  5. In the Provider box, type the name of the database provider.

    To obtain the database provider information, see the DB2®, Oracle or SQL Server documentation.

  6. In the User ID and Password boxes, type the user name and password for the Controller database.
  7. In the Initial catalog box, type the Controller database name.
  8. In the Data source box, type the database server computer name.

    Do not use localhost.

  9. Click File > Save.
  10. In the Explorer window, expand Database Connections.
  11. Select the database you want to upgrade.
  12. Click Actions > Run.
  13. If no Java™ is found, browse to and select the Java 8 JRE in the C:\Program Files\ibm\cognos\ccr_64\bin64\jre\8.0 directory.
  14. If you have more than one Oracle version installed a message appears, select the same Oracle version that you are using with Controller.
  15. If this is an empty Controller database, in the Database Conversion Utility window, click Create Db.

    The Database Conversion Utility initializes the database.

    Note: When you create a new database, by default the database version is 813. You then need to perform database upgrade to the latest version of IBM Cognos Controller.
  16. In the Database Conversion Utility dialog box, click Connect and then click Upgrade.

    The Database Conversion Utility upgrades the existing database.

    Note: To upgrade database versions lower than 789 use the old Database Conversion Utility tool in the c10\legacy directory.
  17. Click Close.
  18. From the Actions menu, click Check.

    If the database connection validation fails, review the database connection properties and fix any errors.

  19. From the File menu, click Save.
  20. In the Explorer window, under Web Services Server, click Report Server.
  21. Under Report Server connections, click Repair.

    The new database is now configured as a data source for Report Server, and is listed as a data source in IBM Cognos Connection.