
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

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
June 17, 2026 - June 19, 2026
June 17, 2026 - June 19, 2026
June 21, 2026 - June 23, 2026
June 21, 2026 - June 23, 2026
December 14, 2026 - December 16, 2026
December 14, 2026 - December 16, 2026

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























