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
- Change the data source connection:
- Start XML Data Configuration: In a Windows environment,
click .
- Click 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.
- In the XML Data Configuration tree, expand
the elements and double-click the resource group for which you want
to change the connection.
- 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.
- 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.
- 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.
- To save the changes, click the Save icon on the toolbar
or click .
- Disconnect the database:
- Open the DB2 control center by clicking .
- Expand the All Databases folder.
- Right-click the database name, and then click Drop.
- From a command prompt, navigate to C:\Program
Files\IBM\Rational Insight\datawarehouse\dw.
- Type run_install_silent.bat,
and click Enter.
- Run the ETL:
- From the Rational Common Reporting user interface, open dataMovement Tasks folder.
- Under the Actions column, click
the Run with options (
) icon.
- 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.