• Oracle Data Integrator 
    Training Curriculum

    For Administrators and Developers

  • Check out our blog

  • Goals

    • Describe architecture of Oracle Data Integrator 
    • Apply ODI Topology concepts for data integration
    • Describe ODI Model concepts
    • Design ODI Interfaces, Procedures, and Packages to perform ELT data transformations
    • Explore, audit data, and enforce data quality with ODI
    • Administer ODI resources and setup security with ODI
    • Implement Changed Data Capture with ODI
    • Use ODI Web services and perform integration of ODI with SOA
  • Details

    1. Introduction

    • What is Oracle Data Integrator?
    • Why Oracle Data Integrator?
    • Overview of ODI 11g Architecture
    • Overview of ODI 11g Components
    • About Graphical Modules
    • Types of ODI Agents
    • Overview of Oracle Data Integrator Repositories

    2. Repositories and Agents : Administration and Setup

    • Administrating the ODI Repositories
    • Creating Repository Storage Spaces
    • Creating and Connecting to the Master Repository
    • Creating and Connecting to the Work Repository
    • Managing ODI Agents
    • Creating a Physical Agent
    • Launching a Listener, Scheduler and Web Agent
    • Example of Load Balancing

    3. Topology: Overview and Concepts

    • Overview of ODI Topology
    • About Data Servers and Physical Schema
    • Defining the Physical Architecture
    • Defining the Logical Architecture
    • Mapping Logical and Physical Resources
    • Defining Agents
    • Defining a Topology
    • Planning the Topology

    4. Topology: Physical and Logical Architecture

    • Overview of Topology Manager
    • Creating Physical Architecture
    • Creating a Data Server
    • Testing a Data Server Connection
    • Creating a Physical Schema
    • Creating Logical Architecture
    • Overview of Logical Architecture and Context Views
    • Linking the Logical and Physical Architecture

    5. Designer: Projects and Folders

    • Overview of ODI Projects
    • Creating a New Project 
    • Using Folders
    • Organizing Projects and Folders
    • Understanding Knowledge Modules
    • Exchanging ODI Objects
    • Exporting and Importing Objects
    • Using Markers

    6. Designer: Model Concepts

    • What is a Model?
    • Understanding Metadata in ODI
    • Understanding Reverse Engineering
    • Creating Models
    • Organizing Models
    • Creating Data stores
    • Using Constraints in ODI
    • Creating Keys and References

    7. Designer: Interface Concepts

    • What is an Interface?
    • Business Rules for Interfaces
    • What is a Mapping, Filter, Join?
    • Overview of Integration Process
    • What is a Staging Area?
    • About Execution Location
    • Using Knowledge Modules with ODI Interface
    • Creating a Basic Interface

    8. Designer: Designing Interfaces

    • Designing an Interface
    • Multiple Source Data stores
    • Creating Joins
    • Filtering data
    • Disabling Transformations
    • Overview of the Flow
    • Specifying the Staging Area
    • Selecting Knowledge Modules

    9. Operator: Monitoring and Debugging

    • Monitoring Interfaces
    • Using Operator
    • Viewing Sessions and Tasks
    • How to Monitor Execution of an Interface
    • How to Troubleshoot a Session
    • Keys to Reviewing the Generated Code
    • Working with Errors
    • Tips for Preventing Errors

    10. Designer: Advanced Topics - Interfaces

    • Using Business Rules in Interfaces
    • Overview of Business Rule Elements
    • Using variables
    • Using User Functions
    • Using Substitution Methods
    • Modifying a KM
    • Developing Your Own KM
    • Using RKM for Customized Reverse Engineering

    11. Designer: Procedures

    • What is a Procedure?
    • Examples of Procedures
    • Creating Procedures
    • Adding Commands
    • Adding Options
    • Running a Procedure
    • Using Operator to View Results

    12. Designer: Packages

    • What is a package?
    • Creating a package
    • Executing a package
    • Creating Advanced Packages
    • Error handling
    • Controlling an Execution Path
    • Creating a Loop
    • Using the Advanced tab

    13. Operator: Scenarios and Versions

    • What is a Scenario?
    • Managing Scenarios
    • Preparing Scenarios for Deployment 
    • Automating Scenario Management 
    • Scheduling the ODI Scenario
    • Overview of ODI version management 
    • Using Version Browser and Version Comparison Tool
    • Handling concurrent changes
    • Designing and creating load plans

    14. Designer: Data Quality and Auditing Data

    • Why Data Quality?
    • When to Enforce Data Quality?
    • Data Quality in Source Applications
    • Data Quality Control in the Integration Process
    • Data Quality in the Target Applications
    • Enforcing Data Quality
    • Exploring Your Data
    • Auditing Data Quality

    15. Changed Data Capture (Optional)

    • Overview of ODI version management 
    • Techniques of Changed Data Capture
    • Changed Data Capture in ODI
    • CDC Strategies and Infrastructure
    • CDC Consistency
    • Using CDC
    • Viewing Data/Changed data
    • Using Journalizing

    16. Administration: Advanced Topics

    • Using Open Tools
    • Installing Open Tools
    • Using Open Tools in a Package
    • Using Open Tools in a Procedure or in a KM
    • Developing Your Own Open Tools
    • Setting Up ODI Security
    • Defining Security Policies
    • Defining Password Policies
    • Automating tasks using SDK
  • Contact Us

    For Availability, Pricing and Customization options