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 Architecture
- Core ODI concepts: the ELT approach and key differences from traditional ETL.
- Essential components: Repositories, Agents, Topology, and Security frameworks.
- Overview of installation processes and environment layout.
ODI Studio and Development Components
- Navigating ODI Studio: utilizing the Designer, Topology, Operator, and Security panels.
- Managing Projects, Models, and Datastores.
- Working effectively with reverse-engineered metadata.
Designing Mappings and Interfaces
- Creating mappings using the graphical interface and native ODI components.
- Incorporating procedures, variables, and packages within mappings.
- Implementing error handling and data validation strategies.
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their distinct categories.
- Selecting and customizing KMs to suit different target environments.
- Addressing 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 basics of high availability.
- Establishing security setups: users, profiles, and repository protection.
Scheduling, Deployment, and Operational Management
- Packaging and deploying scenarios for production use.
- Developing scheduling strategies and integrating with external schedulers.
- Monitoring jobs and troubleshooting issues using Operator and Logs.
Advanced Techniques and Integration Patterns
- Implementing CDC patterns, incremental loading, and change data capture approaches.
- Integrating with Big Data sources and Hadoop ecosystems.
- Applying best practices for creating modular, 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: examining architecture decisions and lessons learned.
Summary and Next Steps
- Reviewing key ODI concepts and fundamental integration design principles.
- Discussing production deployment strategies and advanced optimization techniques.
- Exploring further learning paths and relevant certification options.
Requirements
- A solid understanding of relational database concepts.
- Practical experience with SQL.
- Familiarity with ETL or broader data integration concepts.
Target Audience
- ETL/Data integration developers.
- Data architects and engineers.
- DBAs and middleware engineers responsible for 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
