Migrating report data from version 2

This topic describes how to migrate your reporting data from version 2. This topic applies if you are using the out-of-the-box BIRT reports, Rational® Common Reporting, or Rational Insight.

Before you begin

Perform the following steps to migrate your version 2 reporting data to the version 3 common data warehouse.

You must perform these steps after upgrading the Jazz™ Team Server and the Quality Management application, but before running the data collection jobs (ETLs) or Data Manager (DM) ETLs in the case of Insight on the upgraded server for the first time.

In a distributed environment, the repotools-jazz commands described below should be run on the Quality Management server.

Procedure

  1. Start the Quality Management server.
  2. If you used Rational Common Reporting or Rational Insight, migrate the version 2 data warehouse by running the repotools-jazz -migrateDatawarehouse schema=/path/to/xdc adminUserId=id adminPassword=id command on the upgraded Quality Management server.

    where schema=/path/to/xdc is the file location of the version 2 Rational Common Reporting XDC configuration file for the data warehouse.

    The default path on Windows for the version 2 XDC configuration file is C:\Program Files\IBM\RQM201\server\cognos\deployment\xdc\Configurations\rqm.xdc. The default path on Unix is /opt/IBM/RQM201/server/cognos/deployment/xdc/Configurations/rqm.xdc. If the file was installed elsewhere, you can find its location by looking up RQM in the ODBC Administrator panel.

    For further details, see -migrateDatawarehouse.

  3. Point your browser to the Quality Management Application Administration page (https://[fully qualified hostname]:9443/jazz/admin) and verify that the Reports > Data Warehouse Connection > Property > Data Collection Jobs Enables setting is set to true. This is required for the data collection jobs to start.
  4. Run the data collection jobs (ETLs) from the administration URL on the Jazz Team Server at https://[host name:port number]/jts/admin. For additional details, see Running the data collection jobs.

    If you use Insight, run the Data Manager (DM) ETLs instead of the data collection jobs. For more information about upgrading with Insight, see Upgrading Insight with Rational Quality Manager.

    If this is the first time you are running the data collection jobs in version 3, and you have a large amount of data, this process can take a significant amount of time.

  5. Migrate the execution trend data by running the repotools-jazz -migrateExecutionTrendData adminUserId=id adminPassword=id command on the Quality Management server. For details, see -migrateExecutionTrendData.

What to do next

After completing these steps, you must update the report templates, and if you are using Rational Common Reporting, update to Rational Reporting for Development Intelligence.

Feedback