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
Course Outline
Introduction to ODI and Its Architecture
- Core ODI concepts: the ELT approach and its distinctions from traditional ETL
- Essential components: Repositories, Agents, Topology, and Security
- Overview of installation procedures and environment setup
ODI Studio and Development Tools
- Navigating ODI Studio: utilizing the Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Working with metadata derived from reverse-engineering
Designing Mappings and Interfaces
- Building mappings using the graphical interface and ODI components
- Incorporating procedures, variables, and packages into mappings
- Implementing strategies for error handling and data validation
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their various categories
- Choosing and tailoring KMs for specific target platforms
- Addressing performance concerns and push-down optimization
Topology, Security, and Connectivity
- Configuring physical and logical schemas alongside data servers
- Agent types, configuration settings, and fundamentals of high availability
- Establishing security protocols: user management, profiles, and repository protection
Scheduling, Deployment, and Operational Management
- Process for packaging and deploying scenarios
- Scheduling strategies and integration with external scheduling tools
- Job monitoring and troubleshooting using the Operator and Logs
Advanced Techniques and Integration Patterns
- CDC patterns, incremental loading, and change data capture methods
- 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: designing, implementing, and deploying a complete ODI scenario
- Performance tuning lab: analyzing and optimizing slow-running mappings
- Case study analysis: reviewing architectural decisions and key takeaways
Summary and Next Steps
- Recap of core ODI concepts and integration design principles
- Discussion on production deployment strategies and optimization techniques
- Exploration of further learning paths and certification opportunities
Requirements
- A solid grasp of relational database concepts
- Proficiency in SQL
- Working knowledge of ETL or data integration principles
Target Audience
- ETL and data integration developers
- Data architects and engineers
- DBAs and middleware engineers overseeing 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
