ODI 11g & 12c (Oracle Data Integrator) Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9

Learners : 1080

Duration :  30 Days

About Course

The newest edition of Oracle’s strategic Data connection service, ODI 11g & 12c (Oracle Data Integrator), offers better developer productivity and a better user experience thanks to a redesigned flow-based declarative user interface and tighter connection with Oracle Golden Gate. Enrol right away to get certified.

ODI Training Course Syllabus

Week 1

✔ ETL And ELT Architectures
✔ Introduction To ODI
✔ ODI Components
✔ Topology Manager
✔ Repositories
✔ Master Repository
✔ Work Repository
✔ Physical and Logical Architectures
✔ Data servers
✔ Schema
✔ Agents
✔ Contexts
✔ Security Manager
✔ Users
✔ Hosts
✔ Objects
✔ Profiles
✔ Designer
✔ Models
✔ Projects
✔ Variables
✔ Sequences
✔ User Functions
✔ Knowledge Modules
✔ Markers
✔ Interfaces
✔ Packages
✔ Procedures
✔ Others

✔ Global Variables
✔ Global Sequences
✔ Global User Functions
✔ Global Markers

✔ Operator

✔ Session List
✔ Hierarchical Sessions
✔ Scheduling
✔ Scenarios

Week 2

✔ Creating mappings with different scenarios

✔ ODI Setup

✔ ODI Installation
✔ Creation of DB Schemas for repositories
✔ Creation of Master Repository
✔ Creating a Connection to Master Repository
✔ Creation of a Work Repository

✔ Topology-Connection Creation

✔ Creation of a Context
✔ Creation of Data Servers
✔ Creation of Physical & Logical Schema
✔ Creation of Physical and Logical Agents
✔ Grouping Logical schema & logical Agents with the Context

✔ Designer

✔ Creation of Data Models
✔ Importing Source and Target tables metadata
✔ Creation of an ODI Project
✔ Importing Required Knowledge modules
✔ Creation of an Interface
✔ Mapping Source and Target columns in the Interface
✔ Creating a Scenario
✔ Executing the interface

✔ Operator

✔ Monitoring the Session Logs

✔ Knowledge Modules

✔ Reverse-Engineering Knowledge Modules (RKM)
✔ Check Knowledge Modules (CKM)
✔ Load Knowledge Modules (LKM)
✔ Integration Knowledge Modules (IKM)
✔ Journalizing Knowledge Modules (JKM)
✔ Service Knowledge Modules (SKM)

Week 3

✔ Working with

✔ Filters
✔ Joins
✔ Procedures
✔ Functions
✔ Variables
✔ Sequences
✔ Set Operations
✔ Lookup

✔ Scheduling
✔ ODI Tools

✔ OS Command
✔ OdiBeep
✔ OdiSendMail
✔ OdiSleep
✔ OdiStartScen
✔ OdiWaitForData

Week 4

✔ SCD Types Understanding

✔ SCD Type-1
✔ SCD Type-2
✔ SCD Type-3

✔ Load Plans
✔ Import/export & versioning
✔ Case Studies
✔ BI APPS Understanding

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

ODI Training - Upcoming Batches

Coming Soon



Coming Soon



Coming Soon



Coming Soon



Don't find suitable time ?


Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

ODI Online Training FAQ'S

What is Oracle Data Integrator (ODI)?

In 2006, Oracle purchased Sunopsis and the “Sunopsis Data Integrator” with it.
An E-LT (Extract, Load, and Transform) program called Oracle Data Integrator (ODI) is utilized for swift data transfer between dissimilar systems.
Oracle Data Integrator Enterprise Edition (ODI-EE), the most recent version, combines “Oracle Data Integrator” and “Oracle Warehouse Builder” as independent parts of a single package with a single license.

By learning through VISWA Online Trainings, advance in your job.

What is ELT?

ELT is a cutting-edge method for loading, extracting, and transforming data. The modifications are necessary when transporting huge volumes of data around the company are typically carried out by expensive heavyweight, mid-tier servers.

By pushing the necessary processing down to the typically large and powerful database servers already in place within the enterprise, ODI offers cutting-edge Extract Load and Transform (ELT) technology that enhances performance and lowers data integration costs, even across heterogeneous systems.

What components makeup Oracle Data Integrator?

“Oracle Data Integrator” comprises of:

1) Oracle Data Integrator + Topology Manager + Designer + Operator + Agent

2) Oracle Data Quality for Data Integrator

3) Oracle Data Profiling

What is Oracle Data Integration Suite?

Oracle data integration suite is a set of data management applications for building, deploying, and managing enterprise data integration solutions:

  1. Oracle Data Integrator Enterprise Edition
  2. Oracle Data Relationship Management
  3. Oracle Service Bus (limited use)
  4. Oracle BPEL (limited use)
  5. Oracle WebLogic Server (limited use)

Additional product options are:

  1. Oracle Goldengate
  2. Oracle Data Quality for Oracle Data Integrator (Trillium-based DQ)
  3. Oracle Data Profiling (Trillium based Data Profiling)
  4. ODSI (the former Aqualogic Data Services Platform)
How do ‘Contexts’ work in ODI?

Through the usage of Contexts and Logical schemas, ODI offers a distinctive design methodology. Consider a development team where a senior developer can specify the system architecture, connections, databases, data servers (tables, etc.), and other elements using the ODI Topology Manager.

In order to execute the interfaces, ODI will use the proper physical connections, databases + tables (source + target) linked the logical objects being used in those interfaces as defined within the environment Topology. These objects are linked through contexts to ‘logical’ architecture objects that are then used by other developers to easily create interfaces using these logical objects.


Vishnu Gadipudi
Vishnu Gadipudi
I Enrolled in VISWA Online Trainings for IBM Integration BUS course . Recently I Completed IBM Integration BUS Batch. It was Really Awesome Experience. Best Place To Learn , Experienced Trainer, Gives Us High Level Knowledge....
Navya Biradavolu
Navya Biradavolu
I was enrolled for looker Bl Tool,it was amazing experience . especially soft skill batch is one of my favourite batch . overall learning process is quite impressive.
Indla sneha
Indla sneha
I have joined I have joined VISWA Online TRAININGS for Java full stack course and i have completed Advance Java module. I had a good knowledge of Hibernate, spring,spring boot,spring MVC. Tutor has knowledge in depth and is supportive. Srinadh sir solved all our doubts....
bindu hima
bindu hima
I am recently completed Talend course and trainer is Rajendra very professional and helpful. All the doubts were solved in a precise manner.
Tarunasree Gowra
Tarunasree Gowra
"I truly enjoyed this course." Chaitanya sir fantastic-very knowledgeable. Sir give us very informative and clear instruction on how to achieve the goal. Thank you!
Tejaswini Kommu
Tejaswini Kommu
Overall Linux Admin sessions batch was very good. Mr. RAM Krishna teaching was very helpful to remind our basic concepts in linux & networking.
Gopanaboina Mounika
Gopanaboina Mounika
It was great learning with such a great and experienced staff. Praveen Sir (Oracle EPM Cloud - FCCS) was very helpful and operations team also very helpful in solving any minor problems students go through process.
Jyothi Gutlapalli
Jyothi Gutlapalli
I like to share my experience which provide lots of courses and one of those I recently completed my Salesforce BA Course and I like to tell you it was a great experience and my knowledge and confidence is really boosted after completing this course.
Good experience and great learning platform for Hyperion Essbase and Planning. The faculty is also well trained and soft spoken.
Chaitu Viswa
Chaitu Viswa
It was very good session for QlikView. I would like to thank to teacher Mr.Chandu for providing guidance for the required modules. Thanks VISWA Team for giving apportunity to leran new skills.

Quick Links