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
Foundations of ODI and Its Architecture
- Core ODI principles: the ELT methodology and its distinctions from traditional ETL
- Essential components: Repositories, Agents, Topology, and Security
- Overview of installation processes and environment structure
ODI Studio and Development Tools
- Exploring ODI Studio: accessing Designer, Topology, Operator, and Security sections
- Managing Projects, Models, and Datastores
- Utilizing reverse-engineered metadata effectively
Mapping and Interface Design
- Building mappings using the graphical interface and ODI modules
- Incorporating procedures, variables, and packages into mappings
- Strategies for error handling and data validation
Knowledge Modules and ELT Execution
- Comprehending Knowledge Modules (KMs) and their respective categories
- Choosing and modifying KMs for various target systems
- Addressing performance factors and push-down optimization
Topology, Security, and Connectivity
- Setting up physical and logical schemas along with data servers
- Configuring Agent types and establishing high-availability basics
- Implementing security protocols: user management, profiles, and repository safeguards
Scheduling, Deployment, and Operations
- Preparing and rolling out scenarios
- Defining scheduling strategies and interfacing with external schedulers
- Tracking job performance and resolving issues using Operator and Logs
Advanced Methods and Integration Patterns
- Techniques for CDC, incremental loads, and change data capture
- Connecting with Big Data sources and Hadoop ecosystems
- Best practices for creating modular, maintainable integration projects
Practical Labs and Real-World Application
- End-to-end exercise: designing, implementing, and deploying an ODI scenario
- Performance tuning exercise: diagnosing and refining a sluggish mapping
- Case study analysis: reviewing architectural decisions and key takeaways
Recap and Future Directions
- Reinforcing key ODI concepts and integration design fundamentals
- Exploring production deployment strategies and optimization methods
- Identifying further educational paths and certification opportunities
Requirements
- Solid grasp of relational database principles
- Proficiency in SQL
- Acquaintance 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 integration strategies
35 Hours
Testimonials (3)
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
Chris Havel - Encyclopaedia Britannica
Course - ORACLE SQL Fundamentals
Learning about a new tool, the practices help a lot in understanding the topics, and that was what I liked the most.
David Vargas Alpizar - BANCO BAC SAN JOSE S.A
Course - Oracle Database 19c: Administration
Machine Translated
