EXCEPTIONAL TRAINING COURSES FOR IT PROFESSIONALS
LONDON UK | ONSITE | ONLINE


Oracle ODI Development - Foundation Training Course


Capita Marks and Spencer Telefonica Cisco BBC Lloyds Sony

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

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



TRAINING COURSE OVERVIEW

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.


AUDIENCE

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.



DETAILHIGHLIGHTS

Product Overview

  • ODI product architecture

ODI repositories

Studio

Agent

Console

Oracle Enterprise Manager

  • ODI key concepts

Execution Contexts

Knowledge Modules

Models

Interfaces

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

Packages

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

Source

Target

Integrations

  • 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

Scope

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


See more courses in this category

See why people choose JBI

"At jbi even the sales team are technical so you are able to ask questions before the course"

Garima Aon

Call our Tech Team :  0800 028 6400  request info



PUBLIC COURSES (LONDON, UK)
 

1st May 2017 - 3 days £1900
Book

see all dates


X

Show Discount for this course



PRIVATE COURSES


  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


 

 

 

 

Get in touch
0800 028 6400




 

 

view all case studies

 

 

Our inspiring and up-to-date courses gain exceptional feedback

►"great tips to help reduce build times"
► "we got access to exclusive content"
► "intensive course meant less time off"

►"what an inspiring trainer !"
► "colleagues at 2 sites joined via web"
► "I passed my exam the next day"

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