Oracle Data Integrator (ODI) and Data Pipelines

Knowledge Modules are the concept that makes or breaks an ODI developer. They separate what a mapping does from how it is executed, so the same logical design can run against different technologies by swapping the module rather than rewriting the job. Delegates who grasp this early write ODI that scales; those who do not end up embedding procedural logic and lose the platform's main advantage.

The declarative model receives the same emphasis. In ODI a developer specifies the desired end state and the system determines the execution path. Developers arriving from procedural ETL tools consistently fight this at first, so the course addresses it directly rather than assuming it will be absorbed.

Delegates build a working warehouse load through the course: source models, mappings, packages, load plans, error handling and scheduling, executed against real databases with the generated SQL inspected at each stage.

Self-paced course

₹15,000

or start with ₹5,000 and pay the balance within 3 months

Pay in full ₹15,000

○ Lessons, videos and quizzes from ₹5,000
🔒 Lab recordings at ₹15,000
🔒 Certification exam at full payment
○ Optional real lab: ₹5,000 per month (after full payment)

Valid 12 months from your first payment. Refund policy

Responsible	XertApp
Last Update	10/28/2026
Completion Time	15 hours 59 minutes
Members	1

Career Courses Oracle Courses Data & Analytics

Module 1 — Architecture (empty)

12Lessons · 1 hr 36 min
- 1.1 Video: E-LT versus conventional ETL
  
  New
- 1.1 E-LT versus conventional ETL
  
  New
- 1.2 Video: Master and Work repositories
  
  New
- 1.2 Master and Work repositories
  
  New
- 1.3 Video: Studio, agents and the runtime
  
  New
- 1.3 Studio, agents and the runtime
  
  New
- 1.4 Video: Standalone, colocated and Java EE agents
  
  New
- 1.4 Standalone, colocated and Java EE agents
  
  New
- 1.5 Video: ODI 12c, 14c and ODI on Marketplace
  
  New
- 1.5 ODI 12c, 14c and ODI on Marketplace
  
  New
- 1.L Lab: Planning repositories and agents
  
  Lab New
- Module 1 Quiz: Architecture
  
  New 10 xp
Module 2 — Topology and security (empty)

12Lessons · 1 hr 32 min
- 2.1 Video: Physical and logical architecture
  
  New
- 2.1 Physical and logical architecture
  
  New
- 2.2 Video: Data servers, physical schemas and contexts
  
  New
- 2.2 Data servers, physical schemas and contexts
  
  New
- 2.3 Video: Promoting across environments with contexts
  
  New
- 2.3 Promoting across environments with contexts
  
  New
- 2.4 Video: Users, profiles and object-level security
  
  New
- 2.4 Users, profiles and object-level security
  
  New
- 2.5 Video: Creating repositories with the RCU
  
  New
- 2.5 Creating repositories with the RCU
  
  New
- 2.L Lab: Building topology with contexts
  
  Lab New
- Module 2 Quiz: Topology and Security
  
  New 10 xp
Module 3 — Models and datastores (empty)

12Lessons · 1 hr 31 min
- 3.1 Video: Reverse engineering
  
  New
- 3.1 Reverse engineering
  
  New
- 3.2 Video: Datastores, columns and metadata
  
  New
- 3.2 Datastores, columns and metadata
  
  New
- 3.3 Video: Constraints, keys and references
  
  New
- 3.3 Constraints, keys and references
  
  New
- 3.4 Video: Data quality control and error tables
  
  New
- 3.4 Data quality control and error tables
  
  New
- 3.5 Video: Static and flow control
  
  New
- 3.5 Static and flow control
  
  New
- 3.L Lab: Reverse engineering and data quality checks
  
  Lab New
- Module 3 Quiz: Models and Datastores
  
  New 10 xp
Module 4 — Mappings (empty)

12Lessons · 1 hr 31 min
- 4.1 Video: Mapping components and the logical diagram
  
  New
- 4.1 Mapping components and the logical diagram
  
  New
- 4.2 Video: Joins, filters, aggregates, splits and sets
  
  New
- 4.2 Joins, filters, aggregates, splits and sets
  
  New
- 4.3 Video: Expressions, lookups and datasets
  
  New
- 4.3 Expressions, lookups and datasets
  
  New
- 4.4 Video: Execution location
  
  New
- 4.4 Execution location
  
  New
- 4.5 Video: Generated SQL and reusable mappings
  
  New
- 4.5 Generated SQL and reusable mappings
  
  New
- 4.L Lab: Building the daily sales mapping
  
  Lab New
- Module 4 Quiz: Mappings
  
  New 10 xp
Module 5 — Knowledge Modules (empty)

12Lessons · 1 hr 32 min
- 5.1 Video: Knowledge Module types
  
  New
- 5.1 Knowledge Module types
  
  New
- 5.2 Video: Selecting KMs for technology pairs
  
  New
- 5.2 Selecting KMs for technology pairs
  
  New
- 5.3 Video: Integration strategies
  
  New
- 5.3 Integration strategies
  
  New
- 5.4 Video: Customising KMs
  
  New
- 5.4 Customising KMs
  
  New
- 5.5 Video: Writing a KM from scratch
  
  New
- 5.5 Writing a KM from scratch
  
  New
- 5.L Lab: Choosing Knowledge Modules and SCD history
  
  Lab New
- Module 5 Quiz: Knowledge Modules
  
  New 10 xp
Module 6 — Packages and orchestration (empty)

12Lessons · 1 hr 31 min
- 6.1 Video: Package design
  
  New
- 6.1 Package design
  
  New
- 6.2 Video: ODI tools in packages
  
  New
- 6.2 ODI tools in packages
  
  New
- 6.3 Video: Variables
  
  New
- 6.3 Variables
  
  New
- 6.4 Video: Branching and loops
  
  New
- 6.4 Branching and loops
  
  New
- 6.5 Video: Procedures and user functions
  
  New
- 6.5 Procedures and user functions
  
  New
- 6.L Lab: A file-driven package with variables
  
  Lab New
- Module 6 Quiz: Packages and Orchestration
  
  New 10 xp
Module 7 — Execution and operations (empty)

12Lessons · 1 hr 31 min
- 7.1 Video: Scenarios
  
  New
- 7.1 Scenarios
  
  New
- 7.2 Video: Load plans
  
  New
- 7.2 Load plans
  
  New
- 7.3 Video: Scheduling
  
  New
- 7.3 Scheduling
  
  New
- 7.4 Video: Operator, sessions and logs
  
  New
- 7.4 Operator, sessions and logs
  
  New
- 7.5 Video: Error handling, restarts and repository maintenance
  
  New
- 7.5 Error handling, restarts and repository maintenance
  
  New
- 7.L Lab: Load plans, scheduling and recovery
  
  Lab New
- Module 7 Quiz: Execution and Operations
  
  New 10 xp
Module 8 — Change data capture and GoldenGate (empty)

12Lessons · 1 hr 31 min
- 8.1 Video: Journalizing: simple and consistent set
  
  New
- 8.1 Journalizing: simple and consistent set
  
  New
- 8.2 Video: Journalizing Knowledge Modules
  
  New
- 8.2 Journalizing Knowledge Modules
  
  New
- 8.3 Video: GoldenGate architecture
  
  New
- 8.3 GoldenGate architecture
  
  New
- 8.4 Video: Integrating GoldenGate with ODI
  
  New
- 8.4 Integrating GoldenGate with ODI
  
  New
- 8.5 Video: Batch or real-time
  
  New
- 8.5 Batch or real-time
  
  New
- 8.L Lab: Near-real-time orders with GoldenGate and ODI
  
  Lab New
- Module 8 Quiz: CDC and GoldenGate
  
  New 10 xp
Module 9 — Advanced development (empty)

12Lessons · 1 hr 31 min
- 9.1 Video: Complex files and XML
  
  New
- 9.1 Complex files and XML
  
  New
- 9.2 Video: Groovy scripting and the ODI SDK
  
  New
- 9.2 Groovy scripting and the ODI SDK
  
  New
- 9.3 Video: Bulk processing and performance
  
  New
- 9.3 Bulk processing and performance
  
  New
- 9.4 Video: Web services and enterprise integration
  
  New
- 9.4 Web services and enterprise integration
  
  New
- 9.5 Video: Version control and lifecycle
  
  New
- 9.5 Version control and lifecycle
  
  New
- 9.L Lab: Automating with the SDK and faster loads
  
  Lab New
- Module 9 Quiz: Advanced Development
  
  New 10 xp
Module 10 — Cloud pipelines and exam readiness (empty)

12Lessons · 1 hr 31 min
- 10.1 Video: Loading Autonomous Data Warehouse
  
  New
- 10.1 Loading Autonomous Data Warehouse
  
  New
- 10.2 Video: Object Storage sources and targets
  
  New
- 10.2 Object Storage sources and targets
  
  New
- 10.3 Video: ODI, OCI Data Integration and OIC
  
  New
- 10.3 ODI, OCI Data Integration and OIC
  
  New
- 10.4 Video: Migrating from Informatica and DAC
  
  New
- 10.4 Migrating from Informatica and DAC
  
  New
- 10.5 Video: Preparing for the ODI exam
  
  New
- 10.5 Preparing for the ODI exam
  
  New
- 10.L Lab: Loading Autonomous Data Warehouse from Object Storage
  
  Lab New
- Module 10 Quiz: Cloud Pipelines and Exam Readiness
  
  New 10 xp
Final Certification (empty)

1Lessons · 40 min
- Certification Exam: Oracle Data Integrator (ODI) and Data Pipelines
  
  New

Who should attend

Aimed at developers and engineers building data integration pipelines on Oracle technology.

ETL developers migrating from Informatica PowerCenter or other conventional tools
Data engineers building warehouse and lakehouse loads
Data warehouse teams replacing retired tooling such as DAC
Oracle DBAs taking on data movement responsibility
BI developers who need to control their own source loads
Integration consultants extending into bulk data movement

Assumed knowledge: competent SQL and familiarity with relational database concepts and data warehouse design. Prior ETL experience in any tool is helpful but not required. Java or Groovy experience assists the advanced scripting module but is not a prerequisite.

Delivery

Duration
40 hours, delivered as weekday evenings or weekend sessions.

Format
Live instructor-led online, with recordings available to delegates for the duration of the programme. On-site corporate delivery available on request.

Lab environment
Each delegate receives a dedicated ODI environment with source and target databases for the duration of the course and for four weeks afterwards.

Included
Course notes, lab guides, exercise solutions and a certificate of completion.

How to enroll

Enrol and pay online on this page. The full fee is ₹15,000 (US$170). You can start with ₹5,000 (US$60) and pay the balance in instalments within 3 months. Pay by card, UPI or net banking, or by PayPal in US dollars. Go to payment. For corporate, on-site or one-to-one training, contact contact@appsolworld.com or call +91 92051 38405.