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
- Foundations of ODI: The ELT approach and key distinctions from traditional ETL
- Essential components: Repositories, Agents, Topology, and Security frameworks
- Overview of installation processes and environment structure
ODI Studio and Development Components
- Navigating ODI Studio: Utilizing the Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Interacting with reverse-engineered metadata
Designing Mappings and Interfaces
- Building mappings through the graphical interface and ODI-specific components
- Incorporating procedures, variables, and packages within mappings
- Implementing error handling and data validation strategies
Knowledge Modules and ELT Execution
- Exploring Knowledge Modules (KMs) and their respective categories
- Selecting and customizing KMs for varied target environments
- Performance considerations and push-down optimization techniques
Topology, Security, and Connectivity
- Configuring physical and logical schemas alongside data servers
- Agent types, configuration specifics, and high availability fundamentals
- Security protocols: user management, profiles, and repository protection
Scheduling, Deployment, and Operational Management
- Packaging scenarios and managing deployment processes
- Developing scheduling strategies and integrating with external schedulers
- Monitoring job execution and troubleshooting via the Operator and Logs
Advanced Techniques and Integration Patterns
- CDC patterns, incremental loading, and change data capture methodologies
- Integration strategies for 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 a complete ODI scenario
- Performance tuning lab: Analyzing and optimizing slow-running mappings
- Case study analysis: Examining architecture decisions and key takeaways
Summary and Next Steps
- Recap of core ODI concepts and integration design principles
- Discussion on production deployment strategies and optimization methods
- Exploration of advanced learning paths and certification options
Requirements
- A solid grasp of relational database concepts
- Practical experience with SQL
- Familiarity with ETL or general data integration principles
Target Audience
- ETL and 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
