Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations


* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:
Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe architecture of Oracle Data Integrator
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI

  • Introduction to Integration and Administration

  • Oracle Data Integrator: Introduction
    Oracle Data Integrator Repositories

  • Administering ODI Repositories

  • Create and connect to the Master Repository
    Export and import the Master Repository
    Create, connect, and set a password to the Work Repository

  • ODI Topology Concepts

  • ODI Topology: Overview
    Data Servers and Physical Schemas
    Defining Topology
    Agents in Topology
    Planning a Topology

  • Describing the Physical and Logical Architecture

  • Topology Navigator
    Creating Physical Architecture
    Creating Logical Architecture

  • Setting Up a New ODI Project

  • ODI Projects
    Using Folders
    Understanding Knowledge Modules
    Exporting and Importing Objects
    Using Markers

  • Oracle Data Integrator Model Concepts

  • Understanding the Relational Model
    Understanding Reverse-Engineering
    Creating Models

  • Organizing ODI Models and Creating ODI Datastores

  • Organizing Models
    Creating Datastores
    Constraints in ODI
    Creating Keys and References
    Creating Conditions
    Exploring Your Data
    Constructing Business Rules

  • ODI Mapping Concepts

  • ODI Mappings
    Expressions, Join, Filter, Lookup, Sets, and Others
    Behind the Rules
    Staging Area and Execution Location
    Understanding Knowledge Modules
    Mappings: Overview

  • Designing Mappings

  • Multiple Sources and Joins
    Filtering Data
    Overview of the Flow in ODI Mapping
    Selecting a Staging Area
    Configuring Expressions
    Execution Location
    Selecting a Knowledge Module

  • Mappings: Monitoring and Troubleshooting

  • Monitoring Mappings
    Working with Errors

  • Designing Mappings: Advanced Topics 1

  • Working with Business Rules
    Using Variables
    Datasets and Sets
    Using Sequences

  • Designing Mappings: Advanced Topics 2

  • Partitioning
    Configuring Reusable Mappings
    Using User Functions
    Substitution Methods
    Modifying Knowledge Modules

  • Using ODI Procedures

  • Procedures: Overview
    Creating a Blank Procedure
    Adding Commands
    Adding Options
    Running a Procedure

  • Using ODI Packages

  • Packages: Overview
    Executing a Package
    Review of Package Steps
    Model, Submodel, and Datastore Steps
    Variable Steps
    Controlling the Execution Path

  • Step-by-Step Debugger

  • Starting a Debug Session
    New Functions
    Menu Bar Icons

  • Managing ODI Scenarios

  • Scenarios
    Managing Scenarios
    Preparing for Deployment

  • Using Load Plans

  • What are load plans?
    Load plan editor
    Load plan step sequence
    Defining restart behavior

  • Enforcing Data Quality with ODI

  • Data Quality
    Business Rules for Data Quality
    Enforcing Data Quality with ODI

  • Working with Changed Data Capture

  • CDC with ODI
    CDC implementations with ODI
    CDC implementation techniques
    Results of CDC

  • Advanced ODI Administration

  • Setting Up ODI Security
    Managing ODI Reports
    ODI Integration with Java


This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers.




Students should have incoming skills equivalent to the course(s) below, or should have attended this / these as a prequisite: Oracle 19c Database Administration I (Oracle 19c DBA I)


Length: 3.0 days (24 hours)


Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.