The extract, transform, and load (ETL) catalog contains
the fact tables and dimension tables that define how the data is extracted,
transformed, and delivered to the data warehouse. When you prepare
the ETL catalog for the ETL process, you specify the access information
needed to access the database of the data warehouse and you restore
the sample catalog .
Before you begin
Ensure that you have created an empty database to store the
ETL catalog. For information on how to create databases, see documentation
for the database application that you use.
About this task
To create an ETL catalog:
- Start IBM® Cognos® Data Manager.
- Click .
- Type a name, business name, and description for the catalog
and click Next.
The Business
name and Description fields are optional.
- Specify the details of the empty database that you created
for the catalog and click Finish.
You have created an empty catalog.
The IBM Rational® Insight installation
package contains a sample ETL catalog that you can use to test the
package. In the next optional steps, you can restore the sample ETL
catalog to IBM Cognos Data Manager. Before testing the installation,
verify that all connections specify the data sources that you prepared.
- Optional: Click and select the
sample ETL catalog. The default directory of the catalog file is [INSTALLDIR]/datamgr/RationaInsight_catalog.
- Optional: Expand the ETL catalog node, and
expand the node. The data source connections are listed.
- Optional: To see or change the connection properties
or to test a connection, double-click the connection.