Manipulating data with the extract, transform, and load (ETL) framework
During the extract, transform, and load (ETL) 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 IBM® Rational® Insight for
returning the result sets for ETL jobs and live reports.
Customizing IBM Rational Insight data warehouse
You can modify the schema, create tables and indexes, and
build relationships between tables. IBM InfoSphere™ Data Architect
is the recommended tool for working with the Rational Insight data warehouse.
Working with Framework Manager projects
Framework Manager
uses the concept of projects. A Framework Manager
project contains objects that you organize according to the business
model
and business rules of your organization.
Preparing for upgrades: Backing up your data
Taking periodic backups of Rational Insight data is a
good practice. Also, taking backups is essential if you are upgrading
your version of Rational Insight.
You can back up the custom settings, and the files, databases, projects,
and catalogs.