Set Database Connection Properties for the Controller Data Mart

To prepare for using the Publish to Data Mart Framework Manager model, provided with IBM® Cognos® Controller, you must create a database connection to the empty Controller data mart database, which you previously created.

Before you begin

Before you configure the Publish to data mart connection, you must have set the connection properties for the Controller database. The Controller database contains the data to be published to the data mart.

Procedure

  1. From the Start menu, start Controller Configuration.
  2. In the Explorer window, click Database Connections for publish to data mart.
  3. In the Properties window, select the Controller database that will be used to publish to the data mart.
  4. In the Provider box, type the name of the database provider that is appropriate for the database type that is hosting the data mart.

    For information about the database provider, see the SQL Server documentation.

  5. In the User ID and Password boxes, type the user name and password for the data mart database.
  6. In the Initial catalog box, type the data mart database name.
  7. In the Data source box, type the name of the server computer that hosts the data mart database.

    Do not use localhost.

  8. Click File > Save.
  9. Click Actions > Check.

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

  10. In the Explorer window, under Database Connections, click the Controller database that will be used to publish to the data mart.
  11. Click Actions > Run.
  12. If no Java™ is found, browse to and select the Java 7 JRE in the installdir\bin64\jre\7.0\ directory.
  13. Click Data Mart DB.
  14. In the UDL File box, browse to the location of the UDL file for the Controller data mart database at ccr_location \DMData and click Open.
  15. Click Create DB.

    The Database Conversion Utility creates the data mart tables.

  16. Click Close.
  17. Click File > Save.
  18. In the Explorer window, under Web Services Server, click Report Server.
  19. In the Report Server window, under Report Server connections, click Repair.

    If the repair button is unavailable, the data mart database is already known to Content Manager. The new data mart database is now configured as a data source for Report Server, and is listed as a data source in IBM Cognos Connection.