Home > Transfer Education > Training courses > Oracle - technology > Business Intelligence en Data Warehousing > Oracle Data Integrator

Oracle Data Integrator

This course is only available in Dutch. Would you prefer to take the course in English? Please contact us.

In today’s business ICT environments, organizations increasingly rely on specialized applications, often running on heterogeneous systems. Organizational effectiveness and efficiency can be significantly enhanced when information from these diverse systems is consolidated for analysis. This is where an integrated environment proves invaluable.

Oracle provides a suite of tools with Oracle Data Integrator (ODI), which can be utilized to design, build, and use such an integrated environment or data warehouse. This course focuses specifically on these aspects of Oracle Data Integrator. Theoretical concepts are complemented by practical assignments.

You will Learn

  • How to use Oracle Data Integrator (ODI) to set up a data warehouse.
  • The architecture of Oracle Data Integrator.
  • How to design, implement, and manage a data warehouse.
  • How to extract data from Oracle Databases, text files, and XML files.
  • How to load and transform data for a data warehouse.
  • How to transform data and expose it as a web service.
  • How to quickly process changes in data structures.
  • How to configure and manage the Oracle Data Integrator environment.
  • How to increase development speed using scripting.

Topics

  • Applications of Oracle Data Integrator (ODI).
  • Software architecture (repositories and knowledge modules).
  • Design architecture.
  • Extracting data from an Oracle Database.
  • Using variables and procedures.
  • Extracting data from text and XML files.
  • Data modeling in ODI.
  • Workflow (using packages and load plans).
  • Scheduling and error management.
  • Scripting with Groovy.
  • Mini-case study: Building a DWH with ODI in an SOA environment.

Who should attend?

This course is intended for anyone involved in developing with Oracle Data Integrator or managing an ODI environment.

Prior knowledge

Knowledge of Data Warehousing and Business Intelligence is desired.

Price per person

€ 1.950,-  (excluding VAT)

Duration of this course

3 days

Course dates

5 - 7 february 2025
23 - 25 april 2025
11 - 13 june 2025

Share this training

FacebooktwitterlinkedinmailFacebooktwitterlinkedinmail

Our 4 plus points

  1. Always experts
  2. Always flexible
  3. Always custom-made
  4. Always practical