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
- Foundational ODI concepts: The ELT approach and its distinctions from traditional ETL
- Essential components: Repositories, Agents, Topology, and Security frameworks
- Overview of installation procedures and environment configuration
ODI Studio and Development Elements
- Mastering the ODI Studio interface: Designer, Topology, Operator, and Security panels
- Managing Projects, Models, and Datastores
- Utilizing reverse-engineered metadata effectively
Creating Mappings and Interfaces
- Building mappings using graphical tools and ODI-native components
- Incorporating procedures, variables, and packages into mapping logic
- Strategies for error handling and data validation
Knowledge Modules and ELT Execution
- Comprehending Knowledge Modules (KMs) and their various classifications
- Choosing and tailoring KMs for diverse target systems
- Optimizing performance and understanding push-down strategies
Topology, Security, and Connectivity
- Setting up physical and logical schemas along with data server connections
- Managing Agent types, configurations, and high availability fundamentals
- Establishing security protocols: user management, profiles, and repository protection
Scheduling, Deployment, and Operational Oversight
- Preparing and releasing scenarios for production use
- Developing scheduling strategies and linking with external scheduling tools
- Monitoring job status and diagnosing 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 ecosystems
- Applying best practices for modular and maintainable integration projects
Practical Labs and Real-World Case Studies
- Comprehensive lab: Designing, building, and deploying a full ODI scenario
- Performance tuning lab: Analyzing and optimizing sluggish mappings
- Case study analysis: Reviewing architectural decisions and key takeaways
Summary and Future Directions
- Recapping core ODI concepts and integration design principles
- Evaluating production deployment strategies and optimization techniques
- Exploring advanced learning paths and certification opportunities
Requirements
- A solid grasp of relational database principles
- Practical experience with SQL
- Working knowledge of ETL or data integration methodologies
Target Audience
- ETL and data integration specialists
- Data architects and engineers
- DBAs and middleware professionals overseeing 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
