Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Data Integrator (ODI) 12c Developer Course

Name: Oracle Data Integrator (ODI) 12c Developer Course
Rating: 4.2 (1967 reviews)

Created bySanjay Singh

Last updated 4/2022

English

What you'll learn

From basic concepts to advanced level ODI hands-on projects.
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: Security, Topology, Designer, Operator.
Implement practice projects.
Projects covering the ODI Lifecycle 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)
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.
Topology for a File System and Oracle Database connection, Reverse engineering the Models, Mapping to transfer data from files to Oracle database tables.
ODI integration with Big Data
ODI components migration through Smart Export and Smart Import

Course content

18 sections • 74 lectures • 6h 32m total length

Introduction6:03
Welcome!!
The lecture explains what is ODI and why should you learn it.
Why Data Integrator?2:30
Using a real world scenario, this video explains why data integrator is required.
Quiz: ODI Basics

Development Process Flow3:23
This lecture explains the development process flow in ODI. You will understand the components you need to develop.
ODI Data Flow Architecture2:35
This lecture explains

ODI components and how it moves data from source to target
Knowledge Modules
Role of ODI Admin in projects
ODI Repositories2:53
This lecture explains ODI Repository.
Master Repository
Work Repository
Development Repository
Execution Repository
ODI Agents6:22
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
Quiz: Architecture

ODI 12c VM-Introduction4:20
This lecture will explain you ODI 12c Virtual Machine.
Oracle Virtual Box1:41
In this lecture, you will download and install Oracle Virtual box.
7zip download0:06
In this lecture you will understand how and from where to download 7 zip files.
ODI 12c Virtual Appliance6:08
In this lecture, you are going to install ODI12c Virtual Appliance!
https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html
VM Network Configuration3:08
In this lecture, you will enable NAT network on your VM, so that you will be able to connect to the internet through your VM.
Sharing folder between Host Machine and Virtual Machine4:35
This lecture will show you how to share folder between host machine and virtual machine.
Start ODI 12c VM3:32
In this lecture you will go through the steps to start the ODI 12c VM and ODI Studio.

ODI Studio -Introduction2:20
This lecture is introduction to the section on ODI Studio. The lecture explains ODI Studio, it's components and roles using those components.
ODI Studio- Introduction, Model & Mapping6:40
This lecture explains ODI Studio, Models and Mappings
ODI Studio-Procedure2:41
In this lecture you will learn about Procedures in ODI Studio.
ODI Studio-Package5:43
This lecture explains ODI Studio and ODI Package with all the ODI toolboxes in ODI Package.
Quiz: ODI Studio

Project 1: Introduction and Importing Flat Files3:47
In this lecture you will import the flat files SRC_AGE_GROUP and SRC_SALES_PERSON into ODI Repository.
Project1- Lookup4:11
In this lecture, you will understand what is ODI Mapping and Lookup. You will create ODI Mapping and Lookup.
Project1-Join3:50
In this lecture, you will understand what is ODI Join and how to create it,
Project1-Target Expression4:24
In this lecture you will understand what is Target Expression. You will create several target expressions.
Project1-Event Based Target Expression3:14
In this lecture, you will understand and develop event based target expression.
Project1-Knowledge Modules6:27
In this lecture, you will understand the role of Knowledge Modules in mapping and change the Knowledge Modules wherever appropriate.
Quiz: Mapping

Project2-Introduction2:41
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.
Project2-Filter4:24
In this lecture you will implement ODI filter in you project!
Project2-Aggregate6:32
In this lecture, you will incorporate ODI Aggregate feature in your project.
Project2-Knowledge Modules6:19
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.

Data Quality Control- Introduction6:26
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 - Implementation8:11
In this lecture you will implement Condition and Reference type ODI constraints.

Schema Upgrade (optional)0:32
Before you start installing the Standalone agent you should check whether or not the PROD_STB schema needs an upgrade. Go through the steps in this document. If you skip these steps and your schema needs an upgrade you will encounter a CFGFWK-64219 error in the next lecture.
Standalone Agent7:38
In this lecture, you will configure a standalone ODI Agent.
Logical Agent1:07
In this lecture, you will create a logical agent and assign it to a physical standalone agent created in the previous lecture.
Scenario Scheduling4:01
In this lecture, you will schedule the ODI scenario.

Introduction-ODI Variable6:38
Welcome to this lecture on ODI Variables. In this lecture you will learn about ODI Variable and project you are going to work on.
Create FTP Server7:46
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 ODI Variables8:18
In this lecture you will create ODI Variables, Refresh their value and explore ODI Variable History setting.
Create Package with Variable10:03
In this lecture you will create package containing ODI variables.
Variable as Scenario Parameter2:18
In this lecture you will learn how to use ODI variable as parameter to scenario.

Requirements

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

Description

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, Intelligence, Architecture, 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 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 tools with ODI.
The Extract-load-transform(ELT) approach of ODI with a 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. The success of ODI implementation and its performance depends on the 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

Oracle Data Integrator (ODI) 12c Developer Course

What you'll learn

Explore related topics

Course content

Welcome2 lectures • 9min

ODI Architecture4 lectures • 15min

ODI 12c Virtual Box7 lectures • 24min

ODI Studio4 lectures • 17min

Project 1: Customer Data Integration6 lectures • 26min

Project 2- Sales Data Integration4 lectures • 20min

Project3: Data Quality Control2 lectures • 15min

Project 4: Package and Scenario2 lectures • 14min

Scenario Scheduling4 lectures • 13min

Project 5: ODI Variables5 lectures • 35min

Requirements

Description

Who this course is for: