Course Overview
About Course
Oracle Data Integrator (ODI) is a high-performance data integration platform designed for enterprise-scale ELT (Extract-Load-Transform) and real-time data synchronization. This 40‑hour training delivers an immersive journey—from architecture fundamentals to real-world implementation—empowering participants to architect and deploy ODI-based integration solutions.
The course begins with the core architecture, exploring ODI’s E‑LT approach, repositories (master and work), Studio interfaces, Agents, Load Plans, Scenarios, and runtime monitoring Learners configure physical and logical topology settings, define data servers, schemas, and contexts, then reverse-engineer source systems to populate metadata models.
A key focus is Knowledge Modules (KMs)—code templates driving ODI’s declarative transformation logic. Students gain hands-on experience configuring LKMs for data loading, IKMs for integration, CKMs for data validation, SKMs for service exposure, and JKM for journalizing and Change Data Capture (CDC)
Mapping and package design sessions guide learners through graphical integration flows, including advanced constructs like Slowly Changing Dimensions, flows, variables, and errors, orchestrated via Packages and scheduled with Load Plans. The course delves into data quality, journaling, and real-time integration patterns.
Advanced integration covers connecting flat files, JMS queues, web services, and Big Data sources; customization includes PL/SQL procedures, ODI variables, and data service exposure . Participants also master journalizing and CDC to support incremental loading using JKMs.
The training emphasizes monitoring and troubleshooting, with tools like Operator and Oracle Enterprise Manager to manage sessions, logs, and optimize performance. Deployment topics include scenario generation, load planning, version control, and security governance.
A capstone project blends all learned components: reverse-engineering, mapping, journalizing, package orchestration, and deployment—to deliver a polished, peer-reviewed integration solution. This ensures participants emerge not only certified-ready but fully capable of designing, developing, and managing ODI solutions in enterprise environments. Roles supported include ETL Developer, ODI Architect, Data Integration Specialist, and Middleware Consultant.
Course Syllabus
Module 1: Introduction & Architecture (3 hrs)
- ODI fundamentals: concepts, E‑LT vs ETL, integration styles (batch, real-time, services)
- ODI components: Repositories, Studio navigators, Agents, Load Plans, Scenarios
Module 2: Installation & Topology Setup (4 hrs)
- Install and configure Master/Work repositories
- Define physical and logical topology: data servers, schemas, contexts
Module 3: Reverse-Engineering Models (3 hrs)
- Reverse-engineer source schemas and datastores using RKM
- Manage models and metadata within ODI Studio
Module 4: Knowledge Modules (6 hrs)
- Understand KM types: RKM, CKM, LKM, IKM, JKM, SKM
- Configure and customize modules for ETL processes
- Dive into journalizing and CDC with JKM
Module 5: Mappings & ELT Design (5 hrs)
- Design graphical mappings: joins, filters, expressions, SCDs, flows
- Execute and monitor in Operator navigator
Module 6: Packages & Load Plans (4 hrs)
- Orchestrate data flows using Packages
- Build load plans for scheduling and parallel execution
Module 7: Data Quality & Controls (3 hrs)
- Implement CKM for data integrity
- Utilize declarative business rules at mapping level
Module 8: Advanced Features (5 hrs)
- Use variables, procedures, and ODI public objects
- Integrate file, JMS, web services via SKM
- Connect to Big Data and NoSQL sources
Module 9: Journalizing / CDC & Change Data Capture (3 hrs)
- Configure JKM for consistent set capturing
- Integration with GoldenGate, Streams, triggers
Module 10: Monitoring & Troubleshooting (4 hrs)
- Operational monitoring via Operator and Enterprise Manager
- Troubleshoot sessions, logs, performance tuning
Module 11: Deployment & Security (3 hrs)
- Promote scenarios across environments
- Manage security, roles, versioning
Module 12: Capstone Project & Revision (3 hrs)
- Design and deliver full data integration solution
- Build model → mapping → load plan → journalizing → deploy
- Present with peer/instructor review
-
Key Features
Hands-on labs: Full integration lifecycle, building real mappings, packages, load plans
ODI 12c Studio usage: Navigate Topology, Designer, Operator, Security
Declarative ELT: Build mappings using drag-drop transformations, SCD, data quality rules
Knowledge Modules deep-dive: Configure and customize LKMs, IKMs, JKMs, SKMs
Journalizing / CDC: Implement incremental load strategies via JKM
Multi-source integration: Databases, flat files, JMS, web services, Big Data
Monitoring & optimization: Analyze and troubleshoot integration sessions
Deployment: Generate scenarios, load plans, and versioned transports
Capstone project: Real-world delivery end-to-end workflow
Career readiness: Resume support, interview prep, certification guidance
Our Upcoming Batches
At Topskill.ai, we understand that today’s professionals navigate demanding schedules.
To support your continuous learning, we offer fully flexible session timings across all our trainings.
Below is the schedule for our Training. If these time slots don’t align with your availability, simply let us know—we’ll be happy to design a customized timetable that works for you.
Training Timetable
| Batches Online/Offline | Batch Start Date | Session Days | Time Slot (IST) | Fees |
|---|---|---|---|---|
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 11:00 AM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 5:00 PM (Class 1-1.30 Hrs) | View Fees |
| Week Days (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Mon-Fri | 7:00 PM (Class 1-1.30 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 7:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 10:00 AM (Class 3 Hrs) | View Fees |
| Weekends (Virtual Online) | Aug 28, 2025 Sept 4th, 2025 Sept 11th, 2025 | Sat-Sun | 11:00 AM (Class 3 Hrs) | View Fees |
For any adjustments or bespoke scheduling requests, reach out to our admissions team at
support@topskill.ai or call +91-8431222743.
We’re committed to ensuring your training fits seamlessly into your professional life.
Note: Clicking “View Fees” will direct you to detailed fee structures, instalment options, and available discounts.
Don’t see a batch that fits your schedule? Click here to Request a Batch to design a bespoke training timetable.
Corporate Training
“Looking to give your employees the experience of the latest trending technologies? We’re here to make it happen!”
