Oracle Data Integrator 12c: Advanced Integration and Development

Overview

This Oracle Data Integrator course covers advanced techniques for using Oracle Data Integrator 12c (ODI). You learn how to implement high-performance movement and transformation of data among various platforms.

Learn how to:

• Develop and customize Knowledge Modules with substitution methods and Java
• Perform data integration and transformation among various platforms using advance techniques
• Design advanced ODI mappings, procedures, and packages to perform EL-T data transformations
• Use variables to create reusable packages
• Automate ODI tasks by using the Groovy script editor
• Extract data from different types of complex file
• Use ODI web services and perform integration of ODI in an enterprise environment and SOA
• Set up ODI security by implementing a strongly secured approach with non-generic profiles and external user authentication
• Implement integration strategies with ODI by using best practices and an example using GoldenGate
• Create and populate cubes and dimensions

Audience

• Administrator
• Analyst
• Architect
• Database Administrator
• Implementer

Suggested Prerequisites

• Oracle Data Integrator 12c: Integration and Administration

Topics

• Introduction
• ODI Knowledge Modules: Overview
• Developing Knowledge Modules
• Designing ODI Integration
• Designing Advanced Integration Mappings
• Using Variables in ODI
• Accelerating Development with Groovy
• Working with ASCII Files
• Integration of ODI in Enterprise Environment and SOA
• Enhancing ODI Security
• Choosing Integration Strategies: Best Practices
• Cubes and Dimensions