In this tutorial, you will use the strong reporting integration
between IBM® Rational® Insight and the IBM Rational product
repositories to create ETL builds for customized data schemas.
Extract, Transform, and Load (ETL) is a process that involves
extracting data from product source as an XML resource, transforming
it through encoded business rules to fit business needs, and loading
it into the data warehouse from where reports are generated. You can
customize the ETL jobs to suit your specific business requirements.
Learning objectives
In this tutorial,
you will learn how to:
- Customize an XML data configuration file
- Modify an existing Data Manager build
- Create a new Data Manager build
- Customize the default schema of the data warehouse
- Customize the default ETL catalog
- Customize the default Framework Manager model
Time required
The three lessons of module
1 should each take approximately 20 minutes to complete. Lessons 1
and 3 of module 2 should take approximately 20 minutes; lesson 2 of
the module should take approximately 60 minutes.
If you explore
the concepts related to this tutorial, it could take longer to complete.
Skill level
Advanced
Audience
The tutorial is intended for
ETL developers.
System requirements
The default
installation of the following software is required for this module:
- IBM Rational ClearQuest®
- IBM Rational Insight Data Services
- IBM Rational Insight
- IBM InfoSphere™ Data Architect
In one of the lessons in this tutorial, you need to use the
Framework Manager and Data Manager components of IBM Rational Insight.
These components can be used only in a Windows® environment.
In this tutorial,
you will use a customized Enterprise ClearQuest schema. You can download a
sample Rational ClearQuest database set here.
To deploy the sample ClearQuest database,
see Preparation: Setting up the sample database.
In
this tutorial, you will use the physical database models that are
can be when installing IBM Rational Insight. The default
location of the sample model is C:/Program Files/IBM/Rational
Insight/datawarehouse/dw.
Expected results
At the end of this
tutorial, you should understand how to load customized data on the
data warehouse and to configure a data mart.