Oracle Data Integrator

Oracle Data Integrator


    Oracle Data Integrator Course Content: 


    • Identifying the Course Content
    • 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.Installations & Configurations

    • Oracle 11G Database
    • ODI 11G
    • Web logic Server 11G
    • Configurations

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

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

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

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

    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
    • Selecting Knowledge Modules

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

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

    13.Using ODI procedures

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

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

    15.Managing ODI Scenarios and Versions

    • 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

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

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

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

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 1 month
    Contact Us

    +1 475-212-0075

    Drop us a query

    Error: Contact form not found.

    Job Support

    Error: Contact form not found.

    Course Features

    Live Instructor-led Classes

    This isn't canned learning. Its dynamic, its interactive, its effective

    Expert Educators

    Only the best or they're out. We are constantly evaluating our trainers

    24&7 Support

    We never sleep. Need something answered at 3 am? No Problem

    Flexible Schedule

    You don't learn as per our calendar. We work according to yours.

    Customized Training's

    The most part self-managed and adaptable to suit a person's particular adapting technology needs

    Priority Based Training's

    Real-time Scenario based Assignments and Case Studies