Preparing the data sources

The data sources are the product data that is extracted during the 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®, IBM Rational RequisitePro®, or Rational Test Manager as a data source, make sure to have installed the Rational Common Reporting Data Services on the data services server. For information on installing Rational Common ReportingData Services, see the Installing and Upgrading topics.
  • If you plan to use IBM Rational Quality Manager or Rational Common Reporting as a data source, make sure to have the Rational Quality Manager, or Rational Common Reporting Web server access location and privilege.
  • If you plan to use IBM Rational Team Concert™ as a data source, make sure to have the 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.

Procedure

  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 Rational Common Reporting 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. For more information, see the related links on 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