Oracle 12c Data Integrator (ODI)

Course code: O1223

4 days £2,200.00

Oracle 12c ODI Data Integrator course; hands on training exploring ODI architecture, administration and key functionality and integration.

Course content >

Who Should Attend?

Data Warehouse Administrator

Data Warehouse Analyst


Business Analysts



BI Knowledge
Data Warehouse Design
Knowledge of ETL

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

14 Apr 2020 Virtual Delegates:    £2,200.00
04 May 2020 London Delegates:    £2,200.00
13 Jul 2020 London Delegates:    £2,200.00

Course Contents

Oracle 12c Data Integrator, built on high performance ELT, platform flexibility and intuitive user experience is a key component and latest version of Oracle's complete OBI offering and enterprise data integration platform. Designed around continuous hands on labs iTrain's course provides attendees with essential skills and hands on experience to fully harness it's enterprise potential.

The course will explore the product from architectural, implementation and best use perspectives, provding attendees with understanding how ODI maximises next generation Extract-Load-Transformation technology to provde crucial analytics and true business intelligence - converting data into a business asset; information.


Attendees will start with basic blocking and interfaces creation through to more complex, advanced aspects of ODI including data workflows, management and monitoring, scheduling and impact analysis learning how to implement, administer and manage high volume movement and transformation of data between disparate platforms


As with all iTrain courses ODI can be delivered as a closed course on your site or a third party location. As company specific training iTrain will work with you to tailor content to your organisation and project's specific requirement and objectives. To assist with this iTrain provide a full mobile classroom the Classroom in a Box.

Oracle Data Integrator
Information, not data
ODI Architecture
ODI Components
Graphical Modules
ODI Agents
Oracle Data Integrator Repositories overview

Administering ODI Repositories and Agents

Administrating the ODI Repositories
Creating Repository Storage Spaces
Creating and Connecting to the Master Repository
Creating and Connecting to the Work Repository
Creating a Wallet to Securely Store Credentials
Managing ODI Agents
Creating a Physical Agent

ODI Topology Concepts
Overview of ODI Topology
About Data Servers and Physical Schemas
Defining the Physical Architecture
Defining the Logical Architecture
Mapping Logical and Physical Resources

Setting Up a New ODI Project
Creating a New Project
Creating and Maintaining Folders
Organizing Projects and Folders
Exchanging ODI Objects and Sharing Global Objects
Object export and import
Creating and Labeling with Markers

Oracle Data Integrator Model Concepts

Model overview
Understanding Metadata in ODI
Understanding Reverse Engineering
Creating Models
Organizing Models
Creating Data stores
Configuring Constraints in ODI
Creating Keys and References

Organizing ODI Models and Creating Data Stores

What is a Mapping?
Business Rules for Mappings
Creating a Basic
Mapping What is a Join?
What is a Filter?
What is a Constraint?
What is a Staging Area?

ODI Mapping Concepts

What is a Mapping?
Business Rules for Mapping
What is a Mapping, a Filter, a Join?
Overview of Integration Process
What is a Staging Area?
Execution Location
Creating an Intermediate Mapping

Designing Mappings

Designing a Mapping
Multiple Source
Data stores
Creating Joins
Filtering Data
Disabling Transformations
Overview of the Flow
Specifying the Staging Area

Mapping: Monitoring and Debugging

Monitoring Mappings
Objects with Operator
Sessions and Tasks
Monitoring Execution of a Mapping
Keys to Reviewing the Generated Code

Creating and Running ODI Procedures

Creating Procedures
Adding Commands
Adding Options
Running a Procedure
Viewing Results with Operator

Using ODI Packages

Creating a Package
Executing a Package
Creating Advanced Packages
Error Handling
Controlling an Execution Path
Creating a Loop
Using the Advanced tab

ODI Scenarios and Versions

Managing Scenarios with Load Plans
Preparing Scenarios for Deployment
Automating Scenario Management
Scheduling the ODI Scenario
Overview of ODI version management
Handling concurrent changes

Contact us for more information