• An empty cart

    You have no item in your shopping cart

  • An empty cart

    You have no item in your shopping cart

Enter your keyword

ODI - Oracle Data Integrator 12c Training

ODI – Oracle Data Integrator 12c Training


Course Overview

Oracle Data Integrator (ODI) software delivers high-performance data movement and transformation among enterprise heterogeneous platforms with its open and integrated ELT (Extract Load and Transform) architecture and extended support for Big Data. Oracle Data Integrator software helps Enterprise users to leverage data integration initiatives on-premise or in the cloud, such as Big Data management, Service Oriented Architecture (SOA) and Business Intelligence (BI). Our Oracle Data Integrator training course will teach you how to use the ODI software for creating repositories, defining data stores, using knowledge modules, using agents, creating interfaces, creating and executing packages etc.

Course Start Dates

Start Date Time DaysDurationLocation
27/04/202010.00 - 17.00Mon - Wed3 DaysBrentford
01/06/202010.00 - 17.00Mon - Wed3 DaysBrentford
06/07/202010.00 - 17.00Mon - Wed3 DaysBrentford
10/08/202010.00 - 17.00Mon - Wed3 DaysBrentford
14/09/202010.00 - 17.00Mon - Wed3 DaysBrentford
12/10/202010.00 - 17.00Mon - Wed3 DaysBrentford
16/11/202010.00 - 17.00Mon - Wed3 DaysBrentford


  • Dimensional modeling
  • Basic SQL
  • Data warehouse design
  • Database design

Target Audience

  • Business Intelligence Developer
  • Data Warehouse Administrator
  • Business Analysts
  • Data Warehouse Analyst
  • Data Modelers
  • Reports Developer
  • Data Warehouse Developer
  • Application Developers

On-site training for Corporate

We conduct on-site training for this course provided that the company has a training room with laptops or computers.

The price for a group of up to 3 candidates is £3,600.00 and for every additional candidate is £500.00 (within M25 area)

The price for a group of up to 3 candidates is £3,900.00 and for every additional candidate is £500.00 (outside M25 area)

Course Content

Oracle Data Integrator 12c

  • Identifying the Course Units
  • What is Oracle Data Integrator?
  • Why Oracle Data Integrator?
  • Overview of ODI 12c Architecture
  • Overview of ODI 12c Components
  • About Graphical Modules
  • Types of ODI Agents
  • Overview of Oracle Data Integrator Repositories

  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Managing ODI Agents
  • Creating a Physical Agent
  • Launching a Listener, Scheduler and Web Agent
  • Example of Load Balancing

  • Overview of ODI Topology
  • About Data Servers and Physical Schemas
  • Defining the Physical Architecture
  • Defining the Logical Architecture
  • Mapping Logical and Physical Resources
  • Defining Agents
  • Defining a Topology
  • Planning the Topology

  • Overview of 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

  • Overview of ODI Projects
  • Creating a New Project
  • Using Folders
  • Organizing Projects and Folders
  • Understanding Knowledge Modules
  • Exchanging ODI Objects
  • Exporting and Importing Objects
  • Using Markers

  • What is a Model?
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models
  • Organizing Models
  • Creating Data stores
  • Using Constraints in ODI
  • Creating Keys and References

  • What is an Interface?
  • Business Rules for Interfaces
  • What is a Mapping?
  • What is a Join?
  • What is a Filter?
  • What is a Constraint?
  • What is a Staging Area?
  • Creating a Basic Interface

  • What is an Interface?
  • Business Rules for Interfaces
  • What is a Mapping, Filter, Join?
  • Overview of Integration Process
  • What is a Staging Area?
  • About Execution Location
  • Using Knowledge Modules (KM) with ODI Interface
  • Creating a Basic Interface

  • Designing an Interface
  • Multiple Source Data stores
  • Creating Joins
  • Filtering data
  • Disabling Transformations
  • Overview of the Flow
  • Specifying the Staging Area
  • Selecting Knowledge Modules

  • Monitoring Interfaces
  • Using Operator
  • Viewing Sessions and Tasks
  • How to Monitor Execution of an Interface
  • How to Troubleshoot a Session
  • Keys to Reviewing the Generated Code
  • Working with Errors
  • Tips for Preventing Errors

  • Using Business Rules in Interfaces
  • Overview of Business Rule Elements
  • Using variables
  • Using User Functions
  • Using Substitution Methods
  • Modifying a KM
  • Developing Your Own KM
  • Using RKM for Customized Reverse Engineering

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results

  • What is a package?
  • Creating a package
  • Executing a package
  • Creating Advanced Packages
  • Error handling
  • Controlling an Execution Path
  • Creating a Loop
  • Using the Advanced tab

  • What is a Scenario?
  • Managing Scenarios
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI version management
  • Using Version Browser and Version Comparison Tool
  • Handling concurrent changes

  • 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

  • Reviewing the Oracle GoldenGate JAgent configuration in ODI Studio
  • Initial load
  • Starting the ODI and OGG Demo Client
  • Running the Mappings
  • Setting up Changed Data Capture
  • Synchronizing the changed data
  • Load TRG_CUSTOMER Mapping
  • Sync Data Package

Reviews Statistic

4 out of 4
1 Ratings
5 Start 0
4 Start 0
3 Start 0
2 Start 0
1 Start 0

1 review for ODI – Oracle Data Integrator 12c Training

  1. Avatar
    4 out of 5

    (verified owner):

    The course was run by an extremely informative and experienced tutor, and covered all aspects of the latest ODI version including the various types of agent creation.

    I would have no doubt in recommending this course for others requiring ODI tuition.

Add a review

Duration 3 Days
Price £1,790.00

Choose Start Date *

Location map

Share our course