Oracle Data Integrator 12c: Advanced Integration and Development

Required Prerequisite

• Oracle Data Integrator 12c: Integration and Administration

Audience

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

Course Topics

1. Introduction

• Overview of Oracle Data Integrator

2. ODI Knowledge Modules: Overview

• Working with Knowledge Modules
• Developing Knowledge Modules
• ODI Knowledge Modules: Overview

3. Developing Knowledge Modules

• Using Substitution Methods: Code Examples
• Developing Knowledge Modules: Best Practices
• Using Java in KMs
• Troubleshooting Knowledge Modules

4. Designing ODI Integration Mappings

• Designing Integration Mappings: Best Practices
• Maintaining Integrity of Data
• Integration Process: Overview
• Integration Mappings: Overview

5. Designing Advanced Integration Mappings

• Partitioning
• ODI Mappings: Advanced Functionality
• Reusable Mappings

6. Using Variables in ODI

• Tracking Variables
• Using Variables: Overview
• Using Variables in ODI Objects

7. Accelerating Development with Groovy

• Using Groovy Editor
• Performing SDK Tasks Using Java with Groovy Editor
• Interacting Programmatically with ODI

8. Working with ASCII Files

• Complex Files: Configuring the Topology
• Complex Files in Integration Projects
• Complex Files Concepts: Overview

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

10. Enhancing ODI Security

• Security Integration
• ODI Security: Overview
• Implementing a Strongly Secured Approach
• Configuring ODI External Authentication

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

12. Cubes and Dimensions

• Create Cubes
• Overview of Dimensions
• Create Dimensions
• Overview of a Cube