Oracle ODI Development - Foundation training course

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