Course Outline
Introduction to ODI Architecture and Concepts
- Overview of ODI principles: The ELT approach and its distinctions from traditional ETL
- Key components: Repositories, Agents, Topology, and Security mechanisms
- Insight into installation processes and environment configuration
Exploring ODI Studio and Development Tools
- Navigating ODI Studio: Utilizing the Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Interacting with reverse-engineered metadata
Developing Mappings and Interfaces
- Building mappings via the graphical interface and native ODI elements
- Incorporating procedures, variables, and packages into mapping logic
- Implementing error handling and data validation strategies
Knowledge Modules and ELT Execution
- Comprehending Knowledge Modules (KMs) and their specific categories
- Choosing and adapting KMs for various target systems
- Addressing performance issues and applying push-down optimizations
Topology, Security, and Connectivity Setup
- Defining physical and logical schemas and configuring data servers
- Configuring Agent types and ensuring high availability
- Establishing security protocols: user management, profiles, and repository safeguards
Scheduling, Deployment, and Operational Oversight
- Package and deploy integration scenarios
- Formulating scheduling strategies and interfacing with external schedulers
- Monitoring job execution and resolving issues via the Operator and Logs
Advanced Techniques and Integration Patterns
- Implementing CDC patterns, incremental loads, and change data capture methods
- Connecting with Big Data sources and Hadoop-based ecosystems
- Applying best practices for creating modular and maintainable integration projects
Practical Labs and Real-World Application
- Comprehensive lab: Designing, building, and releasing an ODI scenario
- Performance lab: Diagnosing and optimizing underperforming mappings
- Case study analysis: Reviewing architectural choices and key takeaways
Summary and Future Directions
- Recap of essential ODI concepts and integration design fundamentals
- Exploring production deployment tactics and advanced optimization methods
- Identifying subsequent learning paths and certification opportunities
Requirements
- A solid grasp of relational database principles
- Proficiency in writing SQL queries
- Working knowledge of ETL or data integration methodologies
Target Audience
- Developers specializing in ETL or data integration
- Data architects and engineers
- DBAs and middleware engineers tasked with maintaining integration solutions
Custom Corporate Training
Training solutions designed exclusively for businesses.
- Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
- Flexible Schedule: Dates and times adapted to your team's agenda.
- Format: Online (live), In-company (at your offices), or Hybrid.
Price per private group, online live training, starting from 6500 € + VAT*
Contact us for an exact quote and to hear our latest promotions
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
