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.
Course Outline
Introduction to ODI and Architecture
- ODI concepts: ELT approach and distinctions from traditional ETL.
- Core components: Repositories, Agents, Topology, and Security.
- Overview of installation and environment setup.
ODI Studio and Development Components
- Navigating ODI Studio: Designer, Topology, Operator, and Security panels.
- Projects, Models, and Datastores.
- Working with reverse-engineered metadata.
Designing Mappings and Interfaces
- Creating mappings using graphical interfaces and ODI components.
- Utilizing procedures, variables, and packages within mappings.
- Strategies for error handling and data validation.
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their 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.
- Agent types, configuration, and high availability fundamentals.
- Security setup: users, profiles, and repository protection.
Scheduling, Deployment, and Operational Management
- Packaging and deploying scenarios.
- Scheduling strategies and integration with external schedulers.
- Monitoring jobs and troubleshooting using Operator and Logs.
Advanced Techniques and Integration Patterns
- CDC patterns, incremental loading, and change data capture approaches.
- Integration with Big Data sources and Hadoop ecosystems.
- Best practices for developing modular and maintainable integration projects.
Hands-on Labs and Real-World Case Study
- End-to-end lab: designing, implementing, and deploying an ODI scenario.
- Performance tuning lab: analyzing and optimizing slow mappings.
- Case study walkthrough: reviewing architecture decisions and lessons learned.
Summary and Next Steps
- Review key ODI concepts and integration design principles.
- Discuss production deployment strategies and optimization techniques.
- Explore further learning paths and certification options.
Requirements
- Understanding of relational database concepts.
- Experience with SQL.
- Familiarity with ETL or general data integration concepts.
Target Audience
- ETL and Data integration developers.
- Data architects and engineers.
- DBA and middleware engineers responsible for integration solutions.
35 Hours
Testimonials (1)
I found his methods very informative
