
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:
- 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.
- Start the Data Manager program.
- Click .
- In the Name field, enter RIETL and
click Next.
- In the Database alias field, enter RICAT and
click Next.
- Enter the user name and password of the database administrator.
- Click Finish.
- Click and select [rational_insight_installation_directory]\datamgr\insight_catalog\OOTBDMCatalog.ctg.
- Modify the XML Data Configuration file for URLs and authentication.
- Start XML Data Configuration (Click ).
- Click and select the XML data configuration
file for the product source.
- Expand the XML Data Configuration node
to locate the resource group from where you want to extract data.
Double-click the resource group
- Change the URL to match the data service server deployed
in your environment.
- Change the authentication type, and the user name and
password to match the authentication configured in your data service
server.
- Click .
Note: Repeat steps c to f for
all the product sources you are using.
- Close XML Data Configuration.
- 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.
- Start IBM Cognos® Data Manager.
- Select ,
where Data source is Rational Team Concert or Rational Data Warehouse.
- Double-click Data source
- Click Connection Details.
- Change the connection details to match the repository
database deployed in your environment.
Note: Make sure
the snapshots in Rational
Team Concert contain data.
- Click the Test Connection button
to verify that the connection is working.
- Repeat these steps for the other data source.
- Run the ETL jobs.
- Start IBM Cognos Data Manager.
- Select . For example, CQJobs, CCJobs.
- Right-click RationalProductJobs,
and click Execute.
- Click OK. A window shows the
status of the job.