Importing the product ETL

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:

About this task

Import the product-specific ETL data movement task.

Procedure

  1. 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).
  2. Open the Cognos Web application at http://server:port/insight/.
  3. Open the Cognos administration page by clicking Launch > IBM Cognos Administration.
  4. Click the Configuration tab, and then click Content Administration.
  5. In the upper right corner, click the New Import (New import) icon. The New Import wizard opens.
  6. In the Select a Deployment Archive page, select the ETL Data Movement task, rqm_etl, and click Next.
  7. In the Specify a Name and Description page, accept the default name and location, and click Next.
  8. 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.
  9. In the Specify the Directory Content page, keep the default values, and click Next.
  10. In the Specify the General Options page, keep the default values, and click Next.
  11. In the Review the Summary page, review the settings, and click Next.
  12. In the Select an Action page, select Save and run once or Save and schedule, and then click Finish.
  13. 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.

Feedback