Oracle Data integrator 12c – Developer

Oracle Data Integrator 12c Developer
Intended for Administrators and Developers
Prerequisites None
Duration 3 days
Code EDU_001


Oracle Data Integrator (ODI) is a data integration platform focused on fast bulk data movement and handling complex data transformations. It provides data movement and transformation among enterprise platforms with its open and integrated E-LT architecture and extended support for Big Data.

Oracle Data Integrator’s E-LT architecture generates native code for different RDBMS or big data engines. The E-LT architecture extracts data from the sources, loads it into a target, and executes transformations using the power of the database or Hadoop.

In ODI 12c, Oracle has introduced a feature that they call Declarative Flow-Based User Interface. What it basically means is that we can now create data flows (Interfaces were re-named to Mappings in new ODI) that combine the two approaches:

  • Visual approach of Mappings and Operators that is well known from Oracle Warehouse Builder
  • Powerful declarative design approach from Oracle Data Integrator

With this new paradigm you essentially get the best of both worlds: ease of visual data flow development and the power of the declarative design approach.

Who is the target audience?

  • Developers and data analysts
  • Private company employees
  • Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
  • Data Scientists
  • Those who wants to learn ODI product and develop themselves in this subject


What Will You Learn?

  • Understand ODI Architecture and philosophy of the tool
  • Develop ODI mappings
  • Develop and design all kind of ODI jobs – Packages, Schedules, etc…
  • Understand Knowledge Module structures
  • Create Topology and understand installation logic
  • Step by Step ODI 12C Components and Structures
  • Load Tables with different Knowledge Modules


Required Prerequisites

  • Basic knowledge of ELT/ETL data processing



Architecture and basics

Overview of ODI Architecture

Overview of ODI Components

About Graphical Modules

Types of ODI Agents

Overview of Oracle Data Integrator Repositories

Overview of ODI Topology with exercises to set up ODI environment



  • Creating datastores
  • Reverse engineer datastores
  • Business rules on datastores


ODI Basic Mapping Concepts

  • What is a Mapping?
  • Business Rules for Mapping
  • Basics – What is a Mapping, a Filter and a Join?
  • Overview of Integration Process
  • What is a Staging Area?
  • Mapping with Knowledge Modules (KM)
  • Simple mappings – Exercises


Advanced Usage of ODI Mappings

Designing Mappings

  • Designing a Mapping
  • Multiple Source Data stores
  • Creating Joins
  • Filtering Data
  • Overview of the Flow
  • Using variables in mappings
  • Specifying the Staging Area
  • Selecting Knowledge Modules
  • Text files as sources


Mappings, Basics, Monitoring and Debugging

  • Monitoring Mappings
  • Viewing Sessions and Tasks
  • How to Monitor Execution of a Mapping
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Tips for Preventing Errors


Mapping – Advanced topics

  • Mapping with Business Rules
  • Overview of Business Rule Elements
  • Creating and Tracking Variables
  • Reusable Mappings
  • Creating Aggregates and facts
  • Using all mapping operators in various exercises


Data flow orchestration – Packages, Procedures, Scenarios and Load plans


  • Introduction and how to use packages
  • Overview of element palette
  • Exercises using different elements in packages



  • Concept of ODI procedures
  • Source and target execution
  • Exercises involving procedure usage


Managing ODI Scenarios and Versions

  • What is a Scenario?
  • Managing Scenarios with Load Plans
  • Scheduling the ODI Scenario
  • Overview of ODI version management


Using Load Plans

  • What Are Load Plans?
  • Load Plan Editor
  • Load Plan Steps
  • Defining the Restart Behavior
  • Benefits of Using Load Plans


Advanced topics

  • Groovy scripting
  • Developing knowledge modules
  • Big data and ODI
  • Introduction to ODI Security