0345 4506120

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

          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 request 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.


          Our Customers Include