Oracle Data Integrator 12c: Advanced Integration and Development
Course code
ODIAdID
Duration
3 Days, 24 Acad. Hours
Course Overview
Objectives
Prerequisites
Course Outline
Course Overview
Course 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.
Objectives
Course Objectives
- Describe GoldenGate integration
- Design advanced integration mappings
- Automate ODI tasks using Groovy
- Enhance ODI security with strongly secured approach
- 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 enhance Knowledge Modules
- Describe BigData support
Prerequisites
Required Prerequisite
- Oracle Data Integrator 12c: Integration and Administration
Audience
- Database Administrators
- Business Analysts
- Technical Consultant
- Data Modelers
- SOA Architect
- Data Warehouse Administrator
Course Outline
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
