Online | Self-Paced | Corporate

Oracle ODI Training

Tekslate online training provides real-time, and placement oriented Oracle ODI training. We offer the best Oracle ODI training courses online with content designed from basics to advanced levels. Our teams of Oracle ODI experts are professionals with hands-on real-time Oracle ODI projects knowledge that will provide students with an edge over other Training Institutes. Tekslate provides both weekday and weekend training classes and fast-track training sessions for Oracle ODI online.

6322 Learners

Key  Highlights

contact us
+1 930 200 4823
Key Highlights tekslate courses
25 Hrs Instructor Led Training
Key Highlights tekslate courses
Self-paced Videos
Key Highlights tekslate courses
20 Hrs Project & Exercises
Key Highlights tekslate courses
Key Highlights tekslate courses
Job Assistance
Key Highlights tekslate courses
Flexible Schedule
Key Highlights tekslate courses
Lifetime Free Upgrade
Key Highlights tekslate courses
Mentor Support


A complete index of
job-ready skills curated
to meet the industrial need.

Topology Concepts

  • Overview of the Topology

  • What Is the Topology?

  • Data Servers and Physical Schemas

  • What Is a Data Server?

  • What Is a Physical Schema?

  • Properties of Physical Schemas

  • The Physical Architecture in Oracle Data Integrator

  • Connecting to Your Data

  • What Is the Topology?

  • What Topology Manager Contains

  • The Physical Architecture View

  • Data Servers and Physical Schemas

  • Prerequisites for Connecting to a Server

  • Creating a Data Server

  • What Is a Project?

  • Overview of Oracle Data Integrator Projects

  • What Does a Project Represent?

  • Creating a New Project

  • What Is a Folder?

  • What Is a Knowledge Module?

  • Exporting and Importing

What Is a Model?

  • The Relational Paradigm

  • Relational Model Support in Oracle Data Integrator

  • Additional Metadata in Oracle Data Integrator

  • What Is Reverse-Engineering?

  • Methods for DBMS Reverse-Engineering

  • Standard Versus Customized Reverse-Engineering

  • Creating and Reverse-Engineering Models

  • What Is a Model?

  • What Is Reverse-Engineering?

  • Methods for DBMS Reverse-Engineering

  • How to Create a Model by Reverse-Engineering

  • How to Start the Reverse-Engineering Process

  • Selective Reverse-Engineering

  • Fleshing Out Data Models

  • What Is a Model Folder?

  • Creating a Model Folder

  • Organising Datastores into Sub-Models

  • Setting Up Automatic Distribution

  • Creating a Datastore in a Model

  • Adding Columns to a Datastore

  • Enforcing Data Quality with Oracle Data Integrator

  • Why Data Quality

  • When to Enforce Data Quality

  • Data Quality in the Source Applications

  • Data Quality Control in the Integration Process

  • Data Quality in the Target Applications

  • Overview of the Data Quality System

  • Exploring and Auditing Your Data

  • Exploring Your Data

  • Displaying the Contents of a Datastore

  • Viewing the Distribution of Values

  • Analysing the Contents of a Datastore

  • Defining Business Rules in Oracle Data Integrator

  • Deducing Constraints from Data Analysis

  • Auditing Data Quality

  • Interface Design: One-to-one Interfaces

  • Creating a One-to-One Interface

  • Creating and Naming a New Interface

  • Defining the Target Datastore

  • Defining the Source Datastore

  • Defining the Mappings

  • Valid Mapping Types

  • Saving the Interface

  • Interface Design 2

  • Multiple Sources & Joins

  • Multiple Source Datastores

  • Manually Creating a Join

  • Advanced Joins

  • Types of Joins & Setting Up a Join

  • Filters in Oracle Data Integrator

  • Defining a Filter Manually

  • Executing and Debugging Interfaces

  • How to Execute an Interface

  • What Happens at Run Time

  • Monitoring Interfaces

  • Operator: Viewing the Log

  • Sessions, Steps, Tasks: The Hierarchy

  • Viewing Sessions and Tasks

  • How to Monitor Execution of an Interface

  • Troubleshooting a Session

  • Interface Design

  • Essential Concepts in Data Quality

  • Defining and Enforcing Data Quality

  • Overview of the Data Quality System

  • Properties of Data Quality Control

  • Static/Flow Control Differences

  • How to Enforce Data Quality for an Interface

  • Differences Between Control Types

  • What Is a Procedure? & Procedure Examples
  • Using Procedures: Overview

  • How to Create a New Procedure

  • Creating a New Command

  • Arranging Steps in Order

  • Which Parameters Should be Set?

  • Valid Types of Commands

  • Types of Options

  • Variables and Sequences

  • Variable Scope

  • Value Persistence: Action Types

  • Refreshing a Variable with SQL

  • Binding Versus Substitution

  • How to Create a Variable Step

  • Properties of Sequences

  • Using Oracle Data Integrator Sequences in Mappings

  • What Is a User Function?

  • Creating User Functions

  • Properties of User Functions

  • How to Create a User Function

  • Defining an Implementation

  • Syntax and Implementations

  • Using User Functions

  • User Functions at Design Time & Run Time

  • What Is a Package?

  • How to Create a Package

  • Package Diagram Toolbar

  • How to Create an Interface Step

  • How to Create an Oracle Data Integrator Tool Step

  • A Simple Package

  • How to Sequence Package Steps

  • Executing a Package

  • Types of Package Steps

  • Basic & Advanced Step Types

  • How to Create a Procedure Step

  • Model, Sub-Model and Datastore Steps

  • Models, Sub-Models, and Datastore Steps

  • How to Create a Variable Step

  • Controlling the Execution Path

  • Controlling Execution

  • Releasing Projects

  • Properties of Scenarios

  • Managing Scenarios

  • Generating a Scenario

  • Generation Versus Regeneration

  • Executing a Scenario from the GUI

  • Implementing a Scenario from a Project

  • Preparing Scenarios for Deployment

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Oracle ODI Training  Objectives

At the end of the course, the student is capable of:

  • Analyse ODI Model and its concepts

  • Explain the Oracle Data Integrator11g Architecture

  • Apply the concepts of ODI Topology for Data Integration

  • Explain the designing of ODI Interfaces, Packages, Procedures, and Load Plans to perform ELT data transformations

  • Explain the concepts of ODI to explore, enforce data quality, and audit data

  • Explain Administrator ODI resources and set up security

  • Explain how to implement Changed Data Capture in ODI

  • Describe how to use the ODI Web Integrations and Services with SOA performance

Oracle ODI helps the organisation to grow to provide provider-oriented architecture and commercial enterprise system automation technology, cloud answers and massive data. Oracle ODI allows the functioning of multiple target tables as a part of a single interface. There is a vast demand for Oracle ODI certified professionals all over the world. The average salary of a certified Oracle ODI professional is

There is an enormous demand for Oracle ODI certified professionals around the globe. The average salary of a certified Oracle ODI professional is $166, 436/year.

The following Oracle ODI Online Training is meant for the following.

  • SOA Architect

  • Data Warehouse Administrator

  • Database Administrators

  • Data Modelers

  • Business Analysts

  • Technical Consultant

  • Beginners

  • Architecture
  • Architecture Overview

  • What Is Oracle Data Integrator?

  • The Oracle Data Integrator Architecture

  • Components

  • Graphical Modules

  • Run-Time Components

contact us
+1 930 200 4823

Training  Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

One-on-one Session

Live Online.

25 Hours
Additional tips from the trainer

24 Jan 2022, 07:00 AM IST

31 Jan 2022, 07:00 AM IST



17 Videos
Weekdays & Working Hours
Accessible through LMS
At your convenience

Oracle ODI Training Upcoming Batches

24 Jan, 2022 - 24 Feb, 2022
01:30 AM IST
31 Jan, 2022 - 03 Mar, 2022
01:30 AM IST
29 Jan, 2022 - 01 Mar, 2022
02:30 AM IST
22 Jan, 2022 - 22 Feb, 2022
02:30 AM IST
calendar tekslate

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates  Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

The Oracle ODI trainer was very concise and to the point. The hands-on exercises were beneficial in achieving a job. Thank you Tekslate.


Recently I’ve taken Oracle ODI training from The trainer is very knowledgeable about the subject. After the course, I’ve attempted the Oracle ODI certification and got qualified.


The training was provided using real-time examples taken on the field. The case studies are beneficial in the matter at hand. The trainer was very careful with our requirements and gave us exactly what we asked for, something that is seldom done.


Oracle ODI Training  FAQ'S

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

  • Our trainers are well experienced professionals and certified in working with front-end development technologies.
  • We will record all the Live sessions you go through, and we will send the recording of the class you missed.
  • For practical execution, our trainer will provide server access to the student. 

Join a Free Oracle ODI Training  Demo Session

See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

By providing us with your details, We wont spam your inbox.

Related  Courses

related courses

BizTalk Server Training

related courses

IBM DataPower Training

related courses

IBM Cast Iron Training

related courses

IBM Integration Bus Training