Set Database Connection Properties for the Controller Data Source

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

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

If you are installing IBM 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 Controller.

Procedure

  1. From the Start menu, start Controller Configuration.

    If the product is installed in the Program Files directory, and the User Account Control (UAC) is turned on, IBM 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 Name box, type a name for the database connection.
  4. In the Provider box, type the name of the database provider.

    To obtain the database provider information, see the SQL Server documentation.

  5. In the User ID and Password boxes, type the user name and password for the Controller database.
    Provide the username and password if the integrated authentication is set as false. If the integrated authentication is set to true, the user does not need to provide the username and password.
  6. In the Initial catalog box, type the Controller database name.
  7. In the Data source box, type the database server computer name.

    Do not use localhost.

  8. Click File > Save.
  9. In the Explorer window, expand Database Connections.
  10. Select the database you want to upgrade.
  11. Click Actions > Run.
  12. 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 Controller.
  13. In the Database Conversion Utility dialog box, click Connect and then click Upgrade.

    The Database Conversion Utility upgrades the existing database.

  14. Click Close.
  15. From the Actions menu, click Check.

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

  16. From the File menu, click Save.