Oracle Data Integrator 11g: Integration and Administration (D64974) – Outline

Gedetailleerde cursusinhoud

Introduction

  • Identifying the Course Units
  • 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 and Sharing Global 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

Designing Interfaces: Advanced Topics

  • Using Business Rules in Interfaces
  • Overview of Business Rule Elements
  • Using and Tracking Variables
  • Using User Functions
  • Using Substitution Methods
  • Modifying a KM
  • Showing Variable Values in Log
  • Using RKM for Customized Reverse Engineering

Using ODI 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

  • 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 with Load Plans
  • 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

Administering ODI Resources: Advanced Topics

  • 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 in Action
  • Using Data Services
  • Setting Up Data Services
  • Testing Data Services
  • Installing Public Web Services
  • Using Public Web Services
  • Invoking Web Services
  • Integrating ODI with SOA

Extending ODI with the SDK

  • Using SDK Public Interfaces
  • Integrating through ODI SDK
  • Examining SDK examples