Configuring Tivoli Common Reporting

About this task

Tivoli Common Reporting provides a portal for IBM Cognos. After you have installed and configured Tivoli Common Reporting, you can launch and operate on IBM Cognos from the Dynamic Workload Console. To configure Tivoli Common Reporting, perform the following steps:

Procedure

  1. Ensure you have installed Jazz for Service Management and Tivoli Common Reporting.
  2. From the navigation toolbar, click Reporting > Common Reporting. The IBM Cognos Connection interface is displayed.
  3. Click Launch > Administration.
  4. Select the Configuration tab.
  5. Click the New Data Source icon. The New Data Source wizard is displayed.
  6. Specify the name of the alias of the HCL Workload Automation database. The name of the database alias is as follows:
    On distributed environments
    TWS
    On z/OS environments
    TWS_ZOS
  7. In the Type list, select either IBM DB2, Oracle, or the appropriate Microsoft SQL Server selection. Do not modify the other default values on this wizard page and click Next.
  8. Specify the database name. This is the name of the database where your data is stored.
  9. In the Signon section, select the Password checkbox and specify the user ID and password of the HCL Workload Automation database. Click Next.
  10. In the Server name field, specify the server name or IP address of the database, the port number, the JDBC connection properties, and the database name. Click Test Connection, if successful, click Finish. If the connection test is not successful, correct the information and retry.

Results

You have defined the connection to the HCL Workload Automation database. You can now use IBM Cognos to create and customize reports on the HCL Workload Automation database. For more information, see the IBM Cognos documentation.

To import the reports provided with HCL Workload Automation, follow the import procedure, as described in Importing HCL Workload Automation reports.