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.
You can then import the CLM data manager package from the local directory
where you downloaded and extracted it, as described in Downloading the data manager package.
- Open the Rational Requirements Composer - Connection
Properties window and 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.
- Click 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.