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 distinctions from traditional ETL
- Key components: Repositories, Agents, Topology, and Security
- Installation overview and environment structure
ODI Studio and Development Tools
- Navigating ODI Studio: Designer, Topology, Operator, and Security panels
- Management of Projects, Models, and Datastores
- Utilising reverse-engineered metadata
Designing Mappings and Interfaces
- Creating mappings using the graphical interface and ODI elements
- Incorporating procedures, variables, and packages into mappings
- Strategies for error handling and data validation
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their various categories
- Selecting and customising KMs for different target systems
- Performance considerations and push-down optimisation techniques
Topology, Security, and Connectivity
- Configuration of physical and logical schemas and data servers
- Agent types, configuration settings, and high availability basics
- Security setup: defining users, 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 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, 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: analysing and optimising a slow 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 optimisation techniques
- Exploring further learning paths and certification options
Requirements
- A solid grasp of relational database principles
- Practical experience with SQL
- Knowledge of ETL or general data integration concepts
Target Audience
- ETL/Data integration developers
- Data architects and engineers
- DBAs and middleware engineers overseeing integration solutions
35 Hours
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
