Define a Data Source for the Controller Data Mart

If you are preparing to use the Publish to Data Mart Framework Manager model provided with IBM® Controller, you must define a new data source so that Framework Manager can communicate with the Controller data mart database. You can define data sources in IBM Cognos® Administration or in Framework Manager. The data source appears in both places, regardless of where it was defined. Existing data source connections can be edited only in the portal.

Procedure

  1. Launch IBM Cognos Analytics.
  2. On the Configuration tab, click Data Source Connections.
  3. Click the New Data Source button.
  4. In the Name box, type CCR82_DM, the name of the Controller data mart database.
  5. In the Description box, type text to describe the database, and then click Next.
  6. In the Type box, select the appropriate database type for the data mart database.

    The connection string page for the selected database appears.

  7. Enter any parameters that make up the connection string, and specify any other settings, such as a signon or a timeout.
    Tip: To test whether parameters are correct, click Test. If prompted, type a user ID and password or select a signon, and then click OK.
  8. Click Finish.

    The data source appears as an entry in the Directory tool in the portal, and can be selected when using the import wizard in IBM Cognos Framework Manager.