Oracle Data Integrator 12c: Integration and Administration

Skip to Scheduled Dates

Course Overview

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs. Learn How To: Use Oracle Data Integrator to perform transformation of data among various platforms, Design ODI mappings, procedures, and packages to perform ELT data transformations; Administer ODI resources and set up security with ODI, Perform data integration and transformation among various platforms, Use the ODI graphical interface to define procedures, packages, and ELT jobs; Set up and maintain a secure, multi-user ODI environment; Implement changed data capture with ODI, Use ODI Web services and perform integration of ODI with SOA.

Who Should Attend

Administrator Analyst Architect Data Scientist Database Administrator Implementer

Course Objectives

    • Administer ODI resources and setup security with ODI
    • Apply ODI Topology concepts for data integration
    • Describe ODI Model concepts
    • Describe architecture of Oracle Data Integrator 12c
    • Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
    • Explore, audit data, and enforce data quality with ODI
    • Implement Changed Data Capture with ODI
    • Integrate ODI with Version Control Systems (Subversion)
    • Extend ODI to include the Big Data Hadoop ecosystem

Course Outline

1 - Outline

  • Introduction
  • Administering ODI Repositories and Agents
  • ODI Topology Concepts
  • Describing the Physical and Logical Architecture
  • Setting Up a New ODI Project
  • Oracle Data Integrator Model Concepts
  • Organizing ODI Models and Creating Data stores
  • ODI Mapping Concepts
  • Designing Mappings
  • Mapping: Monitoring and Debugging
  • Designing Mappings: Advanced Topics 1
  • Designing Mappings: Advanced Topics 2
  • Creating and Running ODI procedures
  • Using ODI Packages
  • Step-by-Step Debugger
  • Managing ODI Scenarios and Versions
  • Using Load Plans
  • Enforcing Data Quality and Auditing Data with ODI
  • Working with Changed Data Capture
  • Advanced ODI Administration
  • Integrating ODI with Subversion
  • Integrating Big Data with ODI

< Back to Course Search

Class Dates & Times

Class times are listed Central time

This is a 5-day class

Class dates not listed.
Please contact us for available dates and times.