Oracle Data Integrator is the product for data integration and ETL in the context of Business Intelligence & Data Warehousing. During the course you will learn about the product and how to apply it to your project. This will allow you to learn how to work with the product in a safe environment, after which you can apply the learned knowledge to your daily work. This course lasts 4 days.

Target audience

The course Oracle Data Integrator is intended for developers who need to create a Data Warehouse with ETL. The course is also suitable for BI administrators who, besides specific subjects around administration, want to gain more knowledge about the activities of BI developers.

Required knowledge

No specific knowledge is required for this course. Although knowledge of Data Warehousing, Dimensional modelling and SQL will be of advantage.


The course Oracle Data Integrator contains theoretical, as well as practical elements with examples that can directly be applied.

Course details

  • Data Warehousing overview
  • ODI Architecture
  • ODI Topology
  • Source metadata
  • Projects
  • Knowledge Modules
  • Staging metadata
  • Executing and monitoring
  • Data Store metadata
  • Data Mart metadata
  • Packages
  • Mappings advanced parts
  • Load Plans
  • Data Quality
  • Error handling and robustness
  • Change Data Capture (CDC)
  • OWB ODI upgrade
  • ODI SDK & Groovy
  • ODI version management
  • ODI & Data Vault
  • ODI & XML Files
  • ODI documentation
  • API and Groovy