Configure 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.
For more information about installing Tivoli Common Reporting, see Dynamic Workload Console prerequisites.
To
configure
Tivoli Common Reporting,
perform the following steps:
Procedure
- Ensure you have installed Jazz for Service Management
and Tivoli Common Reporting.
- From the navigation toolbar, click Reporting > Common Reporting. The IBM Cognos Connection
interface is displayed.
- Click .
- Select the Configuration tab.
- Click the New Data Source icon. The New Data Source wizard is displayed.
- Specify the name of the alias of the IBM Workload Scheduler database.
The name of the database alias is as follows:
- On distributed environments
- TWS
- On z/OS environments
- TWS_ZOS
- In the Type list, select
either IBM DB2 or the appropriate Microsoft
SQL Server selection. Do not modify the other default
values on this wizard page and click Next.
- Specify the database name. This is the name of the database
where your data is stored.
- In the Signon section, select the Password checkbox
and specify the user ID and password of the IBM Workload Scheduler database.
Click Next.
- 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 IBM Workload Scheduler database.
You can now use IBM Cognos to create
and customize reports on the IBM Workload Scheduler database.
For more information, see the IBM Cognos documentation.
To
import the reports provided with IBM Workload Scheduler, follow
the import procedure, as described in Importing IBM Workload Scheduler reports.