25,000+ Courses Nationwide
0345 4506120

Oracle 12c Data Integrator (ODI)

Oracle 12c ODI Data Integrator course; hands on training exploring ODI architecture, administration and key functionality and integration.

Target Audience:

  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Developers
  • Business Analysts
  • DBAs

Select specific date to see price, venue and full details.

Learning Objectives

Oracle 12c Data Integrator, built on high performance ELT, platform flexibility and intuitive user experience is a key   component and latest version of Oracle's complete OBI offering and enterprise data integration platform. Designed around continuous hands on labs course provides attendees with essential skills and hands on experience to fully harness it's enterprise potential.

The  course will explore the product from  architectural, implementation and best use perspectives, provding  attendees with understanding how ODI maximises  next generation  Extract-Load-Transformation technology to provde crucial analytics and true business intelligence - converting data into a business asset; information.

Attendees will start with basic blocking and  interfaces creation through to more complex, advanced aspects of ODI  including data workflows, management and monitoring, scheduling and impact analysis learning how to implement, administer and manage high volume movement and transformation of data between disparate platforms.


  • BI Knowledge
  • Data Warehouse Design
  • Knowledge of ETL

Course Content

Oracle Data Integrator

  • Information, not data
  • ODI Architecture
  • ODI Components
  • Graphical Modules
  • ODI Agents
  • Oracle Data Integrator Repositories overview

Administering ODI Repositories and Agents

  • Administrating the ODI Repositories
  • Creating Repository Storage Spaces
  • Creating and Connecting to the Master Repository
  • Creating and Connecting to the Work Repository
  • Creating a Wallet to Securely Store Credentials
  • Managing ODI Agents
  • Creating a Physical Agent

ODI Topology Concepts

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

Setting Up a New ODI Project

  • Creating a New Project
  • Creating and Maintaining Folders
  • Organizing Projects and Folders
  • Exchanging ODI Objects and Sharing Global Objects
  • Object export and import
  • Creating and Labeling with Markers

Oracle Data Integrator Model Concepts

  • Model overview
  • Understanding Metadata in ODI
  • Understanding Reverse Engineering
  • Creating Models Organizing Models
  • Creating Data stores
  • Configuring Constraints in ODI
  • Creating Keys and References

Organizing ODI Models and Creating Data Stores

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

ODI Mapping Concepts

  • What is 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
  • Creating an Intermediate Mapping

Designing Mappings

  • Designing a Mapping
  • Multiple Source
  • Data stores
  • Creating Joins
  • Filtering Data
  • Disabling Transformations
  • Overview of the Flow
  • Specifying the Staging Area

Mapping: Monitoring and Debugging

  • Monitoring Mappings
  • Objects with Operator
  • Sessions and Tasks
  • Monitoring Execution of a Mapping
  • Troubleshooting
  • Keys to Reviewing the Generated Code Errors

Creating and Running ODI Procedures

  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Viewing Results with Operator

Using ODI Packages

  • Creating a Package
  • Executing a Package
  • Creating Advanced Packages
  • Error Handling
  • Controlling an Execution Path
  • Creating a Loop
  • Using the Advanced tab

ODI Scenarios and Versions

  • Managing Scenarios with Load Plans
  • Preparing Scenarios for Deployment
  • Automating Scenario Management
  • Scheduling the ODI Scenario
  • Overview of ODI version management
  • Handling concurrent changes

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


We work with the best