Oracle Data Integrator 11g Online Training

Oracle Data Integrator 11g Training

Oracle Data Integrator is a complete data integration software that handles all data-integration needs: from high-volume, high-performance group loads, to event-driven, trickle-supply integration functions, to SOA-enabled data services. Oracle Data Integrator’s Extract, Transform and Load (ETL) structure leverages disparate RDBMS machines to a procedure and change the info – the approach that optimizes performance, scalability and decreases total solution fees. Oracle Data Integrator engages a strong declarative style approach to data-integration, which separates the declarative policies from your implementation details. This combination offers the best products for both maintenance and improvement, as well as the highest performance for your setup of data modification and consent functions.

COURSE SUMMARY

What you’ll learn in Oracle Data Integrator 11g Training Course?

• Learn How to perform data transformation in different platforms
• How to execute ELT data transformations
• Mange ODI resources and setting up security with ODI ccc
• Apply Data Capture with ODI
• How to execute the integration of ODI with SOA and Usage ODI Web services

Download Course Curriculum

MODULE 1:   INTRODUCTION

• Oracle Data Integrator
• Overview of ODI 11g Components
• Overview of ODI 11g Architecture
• Graphical Modules
• ODI Agents Types
• Repositories of Oracle Data Integrator

MODULE 2:   ODI TOPOLOGY CONCEPTS

• ODI Topology Overview
• Data Servers and Physical Schemas
• Physical Architecture
• Logical Architecture
• Defining Agents

MODULE 3:   SETTING UP A NEW ODI PROJECT

• ODI Projects Overview
• Creating a New Project
• Organizing Projects and Folders
• Knowledge Modules
• Sharing Global Objects
• Exchanging ODI Objects
• Using Markers
• Importing and Exporting Objects

MODULE 4:   ODI INTERFACE CONCEPTS

• Interface
• Business Rules
• Mapping, Filter
• Integration Process
• Designing Interfaces
• Creating Joins
• Filtering data
• Overview of the Flow

MODULE 5:   USING ODI PROCEDURES AND PACKAGES

• What is a Procedure?
• Creating Procedures
• Adding Commands
• Running a Procedure
• Using ODI Packages
• Creating a package
• Error handling
• Creating a Loop

MODULE 6:   ADMINISTERING ODI RESOURCES

• Open Tools
• Installing Open Tools
• Developing Your Own Open Tools
• Defining Security Policies
• Setting Up ODI Security
• Defining Password Policies