Preparing the data sources

The data sources are the product data that is extracted during the extract, transform, and load (ETL) process. To prepare the data sources for the ETL process, you need to define the connections to the data sources.
Before you begin
Determine the type of data that you will use.
  • If you plan to use IBM® Rational® ClearCase®, IBM Rational ClearQuest®, or IBM Rational RequisitePro® as a data source, make sure that you have installed the IBM Rational Insight Data Services on the data services server. For information on installing Rational Insight Data Services, see the Installing and Upgrading topics.
  • If you plan to use IBM Rational Quality Manager as a data source, make sure that you have the Rational Quality Manager web server access location and privilege.
  • If you plan to use IBM Rational Team Concert™ as a data source, make sure that you have the Rational Team Concert repository database access location and privilege.
  • If you plan to use Microsoft® Project as a data source, ensure that you have the XML file and the XML schema of the projects. For information on how to download and save these files, see the Release Notes®.
About this task
To prepare the data sources for the ETL process, define the connections to the data sources.
  1. To define the data source connections for Rational ClearCase, Rational ClearQuest, Rational RequisitePro, Rational Test Manager or Rational Quality Manager, specify the URL of your data service server, and provide authentication information. For more information, see the XML Data Configuration section of the Administering IBM Rational Insight topics (Related links at the bottom of this page).
  2. To define the data source connection for IBM Rational Team Concert, specify the repository database of Rational Team Concert. For more information, see Defining the data source connections (Related links at the bottom of this page).
  3. To define the data source connection for Microsoft Project, specify the path of the Microsoft Project XML files and XML schema. For more information, see the product documentation.

Feedback