Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Oracle Data Integrator Overview

• 1.1 Introduction to Oracle Data Integrator
  • 1.1.1 The Business Problem
  • 1.1.2 A Unique Solution
• 1.2 ODI Component Architecture
  • 1.2.1 Repositories
  • 1.2.2 ODI Studio and User Interfaces
  • 1.2.3 Run-Time Agent
  • 1.2.4 Oracle Data Integrator Console
• 1.3 Get Started with Oracle Data Integrator

2 Installing Oracle Data Integrator and the Demonstration Environment

• 2.1 Preparing to Install
  • 2.1.1 Review System Requirements and Certification
  • 2.1.2 Understand Oracle Fusion Middleware Support of 64-bit JDK
  • 2.1.3 Create ODI Repositories
• 2.2 Installing Oracle Data Integrator
  • 2.2.1 Downloading the Installer and the Demo Environment
  • 2.2.2 Starting the Installer
  • 2.2.3 Installation Types
  • 2.2.4 Installation Instructions
• 2.3 Installing the Demonstration Environment

3 Working with the ETL Project

• 3.1 The Example Environment
• 3.2 The Data Models
  • 3.2.1 Orders Application - HSQL
  • 3.2.2 Parameters - FILE
  • 3.2.3 Sales Administration - HSQL
• 3.3 Integration Challenges

4 Starting Oracle Data Integrator

• 4.1 Starting the Demonstration Environment
• 4.2 Starting Oracle Data Integrator Studio
  • 4.2.1 Starting ODI Studio
  • 4.2.2 Defining a new Getting Started Login
• 4.3 Introduction to Using the ODI Navigators
  • 4.3.1 Designer Navigator
  • 4.3.2 Operator Navigator

5 Implementing Data Quality Control

• 5.1 Introduction to Data Integrity Control
• 5.2 SRC_CUSTOMER Control Example
  • 5.2.1 Objective
  • 5.2.2 Interpreting the Problem
  • 5.2.3 Creating Constraints
    • 5.2.3.1 Age Constraint
    • 5.2.3.2 Reference Constraint
  • 5.2.4 Run the Static Control
  • 5.2.5 Follow the Execution of the Control in Operator Navigator
  • 5.2.6 Interpreting the Results in Operator Navigator
    • 5.2.6.1 Determining the Number of Invalid Records
    • 5.2.6.2 Reviewing the Invalid Records

6 Working with Integration Interfaces

• 6.1 Pop. TRG_CUSTOMER Interface Example
  • 6.1.1 Purpose and Integration Requirements
  • 6.1.2 Interface Definition
  • 6.1.3 Creating the Integration Interface
    • 6.1.3.1 Insert a New Integration Interface
    • 6.1.3.2 Define the Target Datastore
    • 6.1.3.3 Define the Source Datastores
    • 6.1.3.4 Define the Lookup Table
    • 6.1.3.5 Define the Join between the Source Datastores
    • 6.1.3.6 Define the Mappings
    • 6.1.3.7 Define the Data Loading Strategies (LKM)
    • 6.1.3.8 Define the Data Integration Strategies (IKM)
    • 6.1.3.9 Define the Data Control Strategy
• 6.2 Pop. TRG_SALES Interface Example
  • 6.2.1 Purpose and Integration Requirements
  • 6.2.2 Interface Definition
  • 6.2.3 Creating the Integration Interface
    • 6.2.3.1 Insert a New Integration Interface
    • 6.2.3.2 Define the Target Datastore
    • 6.2.3.3 Define the Source Datastores
    • 6.2.3.4 Define Joins between the Source Datastores
    • 6.2.3.5 Define the Order Filter
    • 6.2.3.6 Define the Transformation Rules
    • 6.2.3.7 Define the Data Loading Strategies (LKM)
    • 6.2.3.8 Define the Data Integration Strategies (IKM)
    • 6.2.3.9 Define the Data Control Strategy

7 Working with Packages

• 7.1 Introduction
  • 7.1.1 Automating Data Integration Flows
  • 7.1.2 Packages
    • 7.1.2.1 Scenarios
• 7.2 Load Sales Administration Package Example
  • 7.2.1 Purpose
  • 7.2.2 Developments Provided with Oracle Data Integrator
  • 7.2.3 Problem Analysis
  • 7.2.4 Creating the Package
    • 7.2.4.1 Create a New Package
    • 7.2.4.2 Insert the Steps in the Package
    • 7.2.4.3 Define the Sequence of Steps in the Package

8 Executing Your Developments and Reviewing the Results

• 8.1 Executing the Load Sales Administration Package
  • 8.1.1 Run the Package
  • 8.1.2 Follow the Execution of the Package in Operator Navigator
  • 8.1.3 Interpreting the Results of the Pop. TRG_CUSTOMER Session Step
    • 8.1.3.1 Determining the Number of Processed Records
    • 8.1.3.2 Viewing the Resulting Data
    • 8.1.3.3 Reviewing the Invalid Records and Incorrect Data
    • 8.1.3.4 Correcting Invalid Data
    • 8.1.3.5 Review the Processed Records
• 8.2 Executing the Pop. TRG_SALES Interface
  • 8.2.1 Execute the Integration Interface
  • 8.2.2 Follow the Execution of the Interface in Operator Navigator
  • 8.2.3 Interpreting the Results
    • 8.2.3.1 Determining the Number of Processed Records
    • 8.2.3.2 Viewing the Resulting Data
    • 8.2.3.3 Reviewing the Invalid Records and Incorrect Data

9 Deploying Integrated Applications

• 9.1 Introduction
• 9.2 Scenario Creation
• 9.3 Run the Scenario
  • 9.3.1 Executing a Scenario from ODI Studio
• 9.4 Follow the Execution of the Scenario

10 Going Further with Oracle Data Integrator

• 10.1 Summary
• 10.2 What else can you do with Oracle Data Integrator?
• 10.3 Learn More