IBM Support

Migrating the RTC Data Warehouse to a different database vendor

Question & Answer


Question

Can you migrate the IBM Rational Team Concert (RTC) Data Warehouse (DW) database to a different database vendor?

Cause

Some deployments will move the application database between database vendors and require this ability for the Data Warehouse database as well.

Answer

There is currently no support for moving existing Data Warehouse data between database vendors.

There may be other vendor specific database tools available. IBM cannot provide any guidance on such tools and your database vendor should be contacted with any issues.

Workaround:

It is possible to discard the Data Warehouse and rebuild it in the new location. On the first run of the data collection jobs the new Data Warehouse will be populated.

Note: Because the ETL rebuild process will only process data that is up to two years old, information such as trend metrics older than two years will be lost. All the data in the STAR schema, and deleted build results will be lost as well.

There will not be any impact to the CCM out of the box reports. However, because the RQM reports rely on data collected by STAR Java ETL task RQM users will be affected.

Leverage the Jazz Community

Jazz and Rational Team Concert have an active community that can provide you with additional resources. Browse and contribute to the User forums, contribute to the Team Blog and review the Team wiki.
Refer to technote 1319600 for details and links.

[{"Product":{"code":"SSUVV6","label":"IBM Engineering Test Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Reports","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"3.0.1;4.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSUC3U","label":"IBM Engineering Workflow Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Repository","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"},{"code":"PF002","label":"AIX"}],"Version":"2.0;2.0.0.1;2.0.0.2;3.0;3.0.1;3.0.1.1;3.0.1.2;3.0.1.3;4.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSWMEQ","label":"Rational Requirements Composer"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Reporting","Platform":[{"code":"","label":""}],"Version":"3.0.1;4.0","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Product Synonym

Rational Team Concert;Rational Quality Manager

Document Information

Modified date:
16 June 2018

UID

swg21596750