Oracle Data Integrator (ODI)

Module 1: Introduction to Oracle Data Integrator

• Overview of Oracle Data Integrator (ODI)
• ODI vs. traditional ETL tools
• ODI architecture: Master and work repositories
• E-LT approach vs. ETL
• ODI 12c and ODI on OCI

Module 2: ODI Architecture and Components

• ODI Studio modules: Designer, Operator, Topology, Security
• ODI Agent types: Standalone, JEE, Colocated
• Repository setup with RCU
• ODI domain on WebLogic
• ODI configuration best practices

Module 3: ODI Topology Setup

• Physical and logical architecture
• Data server and physical schema setup
• Logical schema and context
• Technology setup for Oracle, SQL Server, files
• ODI agent configuration and testing

Module 4: ODI Data Models

• Datastore and model creation
• Reverse-engineering from databases
• Constraints and keys in ODI models
• Flexible reverse engineering
• Model folders and organisation

Module 5: ODI Mappings

• Mapping designer canvas
• Source and target datastores
• Attribute mapping and expressions
• Lookup and filter components
• Mapping execution units

Module 6: Knowledge Modules (KMs)

• Types: LKM, IKM, CKM, JKM, RKM, SKM
• Selecting KMs for performance
• Customising knowledge modules
• KM substitution methods
• KM best practices for Oracle targets

Module 7: ODI Procedures and Variables

• ODI procedures for custom SQL
• Variable creation and refresh
• Sequence variables
• Using variables in mappings and packages
• Global and project-level variables

Module 8: ODI Packages and Load Plans

• Package designer and steps
• Conditional branching in packages
• Load plan design for parallel execution
• Exception handling in load plans
• Scheduling packages and load plans

Module 9: ODI for Big Data

• ODI with Hadoop and Hive
• Spark execution unit in ODI
• Kafka integration with ODI
• ODI on OCI Big Data Service
• Big Data KMs in ODI

Module 10: ODI Monitoring and Administration

• Operator module for job monitoring
• Session log analysis
• Error handling and retry logic
• ODI repository maintenance
• Performance tuning for ODI mappings

Module 11: ODI on Oracle Cloud

• ODI Marketplace on OCI
• Oracle Data Integration on OCI
• ODI with ADW and ATP
• Cloud-to-cloud data integration
• Migration from ODI on-premises to OCI

Module 12: Real-Time Projects and Case Studies

• Enterprise ETL pipeline with ODI
• Oracle to Oracle data migration
• End-to-end ODI implementation project
• Certification and interview preparation

Experience in the Industry Gain knowledge from experts with hands-on Oracle Data Integrator project experience in enterprise data integration and ETL pipelines.

Backgrounds at the Top Prominent corporations such as HCL, TCS, Accenture, and Oracle Consulting employ our ODI trainers.

Clear & Effective Teaching Excellent communication and real-world examples simplify complex ODI architecture, knowledge modules, and mapping design.

Hands-On Learning Focus Students apply skills using live ODI Studio environments with real data integration and migration projects.

Up-to-Date Knowledge Trainers stay current with ODI 12c, OCI Data Integration, Big Data KMs, and latest integration best practices.