Logo

Oracle Data Integrator Course Content

Introduction

· What is Oracle Data Integrator?
· Why Oracle Data Integrator?
· Overview of ODI 11g Architecture
· Overview of ODI 11g Components
· About Graphical Modules
· Types of ODI Agents
· Overview of Oracle Data Integrator Repositories

Administering ODI Repositories and Agents

· Administrating the ODI Repositories
· Creating Repository Storage Spaces
· Creating and Connecting to the Master Repository
· Creating and Connecting to the Work Repository
· Managing ODI Agents
· Creating a Physical Agent
· Launching a Listener, Scheduler and Web Agent
· Example of Load Balancing

ODI Topology Concepts

· Overview of ODI Topology
· About Data Servers and Physical Schemas
· Defining the Physical Architecture
· Defining the Logical Architecture
· Mapping Logical and Physical Resources
· Defining Agents
· Defining a Topology
· Planning the Topology

Describing the Physical and Logical Architecture

· Overview of Topology Navigator
· Creating Physical Architecture
· Creating a Data Server
· Testing a Data Server Connection
· Creating a Physical Schema
· Creating Logical Architecture
· Overview of Logical Architecture and Context Views
· Linking the Logical and Physical Architecture

Setting Up a New ODI Project

· Overview of ODI Projects
· Creating a New Project
· Using Folders
· Organizing Projects and Folders
· Understanding Knowledge Modules
· Exchanging ODI Objects
· Exporting and Importing Objects
· Using Markers

Oracle Data Integrator Model Concepts

· What is a Model?
· Understanding Metadata in ODI
· Understanding Reverse Engineering
· Creating Models
· Organizing Models
· Creating Data stores
· Using Constraints in ODI
· Creating Keys and References

Organizing ODI Models and Creating Data stores

· What is an Interface?
· Business Rules for Interfaces
· What is a Mapping?
· What is a Join?
· What is a Filter?
· What is a Constraint?
· What is a Staging Area?
· Creating a Basic Interface
ODI Interface Concepts  

· What is an Interface?
· Business Rules for Interfaces
· What is a Mapping, Filter, Join?
· Overview of Integration Process
· What is a Staging Area?
· About Execution Location
· Using Knowledge Modules (KM) with ODI Interface
· Creating a Basic Interface

Designing Interfaces

· Designing an Interface
· Multiple Source Data stores
· Creating Joins
· Filtering data
· Disabling Transformations
· Overview of the Flow
· Specifying the Staging Area
· Selecting Knowledge Modules

Interfaces: Monitoring and Debugging

· Monitoring Interfaces
· Using Operator
· Viewing Sessions and Tasks
· How to Monitor Execution of an Interface
· How to Troubleshoot a Session
· Keys to Reviewing the Generated Code
· Working with Errors
· Tips for Preventing Errors

 

Using ODI Packages

· What is a package?
· Creating a package
· Executing a package
· Creating Advanced Packages
· Error handling
· Controlling an Execution Path
· Creating a Loop
· Using the Advanced tab

Managing ODI Scenarios and Versions

· What is a Scenario?
· Managing Scenarios
· Preparing Scenarios for Deployment
· Automating Scenario Management
· Scheduling the ODI Scenario
· Overview of ODI version management
· Using Version Browser and Version Comparison Tool
· Handling concurrent changes

Enforcing Data Quality and Auditing Data with ODI

· Why Data Quality?
· When to Enforce Data Quality?
· Data Quality in Source Applications
· Data Quality Control in the Integration Process
· Data Quality in the Target Applications
· Enforcing Data Quality
· Exploring Your Data
· Auditing Data Quality

Working with Changed Data Capture

· Overview of ODI version management
· Techniques of Changed Data Capture
· Changed Data Capture in ODI
· CDC Strategies and Infrastructure
· CDC Consistency
· Using CDC
· Viewing Data/Changed data
· Using Journalizing