Preparing the IBM Cognos Data Manager catalog

In the process to integrate IBM® Rational® DOORS® and IBM Rational Insight, you must create a catalog in IBM Cognos® Data Manager to import a package for the Rational DOORS ETL file. ETL is a process for extracting data from a data source, transforming it, and loading into the data warehouse. For this integration, data is extracted from a Rational DOORS database and transformed so that it can provide data for Rational Insight reports.

Before you begin

If you run IBM Rational Reporting Development Tools version 2.0.3.0 on a Windows 7 operating system, you must be logged in as the administrator user. In this procedure, you import a data manager package file that you downloaded in a previous procedure.

Procedure

  1. Open the IBM Cognos Data Manager by clicking Start > All Programs > IBM Rational Reporting Development Tools > IBM Cognos > IBM Cognos Data Manager.
  2. On the Welcome page, either create a catalog or select a catalog to reuse.
    • To create a catalog:
      1. Click File > New Catalog.
      2. In the New Catalog window, type a name, an optional business name, and description for catalog, and then click Next.
      3. In the left pane, click the DB2 connection method, and for the database alias, type RIDW.
      4. Type the user name and password for the IBM DB2® database.
      5. Click Test Connection to verify that the connection is successful.
      6. Click Finish. If the database that you chose already contains a catalog, an error message is displayed.
    • To reuse a catalog, click File > Open Catalog.
  3. Click File > Restore Catalog and choose the OOTBDMCatalog.ctg data manager package file, which is available in the RRDIDevTools Installer folder\datamgr\insight_catalog directory.
  4. Import the CLM data manager package:
    1. In the Data Manager, click File > Import Package.
    2. At the prompt, do not back up the catalog.
    3. Browse to the local directory where you downloaded and extracted the CLM data manager package, as described in Downloading the data manager package. Open the package.
    4. In the Import Package Wizard, select everything in the package and click Next and Finish.
  5. In the Data Manager, under Library > Connections, open Rational Requirements Composer. In the Rational Requirements Composer - Connection Properties window, select ODBC connection details.
  6. From the Data Source Name list, select the data source that is configured for Rational DOORS, as described in Creating a data source that refers to the XDC configuration. Click Test Connection.
  7. In the Data Manager, under Library > Connections, open Rational Data Warehouse. On the Connection Details tab, select Cognos Data Source and then select the RIDW data source, as shown in the next image.
  8. Specify the database alias name (RIDW), user name and password.
    The image shows the Connection Properties window.
  9. Click Test Connection.

What to do next

You can now publish Rational DOORS data to Rational Insight.


Feedback