Oracle Data Integrator 12c: Integration and Administration

Price
$5,000.00 USD

Duration
5 Days

 

Delivery Methods
Virtual Instructor Led
Private Group

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.

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

Who Should Attend?

Administrator Analyst Architect Data Scientist Database Administrator Implementer
  • Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
  • Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
  • Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
  • Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
  • Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
  • Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.

Course Prerequisites

There are no prerequisites for this course.

Agenda

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
 

Upcoming Class Dates and Times

Oct 28, 29, 30, 31, Nov 1
8:00 AM - 4:00 PM
ENROLL $5,000.00 USD
Jan 20, 21, 22, 23, 24
8:00 AM - 4:00 PM
ENROLL $5,000.00 USD
 



Do You Have Additional Questions? Please Contact Us Below.

contact us contact us 
 
Contact Us about Starting Your Business Training Strategy with New Horizons