• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 678-701-4914

About Course:


This training program is designed to prepare the students for Oracle Data Integration Developer track. This training program teaches student how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

Duration : 30 hours

Fee: 438

Job Trends

Training Calender

Date Time Type Attend
20th April 2024 8:00 AM   IST Demo
23rd April 2024 8:00 AM   IST Regular
Contact Us

+91 769-409-5404

  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Module of Training


Live presentation of theory, demonstration of tool, features & tasks

We are connecting Online via Goto Meeting

Get practice environment for practical & hands-on Training curriculum has been designed by real-time industry professionals & real-time scenarios training pattern


Learn as per day-wise & customized schedule with discussions & lab exercises included

One to one or Batch-wise interactive demonstration of a tool, features and 100% practical classes

World-class learning material & case studies for the course

Completely customizable course content & schedule as per convenience

Certification guidance provided if necessary


Oracle Data Integration 12C Download  

Oracle Data Integration 12c Training

Course Overview:

Class: 1 Introduction to ODI

Identifying the Course Units

Why Oracle Data Integrator?

Overview of ODI Architecture

Overview of ODI Components

About Graphical Modules

Types of ODI Agents

Overview of Oracle Data Integrator Repositories

Class: 2 Installation of ODI 12c

Identifying the required software's.


System Requirements

Installation of ODI

Repository Configuration using RCU

Setting the sample database for hands-on

Class: 3 Introduction to ODI Repository and Agents

Administrating the ODI Repositories

Connecting to the Master Repository

Connecting to the Work Repository

Managing ODI Agents

Creating a Physical Agent

Class: 4 ODI 12c Features

The Benefits of Using ODI 12c

Overview of ODI 12g Architecture and Components

The features of New ODI 12c User Interface and its Components

Overview of ODI 12g New Features

Class: 5 ODI Topology Navigator

Creating Physical Architecture

Creating a Data Server

Testing a Data Server Connection

Creating a Physical Schema

Creating Logical Architecture

Overview of Logical Architecture and Context Views

Linking the Logical and Physical Architecture

Class: 6 ODI Models and datastores

What is a Model?

Understanding Metadata in ODI

Understanding Reverse Engineering

Creating Models

Organizing Models

Creating Data stores

Configuring Constraints in ODI

Creating Keys and References

Class: 7 ODI 12c Mapping

What is a Mapping?

Designing a Mapping

Business Rules for Mapping

What is a Mapping, a Filter, a Join?

Overview of Integration Process

What is a Staging Area?

Execution Location

Mapping with Knowledge Modules (KM)

Creating an Intermediate Mapping

Class: 8 ODI 12c MappingMonitoring and Debugging

Monitoring Mappings

Creating Objects with Operator

Viewing Sessions and Tasks

How to Monitor Execution of a Mapping

How to Troubleshoot a Session

Keys to Reviewing the Generated Code

Working with Errors

Tips for Preventing Errors

Class: 9 Designing Mappings: 1

Mapping with Business Rules

Overview of Business Rule Elements

Creating and Tracking Variables

Creating User Functions

Mapping Substitution Methods

Showing Variable Values in Log

Customizing Reverse Engineering Using RKM

Class: 10 Designing Mappings: 2

Using Partitioning in a Mapping

Reusable Mappings

Derived Select (Subselect) for Reusable Mappings

Using User Functions

Creating a User Function

Using Substitution Methods

Class: 11 ODI Procedures

What is a Procedure?

Examples of Procedures

Creating Procedures

Adding Commands

Adding Options

Running a Procedure

Viewing Results with Operator

Class: 12 ODI Packages

What is a Package?

Creating a Package

Executing a Package

Creating Advanced Packages

Error Handling

Controlling an Execution Path

Creating a Loop

Class: 13 ODI Scenarios and versions

What is a Scenario?

Managing Scenarios with Load Plans

Preparing Scenarios for Deployment

Automating Scenario Management

Scheduling the ODI Scenario

Overview of ODI version management

Handling concurrent changes

Class: 14 Enforcing Data Quality

Why Data Quality?

When to Enforce Data Quality?

Data Quality in Source Applications

Data Quality Control in the Integration Process

Data Quality in the Target Applications

Enforcing Data Quality

Exploring Your Data

Auditing Data Quality

Class: 15 ODI Changed Data Capture

Techniques of Changed Data Capture

Changed Data Capture in ODI

CDC Strategies and Infrastructure

CDC Consistency

Creating Change Data Capture (CDC)

Viewing Data/Changed data


Class: 16 Load Plans

What Are Load Plans?

Load Plan Editor

Load Plan Steps

Defining the Restart Behavior

Benefits of Using Load Plans

Handling Failed Load Plans

Class: 17 ODI Security Navigator

Security Concepts: Overview,

Defining Security Policies

Creating Profiles, Creating Users,

Assigning a Profile to a User,

Assigning an Authorization by Profile or User

Defining Password Policies,

Generating Topology Reports

Class: 18 Step-by-Step Debugger

Benefits of Using Step-by Step Debugger

Overview of the Features of Step-by-Step Debugger

Debugging Mappings using the Debugger

Debugging Packages using the Debugger

Class: 19 Developing ODI Knowledge Modules

Overview of Different Types of KMs

Guidelines for KM Developers

Working with Substitution Methods

Applying Various ODI Tags

Implementing Java in KMs

Troubleshooting and Debugging KMs

Class: 20 Using Groovy in ODI

Interacting Programmatically with ODI

Overview of ODI SDK

Introduction to Groovy

Using Groovy Editor

Automating Development Tasks with Groovy

Watch demo videos:

Who should Learn Oracle Data Integration 12C?


Students who want to make their career in database 

Prerequisite to learn Oracle Data Integration 12C

basic knowledge of SQL and relational database

Delivery Methodology used to deliver the Oracle Data Integration 12C

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class delivery

Live Interactive classes with expert

Oracle Data Integration 12C FAQ

Question: Can I attend the Demo session before enrollment?

Answer: Yes, you may attend the Demo class before enrollment for training Quality Evaluation. You can also Interact with a trainer as one to one session for a specific requirement or discussion

Question: Can you schedule the training based upon my availability?

Answer: Yes, we need to discuss it with a trainer, accordingly, we can schedule training at a convenient time.

Question: How I can pay for the course?

Answer: You can pay the fee or enroll yourself via payment gateway through the course page, make an online payment using various options.

Question: What if I missed any class?

Answer: BISP has a missing class policy. If you missed any session, we will be sharing a recorded session. However, you may retake whole training multiple times within 6 month period but the trainer is the same.

Question: Is there any live project training along with regular training?

Answer: Our training curriculum includes real-time scenarios and lives project working module & the trainer explains every topic with examples. If you have any issue or you are stuck in any scenario the trainer will explain end-to-end.

Question: What about certification preparation and guidance?

Answer: BISP technical faculty assist & guide you completely for certification and preparation. We ensure you will get certified easily after our training.

Question: Who is the trainer & about his experience?

Answer: All our trainers are working professionals and industry experts with at least 10-12 years of relevant teaching experience. Each of them has gone through a rigorous selection process which includes profile screening, technical evaluation, and a training demo We also ensure that only those trainers with a high alumni rating continue to train for us.

Question: Do you provide Job support?

Answer: Yes, we provide Job support services, but the cost structure is different and fixed. For more details: Just give us a call at: +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: What if I have more queries and doubts?

Answer: Just give us call at : +91 769-409-5404 & +1 678-701-4914 You can also write to us: support@bisptrainings.com

Question: How Fee Refund Policy works?

Answer: Please refer the link for refund policy: https://www.bisptrainings.com/Refund-Policy

Case Study and Learning Pdf's


Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?