Before you start
The goal of this tutorial is to introduce a method for developing mapping models for data warehouse (DWH) projects using the functionality available in InfoSphere Data Architect (IDA), Version 7.5.2. The design of the mappings for the extract, transform, and load (ETL) process is an absolutely critical part of each data warehouse project. This design of mappings should be stored in a format that fulfills several requirements, including the following:
- The mapping can easily be changed.
- Changes can be versioned.
- It is easy to report the mappings.
- It can be exported to other formats.
You will learn in this tutorial how these goals can be reached with IDA. The tutorial builds describes all the necessary steps to build your first mapping model and to create a report for this model. The high-level steps are:
- Create a project in IDA
- Create the source data model (using the DB2 SAMPLE database)
- Create the target data model
- Create mappings between source and target tables
- Analyze your model using the reporting functions
This tutorial describes each of these five steps in detail. At the end, you will have your first meaningful mapping report in PDF style by using the inherited functionality of the IDA tool.
The IBM InfoSphere Data Architect (previously called Rational Data Architect) is an enterprise data modeling and integration design tool that provides a collaborative data design solution that you can use to discover, model, relate, and standardize diverse and distributed data assets.
IDA is based on an open-standard Eclipse integration.
In order to work through this tutorial you need to install the following:
- InfoSphere Data Architect, Version 7.5.2
- IBM DB2 9.7 Enterprise Server Edition with its sample database
- An instance of IBM DB2 Enterprise Edition and the standard sample database installed and accessible on the same computer
See Resources for links to trial versions of both DB2 and IDA.