Set Database Connection Properties for the Controller Data Source

Before you can run IBM® Cognos® Controller, you must configure a Controller database connection. IBM Cognos Controller databases must be created using Microsoft SQL Server.

To run reports against IBM Cognos Controller data sources, the data sources must be configured for Report Server and appear in IBM Cognos Connection.

If you are installing IBM Cognos Controller for the first time, or if you do not want to connect to an existing Controller database, you can create a database connection to an empty Controller database.

Before you begin

If you want to create a connection to an existing Controller database, we recommend that you create a backup of your database before you create the Controller data source connection. This is because the Controller Database Conversion Utility, which runs against the database during the data source connection process, updates the database tables for use with IBM Cognos Controller.

Procedure

  1. From the Start menu, start Controller Configuration.
  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 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 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 7 JRE in the installdir\bin64\jre\7.0\ directory.
  14. 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.
  15. Click Close.
  16. From the Actions menu, click Check.

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

  17. From the File menu, click Save.