Changing the data source connections (RQM Specific)

If you want to change the Rational® Common Reporting data source connections, you must first flush the contents of the Data Warehouse to avoid any unexpected behavior. Then, you must run the ETL task in order to populate the Data Warehouse with the contents of the new server.

About this task

To point the data source to a different server, perform the following steps:

Procedure

  1. Change the data source connection:
    1. Start XML Data Configuration: In a Windows environment, click Start > Programs > Rational Common Reporting > XML Data Configuration.
    2. Click File > Open Configuration and select the XML data configuration file for the data source.
      Note: The default locations of the data configuration files are [insight_installation_directory]/dataconfig/configs/Configurations and [insight_installation_directory]/dataconfig/configs/live data config.
    3. In the XML Data Configuration tree, expand the elements and double-click the resource group for which you want to change the connection.
    4. Type the URL of the data source in the URL field.

      For a Common Reporting Data Service data source, the default URL is https://server:port.

    5. Enter the Relative path for the Rational Quality Manager Project in the Relative path field. The default project is /jazz/secure/service/com.ibm.rqm.integration.service.IIntegrationService/resources/Quality+Manager, where Quality+Manager is the name of your project.
      Note: Both the data source and the relative path must be configured.
    6. Specify the type of authentication:
      • If authentication is not needed to access the resource group, select None.
      • If authentication is needed to access the resource group, select Basic or Form and specify the user name and password to use for the authentication.
      Note: Make sure the data source itself is also configured to use authentication. For example, Rational Quality Manager must be configured to use form-based authentication.
    7. To save the changes, click the Save icon on the toolbar or click File > Save.
  2. Disconnect the database:
    1. Open the DB2 control center by clicking Start > All Programs > IBM DB2 > DB2COPY1 (default) > General Administration Tools > Control Center.
    2. Expand the All Databases folder.
    3. Right-click the database name, and then click Drop.
    4. From a command prompt, navigate to C:\Program Files\IBM\Rational Insight\datawarehouse\dw.
    5. Type run_install_silent.bat, and click Enter.
  3. Run the ETL:
    1. From the Rational Common Reporting user interface, open dataMovement Tasks folder.
    2. Under the Actions column, click the Run with options (Run) icon.
    3. On the Run with options page, click Run, and then click OK to run the rqmall data movement.

Results

The data source is changed and the data warehouse is now populated with the artifacts from the new server.

Feedback