Oracle Data Integrator Training

Oracle Data Integrator Online Training

ODI 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

Repositories

  • 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
  • ODI Topology Concepts

Topology Navigator

  • 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

Designer Navigator

  • 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

Model

  • 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

Interface design

  • 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, and 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
  • Designing Interfaces: Advanced Topics
  • Using Business Rules in Interfaces
  • Overview of Business Rule Elements
  • Using variables
  • Using User Functions
  • Using Substitution Methods
  • Modifying a KM
  • Developing Your Own KM
  • Using RKM for Customized Reverse Engineering
  • Using ODI procedures

Procedures

  • What is a Procedure?
  • Examples of Procedures
  • Creating Procedures
  • Adding Commands
  • Adding Options
  • Running a Procedure
  • Using Operator to View Results
  • Using ODI Packages

Package

  • 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

Scenario

  • 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

CDC

  • 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
  • Administering ODI Resources: Advanced Topics

Open Tool

  • Using Open Tools
  • Installing Open Tools
  • Using Open Tools in a Package
  • Using Open Tools in a Procedure or in a KM
  • Developing Your Own Open Tools
  • Setting Up ODI Security
  • Defining Security Policies
  • Defining Password Policies
  • Using Web Services and Integration of Oracle Data Integrator with SOA

Web Services

  • Invoking Web Services

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message