3.5 out of 5
65 reviews on Udemy

Oracle Data Integrator (ODI) 12c Admin Course

ODI 12c Admin Course-Architecture, Enterprise Installation, Maintenance, and Support
Sanjay Singh
751 students enrolled
ODI Architecture and significance of each component.
Integration and data flow architecture in ODI.
Oracle Fusion Middleware, WebLogic Domain, Directory structure.
Enterprise installation. Install each component JDK, Repositoy, Fusion Middleware, Web Logic Server, Agents.
Start Node Manager, Weblogic Admin Server, Managed Server, Standalone Colocated Agent and JEE Agent.
Operational Activities for ODI Admin -> Topology maintenance, ODI user maintenance.

Join the most comprehensive and popular ODI Admin Course on Udemy, because now is the time to get started!

From Architecture, Installation, Agents, Topology, Security to Project Execution this course covers it all you need to know to become a successful ODI Admin

You’ll learn all about Architecture, ODI ComponentsRepositoriesDomainsFusion MiddlewareWebLogic Server, Topology, – and in the end: You’ll will have a project to ensure all the components are installed and configured properly!

But that’s not all! Along with covering all the steps for ODI  Admin functions, this course also has quiz and project, which allow you to practice the things learned throughout the course!

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 learn (or need support) how to install fully functional Enterprise level Oracle Data Integrator with all its components and support its execution.

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 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 Admin activities

Every new ODI version is coming with added features. Success of ODI implementation and its performance depends a lot on how  ODI Admin has installed and configured it. 

When installing ODI 12c at enterprise level, Oracle recommends Enterprise installation with Web logic server, Managed ODI Server and either Standalone collocated agent or JEE agent as they provide high availability and other benefits of Fusion Middleware. This course covers all that you need to know to successfully install ODI for your project. You will go through instructions in video as well as pdf document with each step shown in the video. 

Pay once, benefit a lifetime!
This is an evolving course! Enterprise installation of ODI 12c 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!

This course will also be updated to Oracle Data Integrator (ODI) Enterprise Installation on Linux platform !



Welcome to the course. In this lecture I explain you different attributes of this course.

Data to Intelligence

This introductory lecture explains what is data, information, intelligence and how they relate to each other. It also explains different architectures of ETL tools.

Why Data Integrator?

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


Development Process Flow

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

ODI Data Flow Architecture

This lecture explains 

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

This lecture explains ODI repository and it's components.

ODI Agents

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

Oracle Fusion Middleware

WebLogic Domain

In this lecture, you will understand 

  • What is WebLogic Domain
  • Administration Server, Managed
  • Node Manager
  • Cluster

Fusion Middleware Directory Structure

In this lecture you will understand Oracle Fusion Middleware with WebLogic Domain Directory Structure.

  1. Oracle Home
  2. ODI Domain

Oracle Express Database and SQL Developer

Install Oracle Express Database

You will need an relational database for next step. If you don't have an Oracle Database you can install free Oracle Express Data Base and try the installation steps.

SQL Developer Download

In this lecture you will download and start SQL Developer.

SQL Developer : Connection

In this lecture you will connect the SQL developer with database.

SQL Developer: Password Reset

In this lecture you will learn how to reset database password using SQL Developer.

Enterprise Installation

JDK Installation

ODI 12c needs JDK 7 and above. This lecture explains the steps to install and configure JDK 8 and change JAVA_HOME environment variable.

ODI Installation

This lecture explains from where to download ODI12c files and how to configure it.

The lecture covers following components.

  • Oracle Home creation
  • Install ODI SDK, 
  • ODI Knowledge Modules, 
  • ODI Studio, 
  • ODI Standalone Agent, 
  • ODI JEE, 
  • Oracle DataDirect Hive Driver
  • SOA All Client Libraries
  • Repository Creation Utility

Repository Creation

Create ODI repositories using Oracle provided repository creation utility.

This lecture explains how to create following schema in ODI repository database

  • Master Schema
  • Work Schema
  • OPSS Schema
  • OPSS Audit Schema
Domain Creation

Fusion Middleware configuration is important step in ODI Enterprise installation. This step is required  specially if you are going to use Standalone collocated agent or JEE agent.

This lecture explains how to configure the following components 

  • Administrator Server
  • Node Manager
  • Managed ODI Server
  • Cluster
  • Standalone Collocated Agent and JEE Agent
Start Node Manager and Servers
  • Start Node Manger
  • Start Web logic server
  • Login to Weblogic Admin Console and monitor servers.
  • Start Manged ODI Server
Standalone Colocated Agent

Configure and start Standalone Colocated Agent.

  • Configure Standalone Colocated Agent
  • Start Standalone Colocated  Agent through command prompt
  • Test the Standalone Colocated Agent

JEE Agent
  • Configure JEE Agent
  • Start JEE Agent through Weblogic Admin Console
  • Test the JEE Agent
ODI Installation

This Quiz will test your knowledge on ODI Architecture and ODI Enterprise Installation


Start ODI Studio and Create Connection

In this lecture, you will start ODI Studio and create connection with repository.

ODI Studio Topology - Connecting ODI with Other data sources

This lecture explains how to connect ODI with other data sources like file system and Oracle Database.


Project (Part1): Transfer data from flat file to Oracle RDBMS table.
  • Transfer data from a flat file to Oracle RDBMS table. 
  • Define physical and logical architecture in Topology. 
  • Create Project. Import Knowledge modules. 
  • Create Models and data store. 
  • Reverse engineer the file attributes and target table meta data. 
  • Create mapping between source file and target table. 
  • Run the mapping. Monitor the run in operator tab.
Project (Part2): Transfer data from flat file to Oracle RDBMS table.
  • Transfer data from a flat file to Oracle RDBMS table. 
  • Define physical and logical architecture in Topology. 
  • Create Project. Import Knowledge modules. 
  • Create Models and data store. 
  • Reverse engineer the file attributes and target table meta data. 
  • Create mapping between source file and target table. 
  • Run the mapping. Monitor the run in operator tab.
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.5 out of 5
65 Ratings

Detailed Rating

Stars 5
Stars 4
Stars 3
Stars 2
Stars 1
30-Day Money-Back Guarantee


2 hours on-demand video
1 article
Full lifetime access
Access on mobile and TV
Certificate of Completion