0845 450 6120

Oracle 11g BI: Oracle Data Integrator ODI

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

We don't currently have any courses listed for Oracle 11g BI: Oracle Data Integrator ODI, would you like to view all courses for Oracle?

Learning Objectives

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.


BI Knowledge
Data Warehouse Design
Knowledge of ETL

Course Content

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
          One Month
          Two Months
          Three Months
          More than Three Months
          PRINCE2 Foundation & Practitioner
          MSP Foundation & Practitioner
          APMP Certificate
          ITIL Foundation
          Scrum in One Day
          Certified ScrumMaster
          ISTQB Software Test Foundation
          Microsoft Project
          BCS Business Analysis Practice
          Other - Please Specify Below

          Our Customers Include