LIVE Instructor-Led Courses
Dismiss

Oracle ODI Development - Foundation training course

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

JBI training course London UK

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022

JBI training course London UK

  • 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

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
JBI training course London UK

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.

4.8 out of 5 average

"Our tailored course provided a well rounded introduction and also covered some intermediate level topics that we needed to know. Clive gave us some best practice ideas and tips to take away. Fast paced but the instructor never lost any of the delegates"

Brian Leek, Data Analyst, May 2022



“JBI  did a great job of customizing their syllabus to suit our business  needs and also bringing our team up to speed on the current best practices. Our teams varied widely in terms of experience and  the Instructor handled this particularly well - very impressive”

Brian F, Team Lead, RBS, Data Analysis Course, 20 April 2022

 

 

JBI training course London UK
 
Article : Top 20 "Pain Points" for Data Analysts
 

Problem 11 : You have a very complex Excel spreadsheet and you want to reproduce EXACTLY the same spreadsheet in Power BI
Solution: Power BI is not Excel, it works differently and it has different strengths. In order to tackle this issue the best way is going back to the source and try to...

See this article in our latest Newsletter



CONTACT
+44 (0)20 8446 7555

enquiries@jbinternational.co.uk

SHARE

Corporate Policies     Terms & Conditions
JB International Training Ltd  -  Company number 08458005

Registered address Wohl Enterprise Hub 2B Redbourne Avenue London N3 2BS

POPULAR

Rust training course                                                                          React training course

Threat modelling training course   Python for data analysts training course

Power BI training course                                   Machine Learning training course

Spring Boot Microservices training course              Terraform training course

Kubernetes training course                                                            C++ training course

Power Automate training course                               Clean Code training course