EXceptional training for oracle professionals

Oracle ODI Development - Foundation Training Course

Attend An Oracle ODI Developer Course - Learn to Develop Applications Within Your Data Integration Installation

21 Jan London
request info

Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

Oracle ODI Development - Foundation training course (code: ODIDEV)


Our Oracle ODI training course is for ETL Developers who wish to get to know ODI.  This course will cover the product architecture and practical use of the Tool, so you can hit the ground running when you start using the product after the course. The course can be tailored to cover different Database Technologies: Oracle, MySQL and SQLServer, as well as Flat Files and XML sources and targets.


This course is for developers who wish to gain a practical and comprehensive understanding of how use the newest Oracle ELT tool: Oracle Data Integrator, formerly known as Sunopsis.



Product Overview

  • ODI product architecture

ODI repositories




Oracle Enterprise Manager

  • ODI key concepts

Execution Contexts

Knowledge Modules



Packages and Scenarios

Using Variables

  • Defining variables

Variable location and scope

Variable definitions

Refreshing variables

Variable history

  • Using variables for dynamic information

Assigning a value to a variable

Referencing variables

Variables in interfaces

Variables in models

Variables in topology

  • Using variables to alter workflows


Load Plans

ODI Sources, Targets, and Knowledge Modules

  • Defining Physical Schemas, Logical Schemas, and Contexts

Defining physical data servers

Defining Physical Schemas

Defining Logical Schemas and Contexts

Non-database technologies

  • Reverse-engineering metadata into ODI models

Standard reverse-engineering

Custom reverse-engineering

File reverse-engineering

XML reverse-engineering

  • Examining the anatomy of the interface flow

Example 1: Database and file to database

Example 2: File and database to second file

Example 3: File to Enterprise Application

  • Importing and choosing Knowledge Modules

Choosing Knowledge Modules

Importing a Knowledge Module

KMs—A quick look under the hood

Configuring behavior with KM options

  • Examining ODI Interfaces

Overview tab

Mapping tab

Flow tab

Quick-Edit tab


Working with Databases (Oracle)

  • Sample scenario description

Integration target

Integration source

Integration mappings

Data flow logistics

  • Exercise 1: Building the Load_Customer interface

Building the topology

Reverse-engineering the model metadata

Moving the data using an ODI interface

Checking the execution with the Operator Navigator

Working with MySQL

  • What you can and can't do with MySQL
  • Working with MySQL

Overview of the task

Integrating the product data

Integrating inventory data

  • Using MySql with ODI

Adding the MySQL JDBC driver

Expanding the topology

Reverse-engineering revisited

Preparing to move the product data

Using simulation and execution

Moving the inventory data

Working with Microsoft SQL Server

  • Example: Working with SQL Server

Overview of the task

Integrating the Sales data




  • Sample scenario

Expanding the ODI topology

Setting up the topology

Reverse-engineering the Model metadata

Creating interfaces and mappings

Load Sales Person interface

Load Sales Person mapping

Automatic Temporary Index Management

Load Sales Region interface

Checking the execution with the Operator Navigator

Execute the Load Sales Person interface

Verify and examine the Load Sales Person results

Verify and examine Load Sales Region results

Integrating File Data

  • Working with flat files


Prerequisites for flat files

Integrate the file data into an Oracle table

Partner data target, source, and mappings

Partner interface flow logistics

  • Step-by-step example

Expanding the topology for file handling

Integrating the Partner data

Creating and preparing the project

Creating the interface to integrate the Partner data

Running the interface


Working with XML Files

  • Introduction to XML

Introducing the ODI JDBC driver for XML

ODI and its XML driver—basic concepts

  • Example: Working with XML files

Requirements and background

  • Scope

Overview of the task

Integrating a Purchase Order from an XML file

Creating models from XML files

Integrating the data from a single Purchase Order

Single order interface flow logistics

Sample scenario: Integrating a simple Purchase Order file

Expanding the Topology

Reverse-engineering the metadata

Creating the Interface

Creating procedures

Creating Workflows—Packages and Load Plans

  • Packages

Creating a package

Adding steps into a package

Adding tools in a package

Best practice: No infinite loop

Generating a scenario from a package

  • Load Plans

Serial and parallel steps

Objects that can be used in a Load Plan

Exception handling

  • Using Packages and Load Plans

Error Management

  • Managing data errors

Detecting and diverting data errors

Data quality with ODI constraints

ODI error table prefix

Contents of an error table

Using flow control and static control

Using error thresholds

Correcting and recycling data errors

Recycling errors and ODI update keys

  • Managing execution errors

Handling anticipated errors

Causing a deliberate benign error with OdiBeep

Handling unexpected design-time errors

More detailed error investigation in Operator Navigator

Handling unexpected runtime errors

  • Handling operational errors
  • Product Overview
  • Using Variables
  • ODI Sources, Targets, and Knowledge Modules
  • Working with Databases (Oracle)
  • Working with MySQL
  • Working with Microsoft SQL Server
  • Integrating File Data
  • Working with XML Files
  • Creating Workflows—Packages and Load Plans
  • Error Management

Receive the latest version of this course into your inbox


21st Jan 2019 - 3 days £1595

see all dates


Show Discount for this course


  Bring a JBI course to your office
  and train a whole team onsite
  0800 028 6400
or request quote

  You can customise this course to
  suit your exact needs here
  0800 028 6400 or request quote

0800 028 6400


Show all related courses

Why JBI ?

►"great technology tips"
► "Access to exclusive content"
► "Short course means less time off"

►"Inspiring trainers"
► "Joined via web"
► "Knowledgable sales staff"

Get exclusive news about upcoming programs, technical insights & special offers