Oracle 11g BI: Oracle Data Integrator (ODI)

Course code: O1023

4 days £1,840.00

Oracle Data Integrator course; hands on training exploring ODI architecture and key functionality.

Course content >

Who Should Attend?

Business Analysts
Data Warehouse Administrator
Data Warehouse Analyst


BI Knowledge
Data Warehouse Design
Knowledge of ETL 



Course Reviews

Course Contents

Oracle 11g Data Integrator, built on high performance ELT, platform flexibility and intuitive user experience is a key component of Oracle's complete OBI offering. Designed around continuous hands on labs iTrain's 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


As with all iTrain courses ODI can be delivered as a closed course on your site or a third party location. As company specific training iTrain will work with you to tailor content or your organisation and project's specific requirement and objectives. To assist with this iTrain provide a full mobile classroom the Classroom in a Box.

Oracle BI Applications 11g: ODI Course Contents

Oracle Data Integrator Overview

  • Product Overview
  • Architecture overview
  • Key Concepts
  • Repository
  • Interfaces
  • ODI Procedures

Oracle Data Integrator Installation

  • Installation & Configuration
  • Installation prerequisites
  • Creating the repository with RCU
  • Post-installation system set up tasks

Oracle Data Integrator

  • Defining variables
  • Location and scope
  • Refreshing variables
  • Variable history 
  • Dynamic information 
  • Declare Variable
  • Interfaces
  • Using variables to alter workflows 
  • Packages
  • Loan Plans

ODI Sources, Targets, and Knowledge Modules

  • Overview
  • Physical Schemas, Logical Schemas, and Contexts   
  • Non-database technology
  • Reverse-engineering
  • Anatomy of the interface flow
  • Knowledge Modules
  • KMs
  • Examining ODI Interface
  • Tabs

Using Oracle Databases as Source/Target

  • Integration Source, Targets & Mappings
  • Data flow logistics
  • Building the topology
  • Reverse-engineering the model metadata
  • Moving the data using an ODI interface
  • Checking the execution with the Operator Navigator

Extract Load and Transform File Data

  • Flat files
  • Prerequisites
  • Integratation into an Oracle table
  • File handling topology
  • Integrating Partner data
  • Running the interface

Creating Workflows—Packages and Load Plans

  • Packages
  • Changed Data Capture
  • Metadata, ODI Objects and Plugin
  • ODI Tools
  • Load Plans

Error Management

  • Managing data errors
  • Detecting and diverting data errors
  • Data quality with ODI constraints
  • ODI error table
  • Using flow control and static control
  • Using error thresholds
  • Correcting and recycling data errors
  • Recycling errors and ODI update keys
  • OdiBeep
  • Operator Navigator
  • Runtime errors
  • Operational errors

Managing and Monitoring ODI Components

  • Scheduling with Oracle Data Integrator
  • Schedule management user interface
  • Third-party schedulers
  • Fusion Middleware Console Control
  • Launching and accessing the FMCC
  • Oracle Data Integrator Console
  • Data Lineage
  • Flow Map


 Courses You May be interested in:

Contact us for more information