The ETL catalog contains the fact tables and dimension
tables that define how the data is extracted, transformed, and loaded
to the data warehouse. Rational® Quality Manager provides an ETL package for integration with Rational Common Reporting.
Before you begin
The ETL package is located in the
Rational Quality Manager installation directory at:
- [Rational_Quality_Manager_installation_directory]\cognos\deployment.
About this task
Import the product-specific ETL data movement task.
Procedure
- Copy rqm-etl.zip from the Rational Quality Manager Cognos subdirectory ([Rational_Quality_Manager_installation_directory]\cognos\deployment) to the Rational Common Reporting deployment directory ([Rational_Common_Reporting_installation_directory]\cognos\deployment).
- Open the Cognos Web application at http://server:port/insight/.
- Open the Cognos administration page by clicking .
- Click the Configuration tab, and
then click Content Administration.
- In the upper right corner, click the New Import (
) icon. The New Import wizard opens.
- In the Select a Deployment Archive page, select the ETL Data Movement task, rqm_etl, and click Next.
- In the Specify a Name and Description page, accept the default name and location, and click Next.
- In the Select the Public Folders Content page, select all the public folders that are displayed by selecting
the checkbox next to the Name column. Keep
the default values of the other options, and click Next.
- In the Specify the Directory Content page, keep the default values, and click Next.
- In the Specify the General Options page, keep the default values, and click Next.
- In the Review the Summary page,
review the settings, and click Next.
- In the Select an Action page, select Save and run once or Save and schedule, and then click Finish.
- In the Run with Options page, keep
all default values. Click Run, and then click OK.
What to do next
After importing the package successfully, verify that the
rqm_etl package displays in
Public Folder.