Download Course Outline

Oracle Data Integrator 19c (ODI) Configuration and Administration

Explore How to Centralize Data Across Databases, Perform Integration, Designing ODI Mappings, Setting ODI Security and More

Course Code: TTOR30319

Skill Level: Intermediate

Duration: 3 Days

Course Overview

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements from high-volume, high-performance batch loads, to event-driven integration processes and SOA-enabled data services. Oracle Data Integrator's Extract, Load, Transform (E-LT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.

Throughout this course participants will explore how to centralize data across databases, performing integration, designing ODI Mappings, and setting up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem, allowing administrators and data scientists to farm out map-reduce operations from established relational databases to Hadoop. They can also read back into the relational world the results of complex Big Data analysis for further processing.

Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:

Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe architecture of Oracle Data Integrator
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI

Need different skills or topics? If your team requires different topics or tools, additional skills or custom approach, this course may be further adjusted to accommodate. We offer additional Oracle, database, scripting, administration and other related topics that may be blended with this course for a track that best suits your needs.

NOTE: This is independent, adjustable content that aligns with current topics, skills and tools that participants need to excel in these areas. This course is for 19c. It is also may be available for earlier editions (11g, 12c, etc). Please inquire for details.

Course Objectives

This course is approximately 50% hands-on, combining expert lecture, real-world demonstrations and group discussions with machine-based practical labs and exercises. Working in a hands-on learning environment led by our Oracle Certified expert facilitator, students will learn how to:

Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe architecture of Oracle Data Integrator
Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Implement Changed Data Capture with ODI

Course Prerequisites

This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers. Please see the Related Courses tab for specific Pre-Requisite courses, Related Courses that offer similar skills or topics, and next-step Learning Path recommendations.

Course Agenda

Please note that this list of topics is based on our standard course offering, evolved from typical industry uses and trends. We’ll work with you to tune this course and level of coverage to target the skills you need most.

Introduction to Integration and Administration

Oracle Data Integrator: Introduction
Oracle Data Integrator Repositories

Administering ODI Repositories

Create and connect to the Master Repository
Export and import the Master Repository
Create, connect, and set a password to the Work Repository

ODI Topology Concepts

ODI Topology: Overview
Data Servers and Physical Schemas
Defining Topology
Agents in Topology
Planning a Topology

Describing the Physical and Logical Architecture

Topology Navigator
Creating Physical Architecture
Creating Logical Architecture

Setting Up a New ODI Project

ODI Projects
Using Folders
Understanding Knowledge Modules
Exporting and Importing Objects
Using Markers

Oracle Data Integrator Model Concepts

Understanding the Relational Model
Understanding Reverse-Engineering
Creating Models

Organizing ODI Models and Creating ODI Datastores

Organizing Models
Creating Datastores
Constraints in ODI
Creating Keys and References
Creating Conditions
Exploring Your Data
Constructing Business Rules

ODI Mapping Concepts

ODI Mappings
Expressions, Join, Filter, Lookup, Sets, and Others
Behind the Rules
Staging Area and Execution Location
Understanding Knowledge Modules
Mappings: Overview

Designing Mappings

Multiple Sources and Joins
Filtering Data
Overview of the Flow in ODI Mapping
Selecting a Staging Area
Configuring Expressions
Execution Location
Selecting a Knowledge Module

Mappings: Monitoring and Troubleshooting

Monitoring Mappings
Working with Errors

Designing Mappings: Advanced Topics 1

Working with Business Rules
Using Variables
Datasets and Sets
Using Sequences

Designing Mappings: Advanced Topics 2

Partitioning
Configuring Reusable Mappings
Using User Functions
Substitution Methods
Modifying Knowledge Modules

Using ODI Procedures

Procedures: Overview
Creating a Blank Procedure
Adding Commands
Adding Options
Running a Procedure

Using ODI Packages

Packages: Overview
Executing a Package
Review of Package Steps
Model, Submodel, and Datastore Steps
Variable Steps
Controlling the Execution Path

Step-by-Step Debugger

Starting a Debug Session
New Functions
Menu Bar Icons

Managing ODI Scenarios

Scenarios
Managing Scenarios
Preparing for Deployment

Using Load Plans

What are load plans?
Load plan editor
Load plan step sequence
Defining restart behavior

Enforcing Data Quality with ODI

Data Quality
Business Rules for Data Quality
Enforcing Data Quality with ODI

Working with Changed Data Capture

CDC with ODI
CDC implementations with ODI
CDC implementation techniques
Journalizing
Results of CDC

Advanced ODI Administration

Setting Up ODI Security
Managing ODI Reports
ODI Integration with Java

Course Materials

Student Materials & Lab Environment All course software (limited versions, for course use only), courseware files or course notes (as applicable), labs / data sets and solutions (as applicable) are provided for you in our “easy access / no install required” high-speed remote lab environment. Our dedicated tech team works with every student to ensure everyone is set up with working access and ready to go prior to every course start date, ensuring a smooth delivery and great hands-on experience.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

Mix, Match & Master!
2FOR1: Two Courses, One Price!
Enroll in *any* two public courses (for 2023 *OR* 2024 dates!) by December 31, for one price! Learn something new, or share the promo!

Click for Details & Additional Offers

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course

Gain the skills you need with less time in the classroom with our short course, live-online hands-on events

Trivera QuickSkills: Free Courses and Webinars

Training on us! Keep your skills current with free live events, courses & webinars

Trivera AfterCourse: Coaching and Support

Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Excellent detail about the Spring framework which directly relates to my role as a senior engineer. I found the content and style to be very enjoyable, and would encourage me to ask questions where previously I might not have paid much attention, eg. pom version numbers / spring starters being imported. The focus on the different styles of unit testing was also excellent and I would plan to incorporate in day to day work.

Edward K

The instructor was clearly knowledgeable about Java and programming in general. He was very attentive to every student's individual needs and constantly encouraged questions, concerns, student issues to be raised and addressed each one thoroughly.

Mark M

First time in my life I have attended remote class and I find it great. Personally I don't feel there is any area which require improvement!

Rishi M

Excellent training. Even though it was online, I did not have any issues understanding or getting the answers for the questions I had. The lab exercises are interesting to apply what was learnt. Overall very good training. Thank you!

Anitha

Best programming class I've ever been in, head and shoulders above any thing I took in college as part of a computer science degree. The instructor was thorough and very detailed, he was very good abut explaining all possible scenarios a situation would apply to. The way the albs were structured and the class was conducted was very good for interaction and hand on learning.

Danish J

A very good balance of teaching time to lab time. I've done other courses that I found to be much lighter on content and heavy on labs to waste time. This was a refreshing change of pace.

Adam G

Great job overall. Great communicator and explained complex concepts in a simple, easier to understand format.

Jeremy G

Instructor was beyond phenomenal. He had an in depth knowledge of the course material and always ensured that everyone understood what was being discussed. I really enjoyed the mix of theory and practical examples of each part of the course.

Cillian M

Both the instructor and the course material were very thorough - the course material has many helpful references - the labs were well laid out, making it easy to learn from and get done on time

Steve C.

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More