Skip Headers
Oracle® Fusion Middleware Getting Started with Oracle Data Integrator
11g Release 1 (11.1.1)

Part Number E12641-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

3 Working with the ETL Project

This chapter provides an introduction to the ETL (Extract Transform Load) project that is delivered in the demonstration environment with Oracle Data Integrator Studio.

This chapter includes the following sections:

3.1 The Example Environment

The ETL project is an example to help you understand how to transform and check the integrity of the data in your information systems.

The examples in this getting started guide track sales from various heterogeneous data sources issued from the production systems. Figure 3-1 shows the example environment.

Figure 3-1 Example Environment

Surrounding text describes Figure 3-1 .

The example environment uses the following elements:

3.2 The Data Models

The demonstration environment includes three ODI data models:

This section provides the schema diagrams for these data models.

3.2.1 Orders Application - HSQL

The Orders Application data model is based on the HSQL technology and includes five datastores:

  • SRC_CITY

  • SRC_CUSTOMER

  • SRC_ORDERS

  • SRC_ORDER_LINES

  • SRC_PRODUCT

  • SRC_REGION

Figure 3-2 shows the schema diagram of this data model.

Note that this data model does not enforce any foreign key constraints, even if some functional relations exist between the data.

Figure 3-2 Orders Application Schema Diagram

Surrounding text describes Figure 3-2 .

3.2.2 Parameters - FILE

The Parameters data model is based on the File technology and includes two datastores:

  • SRC_SALES _PERSON

  • SRC_AGE_GROUP

Figure 3-3 shows the schema diagram of this data model.

Figure 3-3 Parameters Schema Diagram

Surrounding text describes Figure 3-3 .

3.2.3 Sales Administration - HSQL

The Sales Administration data model is based on the HSQL technology and includes six datastores:

  • TRG_CITY

  • TRG_COUNTRY

  • TRG_CUSTOMER

  • TRG_PRODUCT

  • TRG_PROD_FAMILY

  • TRG_REGION

  • TRG_SALES

Figure 3-4 shows the schema diagram of this data model.

Figure 3-4 Sales Administration Schema Diagram

Surrounding text describes Figure 3-4 .

3.3 Integration Challenges

The challenges common to all data integration and transformation projects are:

The examples used in this guide illustrate how to address these issues. During this getting started guide, you will learn how to:

Note:

In this guide, we will be looking at processes that focus on ETL. While it is beyond the scope of this document, implementing different integration patterns (real-time, for example) can be carried out in the same fashion. For more information on this, see the Oracle Data Integrator documentation after completing this guide.

Now that you have been introduced to the concepts of the ETL-Project and its components, you can move on to Starting Oracle Data Integrator.