Overview

The Oracle Data Integrator 12c: Advanced Integration and Development training and certification course will give you the a detailed overview of advanced techniques for using Oracle Data Integrator 12c (ODI). During the training, you will learn to implement high-performance movement and transformation of data among various platforms.

Skills Covered

On completion of this training, you will know:

  • Describe GoldenGate integration
  • Design advanced integration mappings
  • Automate ODI tasks using Groovy
  • Enhance ODI security with a strongly secured approach
  • Expose ODI scenarios as web services
  • Integrate ODI in an enterprise environment and SOA
  • Describe best practices for implementing integration strategies
  • Describe various ODI integration patterns
  • Develop and enhance Knowledge Modules
  • Describe BigData support

Prerequisites

Oracle Data Integrator 12c: Integration and Administration

Target Audience

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

Course Curriculum

Module 1: Introduction
• Overview of Oracle Data Integrator
Module 2: ODI Knowledge Modules: Overview
• Working with Knowledge Modules
• Developing Knowledge Modules
• ODI Knowledge Modules: Overview
Module 3: Developing Knowledge Modules
• Using Substitution Methods: Code Examples
• Developing Knowledge Modules: Best Practices
• Using Java in KMs
• Troubleshooting Knowledge Modules
Module 4: Designing ODI Integration Mappings
• Designing Integration Mappings: Best Practices
• Maintaining Integrity of Data
• Integration Process: Overview
• Integration Mappings: Overview
Module 5: Designing Advanced Integration Mappings
• Partitioning
• ODI Mappings: Advanced Functionality
• Reusable Mappings
Module 6: Using Variables in ODI
• Tracking Variables
• Using Variables: Overview
• Using Variables in ODI Objects
Module 7: Accelerating Development with Groovy
• Using Groovy Editor
• Performing SDK Tasks Using Java with Groovy Editor
• Interacting Programmatically with ODI
Module 8: Working with ASCII Files
• Complex Files: Configuring the Topology
• Complex Files in Integration Projects
• Complex Files Concepts: Overview
Module 9: Integration of ODI in Enterprise Environment and SOA
• Invoking Web Services
• Using Web Services with ODI: Overview
• ODI Integration with Java EE
• Integration of ODI with SOA
Module 10: Enhancing ODI Security
• Security Integration
• ODI Security: Overview
• Implementing a Strongly Secured Approach
• Configuring ODI External Authentication
Module 11: Choosing Integration Strategies: Best Practices
• Working on ODI Projects: Best Practices
• Real-Time Data Integration: Using ODI with Oracle GoldenGate
• Strategies with Staging Area on the Target
• Strategies with Staging Area Different from the Target
• Using ODI for Bulk Processing
• Defining an ODI Integration Strategies
Module 12: Cubes and Dimensions
• Create Cubes
• Overview of Dimensions
• Create Dimensions
• Overview of a Cube

Dates & Locations

Let’s make it work for you

Can’t find a date that fits? Need to train your whole team? Looking for a discount?
Speak to one of our learning experts today.

June 17, 2026 - June 19, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC

June 17, 2026 - June 19, 2026

Location: Online
Modal: VILT
Availability: TBC

June 21, 2026 - June 23, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC

June 21, 2026 - June 23, 2026

Location: Online
Modal: VILT
Availability: TBC

December 14, 2026 - December 16, 2026

Location: Kuala Lumpur
Modal: ILT
Availability: TBC

December 14, 2026 - December 16, 2026

Location: Online
Modal: VILT
Availability: TBC
Trainocate exam and cert

Exam & Certification

This course is not associated with any Certification.

Training & Certification Guide

Frequently Asked Questions

Speak to a Training Consultant

All courses are HRD Claimable.
Get in touch with our team via the form or WhatsApp us on +6011-5119 6631

Preferred mode of training
Checkboxes