Next >

Customizing the extract, transform, and load (ETL) process

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:

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:

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.
Next >

Feedback