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

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9

Learners : 1080

Duration :  30 Days

About Course

Our ODI 11g & 12c (Oracle Data Integrator), the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.

ODI Training Course Syllabus

✔ 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

✔ 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)

✔ Working with

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

✔ Scheduling
✔ ODI Tools

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

✔ 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

Oracle acquired Sunopsis in 2006 and with it “Sunopsis Data Integrator”.

Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems.

The latest version, Oracle Data Integrator Enterprise Edition (ODI-EE) brings together “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a single product with a single license.

Our Page: VISWA Online Trainings

ELT is an innovative approach to extracting, loading, and Transforming data. Typically ETL application vendors have relied on costly heavyweight, mid-tier servers to perform the transformations required when moving large volumes of data around the enterprise.

ODI delivers unique next-generation, Extract Load and Transform (ELT) technology that improves performance and reduces data integration costs, even across heterogeneous systems by pushing the processing required down to the typically large and powerful database servers already in place within the enterprise.

“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

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)

ODI offers a unique design approach through the use of Contexts and Logical schemas. Imagine a development team, within the ODI Topology manager a senior developer can define the system architecture, connections, databases, data servers (tables, etc), and so forth.

These objects are linked through contexts to ‘logical’ architecture objects that are then used by other developers to simply create interfaces using these logical objects, at run-time, on the specification of a context within which to execute the interfaces, ODI will use the correct physical connections, databases + tables (source + target) linked the logical objects being used in those interfaces as defined within the environment Topology.


Excellent institute for Online WebMethods Course and I recommend VISWA Technologies thank you For arranging such a great faculty
Today is the last class for online RPA course i am thankful to Chaitanya sir for such a great training and I thank to admin team
Bodicherla Jagadeeswar
Bodicherla Jagadeeswar
Recently completed online Microsoft Intune training course By "Rajendra Prasad" and I recommend VISWA Online Trainings for this course and also thank you admin team
Penchalakumar Ganji
Penchalakumar Ganji
Best institute for Linux, AWS online course by Musab sir. I thank Chaitanya sir for arranging our classes
Konduru Akhil
Konduru Akhil
Hi, Overall training classes are very good.All the instructions are kind and patient.I look forward to take more classes from Viswa online trainings.
Eswar Tech
Eswar Tech
I enroll for aws solution architecture course. It was great learning with viswa technologies. Thanks team.
Manikanta Goud
Manikanta Goud
I am really satisfied. Best training institute. Thanks Chaitu
S Rambabu 6228
S Rambabu 6228
Best online training institute. I have more experience with java srinath trainer.
gaddam Manojkumar
gaddam Manojkumar
They have a professional approach by their trainer and support team. Personally, I liked the instructor's way of teaching and also helping us if we have any doubts after the class.
Ramesh Metta
Ramesh Metta
They have teachers with strong expertise. The AWS course i have taken was good and had full support from team.

Quick Links