Oracle Data Integrator (ODI) 12c Developer Course
4.0 (677 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,452 students enrolled

Oracle Data Integrator (ODI) 12c Developer Course

Oracle Data Integrator (ODI) 12c Developer Course
4.0 (677 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
2,452 students enrolled
Created by Sanjay Singh
Last updated 8/2020
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 7.5 hours on-demand video
  • 3 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • From basic concepts to advance level ODI knowledge with hands-on practice
  • ODI Development Lifecycle from real life OID implementation projects.
  • ODI Architecture. Role of different ODI Components like Repository, Fusion Middleware, Agents. Data, Integration, Information and Intelligence derivation.
  • ODI 12c Virtual Machine installation.
  • ODI Studio and it's components i.e. Security, Topology, Designer, Operator. Take a deeper dive on Designer and understand how to develop Models, Projects, Mapping, Procedures, Knowledge Modules, Packages and Scenarios in ODI studio. Various ODI toolboxes available during package development is also explained.
  • Implement practice projects.
  • Projects cover the ODI Lifecycle components i.e. Models, Mapping ( with transformation like Lookup, Filters, Joins, Aggregates, Knowledge Modules), Variable, Procedure, Data Quality Controls, Packages, Scenario, Complex Files, Load Plans and other components.
  • Integration between Complex file (with XML Schema) and RDBMS.
  • Customization of built-in knowledge module and development of new knowledge modules.
  • Real time integration through Changed Data Capture (CDC) and Journalizing (JKM)
  • Install ODI with all its components i.e. JDK, Repository, ODI Domain, Weblogic Server, Node Manager, Standalone Colocated Agent, and JEE Agent on you own machine.
  • Execute project on ODI installed on your own machine.
  • Project covers Setting up Topology for a File System and Oracle Database connection, Reverse engineering the Models, Creating Mapping to transfer data from files to Oracle database tables.
  • ODI integration with Big Data
  • You should be able to use a PC
  • You should be able to work on operating systems like Windows
  • You should know how to use browser and such operating system tools
  • You should have basic knowledge of SQL and relational database

Join the most comprehensive and popular Oracle Data Integrator (ODI) 12c Developer Course on Udemy, because now is the time to get started!

From basic concepts about Data Integration, IntelligenceArchitecture, ODI  Components, Project Development to Migration and Support, this course covers it all you need to know to become a successful ODI Developer

But that's not all! Along with covering all the steps of ODI developer functions, this course also has quizzes and projects, which allow you to practice the things learned throughout the course!

You'll not only learn about the concepts, but also practice each of those concepts through Projects.

And if you do get stuck, you benefit from an extremely fast and friendly support - both via direct messaging or discussion. You have my word!

With more than two decades of IT experience, I have designed this course for students and professionals who wish to master how to develop and support industry standard batch integration in Oracle Data Integrator.

This course will be kept up-to-date to ensure you don't miss out on any changes once ODI 12c is required in your project!

Why ODI?

Oracle Data Integrator (ODI) is the integration tool every enterprise need. The key technical capabilities like

  • Extract-Load-Transform (ELT) approach, 
  • Near real time data integration capability through Change Data Capture(CDC), 
  • Declarative design with fully modifiable Knowledge Modules, 
  • SOA capable through web-services
  • Integration of structured as well as unstructured data

exists only in ODI. It's Oracle's flagship, High-performance bulk data movement and transformation tool. Oracle is investing a lot in this tool.

  • ODI is a built-in batch integration tool for Oracle BI Apps 11g onwards. The current Oracle BI Apps customers will have to replace their existing ETL tool with ODI.
  • The Extract-load-transform(ELT) approach of ODI with knowledge module based modular approach makes it the most complete and scalable batch integration tool.

If you are looking for a thriving career in data integration and analytics, this is the right time to learn ODI.

Get a very deep understanding of ODI Developer activities

Every new ODI version is coming with added features. Success of ODI implementation and its performance depends on  ODI developer. 

Pay once, benefit a lifetime! This is an evolving course! ODI12c development and later future versions will  be covered in this course.  You won’t lose out on anything! Don’t lose any time, gain an edge and start now!

Who this course is for:
  • This course is for aspirants who wants to become ODI developer
  • Manager who wants to understand ODI development
  • Project Managers who wants to understand and plan ODI development
Course content
Expand all 78 lectures 07:29:14
+ Welcome
3 lectures 16:13


The lecture explains what is ODI and why should you learn it.

Preview 06:03

This lecture explains what is data, information, and intelligence and how intelligence is derived out of raw data.

Data to Intelligence and role of Data Integrator

 Using a real world scenario, this video explains why data integrator is required.

Why Data Integrator?

First Quiz to test ODI concepts

Quiz: ODI Basics
3 questions
+ ODI Architecture
4 lectures 15:13

This lecture explains the development process flow in ODI. You will understand the components you need to develop.

Preview 03:23

This lecture explains 

  • ODI components and how it moves data from source to target
  • Knowledge Modules
  • Role of ODI Admin in projects
ODI Data Flow Architecture

This lecture explains ODI Repository.

  • Master Repository
  • Work Repository
  • Development Repository
  • Execution Repository
ODI Repositories

In this lecture you will learn about ODI Agents.

  • Role of ODI Agent
  • Type of ODI Agents -> Standalone, JEE, Colocated
  • Architecture
  • Compare and contrast between these agents
ODI Agents

Test your knowledge of ODI Architecture.

Quiz: Architecture
2 questions
+ ODI 12c Virtual Box
6 lectures 17:06

This lecture will explain you ODI 12c Virtual Machine.

ODI 12c VM-Introduction

In this lecture you will understand how and from where to download 7 zip files.

7zip download

This lecture talks about changes to ODI12c VM since recording of lecture 9.

Changes to ODI12c VM

This lecture explains how to install ODI 12c Virtual Machine (VM).

Install ODI12c Virtual Machine (VM)

This lecture will show you how to share folder between host machine and virtual machine.

Sharing folder between Host Machine and Virtual Machine

In this lecture you will go through the steps to start the ODI 12c VM and ODI Studio.

Start ODI 12c VM
+ ODI Studio
4 lectures 17:24

This lecture is introduction to the section on ODI Studio. The lecture explains ODI Studio, it's components and roles using those components.

Preview 02:20

This lecture explains ODI Studio, Models and Mappings

ODI Studio- Introduction, Model & Mapping

In this lecture you will learn about Procedures in ODI Studio.

ODI Studio-Procedure

This lecture explains ODI Studio and ODI Package with all the ODI toolboxes in ODI Package.

ODI Studio-Package

ODI Quiz testing ODI Concepts

Quiz: ODI Studio
4 questions
+ Project 1: Customer Data Integration
6 lectures 25:53

In this lecture you will import the flat files SRC_AGE_GROUP and SRC_SALES_PERSON into ODI Repository.

Project 1: Introduction and Importing Flat Files

In this lecture, you will understand what is ODI Mapping and Lookup. You will create ODI Mapping and Lookup.

Project1- Lookup

In this lecture, you will understand what is ODI Join and how to create it,


In this lecture you will understand what is Target Expression. You will create several target expressions.

Project1-Target Expression

In this lecture, you will understand and develop event based target expression.

Project1-Event Based Target Expression

In this lecture, you will understand the role of Knowledge Modules in mapping and change the Knowledge Modules wherever appropriate.

Project1-Knowledge Modules

Test your knowledge of Mapping and it's components like Filters, Lookups, Aggregates, Knowledge Modules and others.

Quiz: Mapping
6 questions
+ Project 2- Sales Data Integration
4 lectures 19:56

Welcome to your second project on ODI! In this project you are going to create  Sales Administration data mart which will have sales quantity and amount summarized by customer and product.

Preview 02:41

In this lecture you will implement ODI filter in you project!


In this lecture, you will incorporate ODI Aggregate feature in your project.


In this lecture your will review the Knowledge Modules, how data flows through knowledge modules and how to select appropriate knowledge module in your mapping.

Project2-Knowledge Modules
+ Project3: Data Quality Control
2 lectures 14:37

This lecture explains Data Quality Controls and how they are implemented in ODI. You will understand how to implement data quality control through ODI Constraints like Static Control and Flow Control.

You will understand business requirements behind the project you are going to implement in this section.

Data Quality Control- Introduction

In this lecture you will implement Condition and Reference type ODI constraints.

Data Quality Control - Implementation
+ Project 4: Package and Scenario
2 lectures 13:50

In this lecture you will create ODI Package


In this lecture you will create ODI Scenario.


Quiz to test Package and Scenario concepts

Package and Scenario
2 questions
+ Project 5: ODI Variables
5 lectures 35:03

Welcome to this lecture on ODI Variables. In this lecture you will learn about ODI Variable and project you are going to work on.

Preview 06:38

This is optional lecture. This lecture will explain you how to install FTP server. You need to go through lecture in case you do not have a ftp server.

Create FTP Server

In this lecture you will create ODI Variables, Refresh their value and explore ODI Variable History setting.

Create ODI Variables

In this lecture you will create package containing ODI variables.

Create Package with Variable

In this lecture you will learn how to use ODI variable as parameter to scenario.

Variable as Scenario Parameter
+ Project 6: Complex File
7 lectures 36:32

Welcome to this project, where you will import complex file in ODI. This lecture will take you through a sample complex file and explain you how it is structured. The file contains different sections with data involving different delimiters, terminators, and surrounding characters.

This is going to be a very interesting project!

Preview 04:13

In this lecture you will understand how data flows from complex file to ODI data stores. You will understand how data flows from complex file to XM File, XML schema, Relational table and eventually into ODI data store through reverse engineering.

Data flow from complex file to data store

In this lecture you will define the XML Schema (XSD) , which will convert the complex file in XML file with XML tags.

XML Schema Definition (XSD)

In this lecture you will create Physical and Logical ODI Schema for the XML Schema.

Physical and Logical Schemas

This lecture shows how to unhide a technology in Topology.

How to Unhide Technology in Topology

In this lecture you will create ODI Model and reverse engineer the XML schema tables into that model. You will review  hierarchy and relationships among imported tables.

Reverse Engineer XML Schema Tables

In this lecture you will review data in ODI Data stores from Complex file.

Review Model Data