Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Duration 35 hours (5 days)
Course Outline
Introduction to ODI and its Architecture
- Key ODI concepts: The ELT approach and how it differs from traditional ETL.
- Essential components: Repositories, Agents, Topology, and Security.
- Overview of installation processes and environment layout.
ODI Studio and Development Components
- Navigating ODI Studio: Designer, Topology, Operator, and Security panels.
- Managing Projects, Models, and Datastores.
- Utilizing reverse-engineered metadata effectively.
Designing Mappings and Interfaces
- Building mappings using the graphical interface and ODI components.
- Incorporating procedures, variables, and packages into mappings.
- Strategies for error handling and data validation.
Knowledge Modules and ELT Execution
- Comprehending Knowledge Modules (KMs) and their respective categories.
- Selecting and customizing KMs for various target systems.
- Performance considerations and push-down optimization techniques.
Topology, Security, and Connectivity
- Configuring physical and logical schemas along with data servers.
- Understanding Agent types, configuration, and high availability fundamentals.
- Security setup: Managing users, profiles, and repository protection.
Scheduling, Deployment, and Operational Management
- Package scenarios for efficient deployment.
- Scheduling strategies and integration with external schedulers.
- Job monitoring and troubleshooting using Operator and Logs.
Advanced Techniques and Integration Patterns
- CDC patterns, incremental loading, and change data capture methodologies.
- Integration with Big Data sources and Hadoop ecosystems.
- Best practices for creating modular and maintainable integration projects.
Hands-on Labs and Real-World Case Study
- End-to-end lab: Design, implement, and deploy a complete ODI scenario.
- Performance tuning lab: Analyze and optimize a slow-running mapping.
- Case study walkthrough: Exploring architecture decisions and lessons learned.
Summary and Next Steps
- Recap of key ODI concepts and integration design principles.
- Discussion on production deployment strategies and optimization techniques.
- Exploration of further learning paths and certification options.
Requirements
- A solid grasp of relational database concepts.
- Proficiency in writing and working with SQL.
- Familiarity with ETL or general data integration principles.
Target Audience
- ETL and data integration developers.
- Data architects and engineers.
- DBAs and middleware engineers tasked with managing integration solutions.
Testimonials (2)
good explanation on each points and provide assignment for practices.
Piseth Ben - ACLEDA Bank Plc.
Course - Oracle Database 19c: SQL Tuning Workshop
Greg was very patient and helpful
