Skip to content
info@bluemarkacademy.com0212 706 07 05
Contact

ODI – Oracle Data Integrator

Training Format: Live Online / In-Person Duration: 5 Days Download PDF

Request a Corporate Quote

Home›Courses›ODI – Oracle Data Integrator

Description

The Oracle Data Integrator Training is a 5-day program covering ODI mappings, ELT and data integration.

The ODI program covers physical and logical architecture, models, mappings, procedures, packages, load plans, changed data capture and knowledge modules.

 

What will you learn in this course?

  • Use Oracle Data Integrator to perform data transformation across various platforms
  • Design ODI mappings, procedures and packages to perform ELT data transformations
  • Manage ODI resources and set up security with ODI
  • Perform data integration and transformation across various platforms
  • Use the ODI graphical interface to define procedures, packages and ELT jobs
  • Set up and maintain a secure, multi-user ODI environment
  • Capture changed data with ODI
  • Use ODI web services and perform SOA integration with ODI

Outline

Major Components in ODI
ODI Topology Concepts
Describing the Physical and Logical Architecture
Setting Up a New ODI Project
Oracle Data Integrator Model Concepts and Data Stores
Organizing ODI Models and Creating Data stores
ODI Mapping Concepts and Designing Simple Mappings
Mapping: Monitoring and Debugging
Multi Data Source Mappings and Lookups
Reusable Mappings and Partitioning
ODI procedures and Functions
Using ODI Variables and Packages
Managing ODI Scenarios and Versions
Using Load Plans
Working with Changed Data Capture with Triggers
Developing Knowledge Modules
Designing ODI Integration Mappings
Managing Object Versions
Using Variables in ODI
Accelerating Development with Groovy
Calling Outbound Web Services and saving the result

Prerequisites

Basic knowledge of ELT data processing

Frequently Asked Questions

How long is the Oracle Data Integrator Training?

The program lasts 5 days.

Who is this training for?

It is designed for participants who want to develop data transformation and integration with Oracle Data Integrator.

What preparation is required to attend?

Basic knowledge of ELT data processing is required.

What topics does the training cover?

ODI mappings, ELT and data integration are covered.

What is the scope of the program?

The ODI program covers physical and logical architecture, models, mappings, procedures, packages, load plans, changed data capture and knowledge modules.

How do we get information about corporate training?

For a training plan and quote tailored to your group, you can get information through the contact form on this page.

Related Courses

You may also want to explore our Advanced Oracle SQL Tuning Training and PostgreSQL Administration Training programs.

Corporate Training Information and Quote

For a training plan and quote tailored to your team’s needs, you can get information through the contact form on this page.