TRAINING

Enroll Now

Oracle Data Integrator Training

Our Oracle Data Integrator (ODI) training explain how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data.Training deliver experience in configuring and administering the ODI 12c environment. Oracle ODI online training is a comprehensive data integration platform that covers all data integration requirements from high-performance batch loads, high-volume, trickle-feed integration processes, SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle strategic Data Integration offering and provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration

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