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