Course Details

Oracle Data Integrator Course Overview:

Oracle Data Integration delivers pervasive and continuous access to timely and trusted data across heterogeneous systems. Its comprehensive capabilities include real-time and bulk data movement, transformation, bi-directional replication, data services, and data quality for customer and product domains. Oracle Data Integrator 12cdeliver improved IT productivity, extreme performance, and future-ready solutions that enable you to keep pace with the latest trends, including big data analytics, cloud computing, and real-time business intelligence.

Oracle Data Integrator Course Content:

1. 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

2. Installation of Oracle Data Integrator 11g with Web logic Server

3. Administering ODI Repositories

•     Administrating the ODI Repositories
•     Creating Repository Storage Spaces
•     Creating and Connecting to the Master Repository
•     Creating and Connecting to the Work Repository

4. 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

5. 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

6. 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

7. 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

8. Setting up an ODI Agent

•     Managing ODI Agents
•     Creating a Physical Agent
•     Launching a Listener, Scheduler and Web Agent
•     Example of Load Balancing

9. 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

10. Designing Interfaces

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