D82167 - Oracle Data Integrator 12c: Integration and Administration

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

Duration: 5.0 days

Enquire Now

Start learning today!

Click Hereto customize your Training


Upon completing this course, the learner will be able to meet these overall 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


  • Module 1: Introduction
  • Module 2: Administering ODI Repositories and Agents
  • Module 3: ODI Topology Concepts
  • Module 4: Describing the Physical and Logical Architecture
  • Module 5: Setting Up a New ODI Project
  • Module 6: Oracle Data Integrator Model Concepts
  • Module 7: Organizing ODI Models and Creating Data stores
  • Module 8: ODI Mapping Concepts
  • Module 9: Designing Mappings
  • Module 10: Mapping: Monitoring and Debugging
  • Module 11: Designing Mappings: Advanced Topics 1
  • Module 12: Designing Mappings: Advanced Topics 2
  • Module 13: Using ODI Procedures
  • Module 14: Using ODI Packages
  • Module 15: Step-by-Step Debugger
  • Module 16: Managing ODI Scenarios and Versions
  • Module 17: Using Load Plans
  • Module 18: Enforcing Data Quality and Auditing Data with ODI
  • Module 19: Working with Changed Data Capture
  • Module 20: Advanced ODI Administration
  • Module 21: Integrating ODI with Subversion
  • Module 22: Integrating Big Data with ODI


  • Database Administrators
  • Business Analysts
  • Technical Consultant
  • Data Modelers
  • SOA Architect
  • Data Scientist
  • Data Warehouse Administrator


Basic knowledge of ELT data processing


This course is not associated with any Certification.

Course Benefits

  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses


This training is the first step in mastering MySQL, the world’s most popular open source database.


P10380 - Oracle Database 18c: Administration Workshop


Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.


D83527 - Java SE 8 Fundamentals
Enquire Now
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy