Oracle Data Integrator (ODI) 12c Developer Course
4.4 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Data Integrator (ODI) 12c Developer Course to your Wishlist.

Add to Wishlist

Oracle Data Integrator (ODI) 12c Developer Course

Oracle Data Integrator (ODI) 12c Developer Course
Best Seller
4.4 (35 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
227 students enrolled
Created by Sanjay Singh
Last updated 7/2017
Current price: $10 Original price: $40 Discount: 75% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 4 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Basic concepts i.e. Data, Integration, Information and Intelligence derivation.
  • ODI Development Lifecycle.
  • ODI Architecture. Role of different ODI Components like Repository, Fusion Middleware, Agents.
  • 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), Procedure, Data Quality Controls, Packages, Scenario, Load Plans and other components.
  • 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.
View Curriculum
  • 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 is 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 is the target audience?
  • 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
Compare to Other Oracle Data Integrator Courses
Curriculum For This Course
45 Lectures
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

2 questions
ODI Architecture
4 Lectures 16:01

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
ODI 12c Virtual Box
3 Lectures 12:07

This lecture will explain you ODI 12c Virtual Machine.

Preview 04:20

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

Install ODI12c Virtual Machine (VM)

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.

Preview 03:47

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

Preview 04:11

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

Firs Quiz testing the ODI Development related components

5 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.

Preview 06:32

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

Preview 09:40

In this lecture you will create ODI Scenario.


Quiz to test Package and Scenario concepts

Package and Scenario
1 question
Load Plans
3 Lectures 28:21

In this lecture you will create ODI load plan.

Load Plan Creation

In this lecture you will install and configure Standalone Agent.

Standalone Agent

In this lecture your will execute and monitor a load plan.

Load Plan Execution Monitor
Let's Install your owm ODI
1 Lecture 01:10

It's time to install ODI on your own system. You will get hands-on experience on the ODI architecture we discussed during the introduction to this course.

Also, you will practice the concepts, which you could not practice on VM machine.

Preview 01:10
3 More Sections
About the Instructor
Sanjay Singh
4.3 Average rating
80 Reviews
702 Students
4 Courses
Oracle Certified ODI and BI Implementation Specialist

Hi, I am Sanjay!

I am IIT Bombay graduate with more than two decades of IT experience. You can call me a curious guy with fascination for data integration, analytics and ERP technologies. 

I have led several business transformation projects for Infosys, Toshiba, and Fujitsu across Europe, USA, Canada, and India.

I love teaching IT technologies.I have been teaching to my students, project team mates, customers. My students are working for several Fortune 500 companies.

All my courses are backed by several years of experience on those technologies.

Enjoy the courses. I look forward to wonderful association with you!