Running the ETL job (RQM Specific)

You can extract, transform, and load data with Rational® Common Reporting. The extract, transform, and load (ETL) jobs are defined in the ETL task.

About this task

To run an ETL task:

Procedure

  1. Open the Cognos Web application at http://server:port/insight/servlet/dispatch.
  2. Under the Name column, click dataMovementTasks. RQMAll now displays under the Name column.
  3. Under the Actions column, click the Run with options icon.
  4. Leave the default under Time as Now, and click Run.
  5. Click OK.
  6. To verify that the ETL is running, go to Launch > IBM Cognos Administration. The running ETL catalogs are listed under the Name column.
    Note: The execution log is located on Rational Common Reporting server, for example, C:\Program Files\IBM\RCPR\cognos\datamanager\log.

Feedback