0845 450 6120

Oracle 12c Data Integrator (ODI)

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


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

One Month
Two Months
Three Months
More than Three Months
PRINCE2 Foundation & Practitioner
MSP Foundation & Practitioner
APMP Certificate
ITIL Foundation
Scrum in One Day
Certified ScrumMaster
ISTQB Software Test Foundation
Microsoft Project
BCS Business Analysis Practice
Other - Please Specify Below

Our Customers Include