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 fundamentals: The ELT approach and its distinctions from traditional ETL
- Key components: Repositories, Agents, Topology, and Security
- Overview of installation and environment structure
ODI Studio and Development Tools
- Navigation within ODI Studio: Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Utilizing reverse-engineered metadata
Designing Mappings and Interfaces
- Building mappings through the graphical interface and ODI components
- Integrating procedures, variables, and packages into mappings
- Strategies for error handling and data validation
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their classifications
- Selecting and tailoring KMs for various target platforms
- Performance factors and push-down optimization techniques
Topology, Security, and Connectivity
- Configuring physical and logical schemas and data servers
- Agent types, setup, and fundamentals of high availability
- Security configuration: user management, profiles, and repository protection
Scheduling, Deployment, and Operational Management
- Packaging and deploying scenarios
- 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 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 an ODI scenario
- Performance tuning lab: Analyzing and optimizing a slow mapping
- Case study analysis: Architecture decisions and key takeaways
Summary and Next Steps
- Review of essential ODI concepts and integration design principles
- Discussion on production deployment strategies and optimization
- Exploring further learning paths and certification options
Requirements
- A solid grasp of relational database concepts
- Practical experience with SQL
- Basic familiarity with ETL or data integration principles
Target Audience
- ETL and data integration developers
- Data architects and engineers
- DBAs and middleware engineers involved in delivering integration solutions
35 Hours
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 8000 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
