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.

    If you are using a Windows 7 or Windows 2008 computer, installed the product to the Program Files directory, and the User Account Control (UAC) is turned on, IBM Cognos Controller Configuration is identified as an administrative application; therefore, you must run it with elevated administrative privileges. To properly 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 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. 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.
  16. Click Close.
  17. From the Actions menu, click Check.

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

  18. From the File menu, click Save.
  19. In the Explorer window, under Web Services Server, click Report Server.
  20. 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.