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 how it differs from traditional ETL models
- Essential components: Repositories, Agents, Topology, and Security frameworks
- Overview of installation processes and environment layout
ODI Studio and Development Components
- Navigating ODI Studio: Exploring the Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Utilizing reverse-engineered metadata for development
Designing Mappings and Interfaces
- Constructing mappings using the graphical interface and native ODI components
- Incorporating procedures, variables, and packages into mapping logic
- Implementing robust error handling and data validation strategies
Knowledge Modules and ELT Execution
- Understanding Knowledge Modules (KMs) and their various categories
- Selecting and tailoring KMs for specific target environments
- Addressing performance considerations and push-down optimization techniques
Topology, Security, and Connectivity
- Configuring physical and logical schemas along with data servers
- Managing Agent types, configuration settings, and high availability basics
- Establishing security protocols: user management, profiles, and repository protection
Scheduling, Deployment, and Operational Management
- Package creation and scenario deployment
- Developing scheduling strategies and integrating with external scheduler systems
- Job monitoring and troubleshooting using the Operator and Logs
Advanced Techniques and Integration Patterns
- Implementing CDC patterns, incremental loading, and change data capture methods
- Integrating with Big Data sources and Hadoop ecosystem components
- Adopting 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: Examining architecture decisions and key lessons learned
Summary and Next Steps
- Review of key ODI concepts and fundamental integration design principles
- Discussion on production deployment strategies and advanced optimization techniques
- Exploration of further learning paths and available certification options
Requirements
- A solid grasp of relational database concepts
- Proficiency in SQL
- General familiarity with ETL or data integration methodologies
Target Audience
- Developers specializing in ETL and data integration
- Data architects and engineers
- DBAs and middleware engineers tasked with 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
