Oracle Data Integrator 12c: Advanced Integration and Development

Oracle Data Integrator 12c: Advanced Integration and Development

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

Duration: 3 Days

Prerequisites

• Oracle Data Integrator 12c: New Features
• Oracle Data Integrator 11g: Integration and Administration (suggested)
• Oracle Data Integrator 12c: Integration and Administration (suggested)

Audience

• Business Analysts
• Data Modelers
• Data Warehouse Administrators
• Database Administrators
• SOA Architects
• Technical Consultants

Learning Objectives

• Describe GoldenGate integration
• Perform data integration and transformation among various platforms using advanced techniques
• Design advanced ODI mappings, procedures, and packages to perform ELT data transformations
• Automate ODI tasks using Groovy
• Set up ODI security by implementing a strongly secured approach with non-generic profiles and external user authentication
• Expose ODI scenarios as web services
• Integrate ODI in enterprise environment and SOA
• Describe best practices for implementing integration strategies
• Describe various ODI integration patterns
• Develop and customize Knowledge Modules with substitution methods and Java
• Automate ODI tasks by using the Groovy script editor
• Implement integration strategies with ODI by using best practices
• Use ODI web services and perform integration of ODI in an enterprise environment and SOA
• Describe Big Data support

Topics

• Developing ODI Knowledge Modules
• Designing Advanced Integration Mappings
• Using Variables
• Using Groovy in ODI
• Using Complex Files
• Enhancing ODI Security
• Integration of ODI in Enterprise Environment
• Integration of ODI in SOA
• Choosing Integration Strategies: Best Practices
• ODI and Big Data