Defining sources

You can define the source, which is used to connect the IBM® Cognos® Controller database with the data mart.

It includes information about the source status, purged date, last purged index, and the IBM Cognos Controller database last moved index.

Before you begin

When you define a source, then a check will be done on the existence of a new consolidation model. If only old consolidation models exists, then an error will be displayed that old consolidation models are not supported.

Procedure

  1. In the IBM Controller Financial Analytics Publisher window, click the Sources tab.
  2. Click New.
  3. In the Name field, enter the name of the source.
  4. From the Log level list, select Low, Normal, or High. Normal is selected by default.
  5. Select an interval.
  6. Optional: in the Description field, enter a description of the source.
  7. Select the database type, the server, the port, and the database you want to use.
  8. If you are using SQL native authentication, enter a valid user name and password. If you are using integrated authentication, enter the following into the Additional Parameters field: Integrated Security=SSPI. Username and Password is not required for the Integrated authentication.
  9. To test the new connection, click Test Connection.
  10. Click Save.

    You can change the source settings by clicking the Edit button.