0345 4506120

Oracle 12c Data Integrator (ODI)

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

Target Audience:

Data Warehouse Administrator

Data Warehouse Analyst


Business Analysts



Learning Objectives

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 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


BI Knowledge
Data Warehouse Design
Knowledge of ETL

Course Content

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 Troubleshooting Keys to Reviewing the Generated Code Errors 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

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.


Virtual Classroom

Virtual classrooms provide all the benefits of attending a classroom course without the need to arrange travel and accomodation. Please note that virtual courses are attended in real-time, commencing on a specified date.

Virtual Course Dates

Our Customers Include