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
- Open the IBM Cognos Data Manager by clicking .
- On the Welcome page, either create a catalog or select a
catalog to reuse.
- To create a catalog:
- Click .
- In the New Catalog window, type a name, an
optional business name, and description for catalog, and then click
Next.
- In the left pane, click the DB2 connection
method, and for the database alias, type
RIDW.
- Type the user name and password for the IBM
DB2® database.
- Click Test Connection to verify that the
connection is successful.
- Click Finish. If the database that you chose
already contains a catalog, an error message is displayed.
- To reuse a catalog, click .
- Click and choose the OOTBDMCatalog.ctg data
manager package file, which is available in the RRDIDevTools
Installer folder\datamgr\insight_catalog directory.
- Import the CLM data manager package:
- In the Data Manager, click .
- At the prompt, do not back up the catalog.
- 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.
- In the Import Package Wizard, select everything in the package and
click Next and
Finish.
- In the Data Manager, under , open Rational Requirements Composer. In the Rational
Requirements Composer - Connection Properties window, select
ODBC connection details.
- 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.
- In the Data Manager, under , 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.
- Specify the database alias name (RIDW), user name and password.
- Click Test Connection.