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.