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 distinctions from traditional ETL.
- Key components: Repositories, Agents, Topology, and Security.
- Overview of installation and environment configuration.
ODI Studio and Development Components
- Navigating ODI Studio: Designer, Topology, Operator, and Security panels.
- Managing Projects, Models, and Datastores.
- Working with reverse-engineered metadata.
Designing Mappings and Interfaces
- Creating mappings via the graphical interface and ODI components.
- Utilizing procedures, variables, and packages within 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 different target environments.
- Addressing performance considerations and push-down optimization.
Topology, Security, and Connectivity
- Configuring physical and logical schemas along with data servers.
- Agent types, configuration, and an introduction to high availability.
- Setting up security: managing users, profiles, and repository protection.
Scheduling, Deployment, and Operational Management
- Packaging and deploying scenarios.
- 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 methodologies.
- Integrating 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 slow mappings.
- Case study walkthrough: Examining architecture decisions and key lessons learned.
Summary and Next Steps
- Reviewing core ODI concepts and integration design principles.
- Discussing production deployment strategies and optimization techniques.
- Exploring further learning paths and certification opportunities.
Requirements
- A solid understanding of relational database concepts.
- Proficiency in SQL.
- Familiarity with ETL or data integration principles.
Target Audience
- ETL and data integration developers.
- Data architects and engineers.
- DBAs and middleware engineers tasked with managing integration solutions.
35 Hours
Testimonials (1)
I found his methods very informative
