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
- Core ODI concepts: the ELT approach and how it differs from traditional ETL
- Key components: Repositories, Agents, Topology, and Security
- Overview of installation and environment structure
ODI Studio and Development Tools
- Navigating ODI Studio: exploring the Designer, Topology, Operator, and Security panels
- Working with Projects, Models, and Datastores
- Utilizing reverse-engineered metadata
Designing Mappings and Interfaces
- Building mappings using the graphical interface and ODI components
- Incorporating procedures, variables, and packages into mappings
- Implementing error handling and data validation strategies
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their various categories
- Selecting and customizing KMs for specific target platforms
- Addressing performance considerations and push-down optimization
Topology, Security, and Connectivity
- Setting up physical and logical schemas and data servers
- Basics of Agent types, configuration, and high availability
- Security configuration: users, profiles, and repository protection
Scheduling, Deployment, and Operational Management
- Scenario packaging and deployment processes
- 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 methods
- Integrating 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: analyzing and optimizing a slow mapping
- Case study review: architecture decisions and key takeaways
Summary and Next Steps
- Recap of essential ODI concepts and integration design principles
- Discussion on production deployment strategies and optimization techniques
- Exploration of further learning paths and certification options
Requirements
- A solid grasp of relational database concepts
- Proficiency in SQL
- General familiarity with ETL or data integration principles
Target Audience
- ETL and data integration developers
- Data architects and engineers
- DBAs and middleware engineers involved in 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
