Configuring the report development tools

Windows To use the developer system for accessing the IBM® Rational® Insight data warehouse, catalog the data warehouse and configure the data sources of the data warehouse and products.
About this task
To configure the Rational Insight database catalog and the Rational Insight models:
  1. Catalog the Rational Insight data warehouse.
    • If the database is not installed locally, to enable Data Manager to store the catalogs in a database, create a database with an alias.
    • If the database is installed locally, create a database.
    1. Start the Data Manager program.
    2. Click File > New Catalog.
    3. In the Name field, enter RIETL and click Next.
    4. In the Database alias field, enter RICAT and click Next.
    5. Enter the user name and password of the database administrator.
    6. Click Finish.
    7. Click File > Restore Catalog and select [rational_insight_installation_directory]\datamgr\insight_catalog\OOTBDMCatalog.ctg.
  2. Modify the XML Data Configuration file for URLs and authentication.
    1. Start XML Data Configuration (Click Start > All Programs > IBM Rational Insight > XML Data Configuration).
    2. Click File > Open Configuration and select the XML data configuration file for the product source.
    3. Expand the XML Data Configuration node to locate the resource group from where you want to extract data. Double-click the resource group
    4. Change the URL to match the data service server deployed in your environment.
    5. Change the authentication type, and the user name and password to match the authentication configured in your data service server.
    6. Click File > Save.
      Note: Repeat steps c to f for all the product sources you are using.
    7. Close XML Data Configuration.
  3. Configure the data sources to run the ETL jobs.
    Note: The installer does not create the connections for Rational Team Concert™ and Rational Data Warehouse. You need to configure these data sources manually.
    1. Start IBM Cognos® Data Manager.
    2. Select RIETL > Library > Connections > Data source, where Data source is Rational Team Concert or Rational Data Warehouse.
    3. Double-click Data source
    4. Click Connection Details.
    5. Change the connection details to match the repository database deployed in your environment.
      Note: Make sure the snapshots in Rational Team Concert contain data.
    6. Click the Test Connection button to verify that the connection is working.
    7. Repeat these steps for the other data source.
  4. Run the ETL jobs.
    1. Start IBM Cognos Data Manager.
    2. Select RIETL > Builds and JobStreams > Jobs > RationalProductJobs. For example, CQJobs, CCJobs.
    3. Right-click RationalProductJobs, and click Execute.
    4. Click OK. A window shows the status of the job.

Feedback