Manipulating data with the ETL (extract, transform, and load) framework
During the ETL (extract, transform, and load)
process, data is extracted from various sources, transformed and normalized
through encoded business rules, and then loaded into the fact and
dimension tables of a data mart.
Organizing data with XML data configuration files
The XML data configuration files contain the mapping of
XML data to the table columns of a relational database. The mapping
is used by the XML ODBC driver to provide data in relational form
to the extract, transform, and load framework of Rational® Common Reporting for returning the result sets for ETL jobs
and live reports.
Managing the Rational Integrated Data Warehouse
The data warehouse contains three data storage
areas: the configuration area, the operational data source, and the
data mart. As an administrator, you can monitor, maintain, and back
up the data warehouse.
Backing up your data
Taking periodic backups of Rational Common Reporting data is a good practice. Taking backups is essential if
you are upgrading your version of Rational Common Reporting. You can back up the custom settings, and the files, databases,
projects, and catalogs.