Professional Course

Oracle Data Integrator 19c Configuration and Administration

3 days
3 days
This provider usually responds within 48 hours 👍

Course description

Oracle Data Integrator 19c Configuration and Administration

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.

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.

This course is approximately50% 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

Trivera offers hundreds of end-to-end skills-focused courses that provide participants with the job-ready skills they require to be truly productive in a modern IT business enterprise. Our courses are available for individuals, their teams, or across their organization, for students of all skill levels and roles.  We offer an extensive online Public Course Schedule, deep catalog for Private Courses, flex-hour Mini-Camp short courses, self-paced QuickSkills courses, free webinars and more.  Trivera’s unique EveryCourse Extras and AfterCourse Extras programs, included with every course, ensure our students can put their newly-learned skills right to work, while providing them with a solid platform for continued skills-development, support and long-term growth.   For more information about our dedicated training services, public course offerings, collaborative coaching services, new hire or enterprise upskilling programs, or to see our complete list of course offerings and special offers please call us toll free at 844-475-4559. Our pricing and services are always satisfaction guaranteed.

Do you work at this company and want to update this page?

Is there out-of-date information about your company or courses published here? Fill out this form to get in touch with us.

Who should attend?

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.

Training content

  1. Introduction to Integration and Administration
    • Oracle Data Integrator: Introduction
    • Oracle Data Integrator Repositories
  2. 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
  3. ODI Topology Concepts
    • ODI Topology: Overview
    • Data Servers and Physical Schemas
    • Defining Topology
    • Agents in Topology
    • Planning a Topology
  4. Describing the Physical and Logical Architecture
    • Topology Navigator
    • Creating Physical Architecture
    • Creating Logical Architecture
  5. Setting Up a New ODI Project
    • ODI Projects
    • Using Folders
    • Understanding Knowledge Modules
    • Exporting and Importing Objects
    • Using Markers
  6. Oracle Data Integrator Model Concepts
    • Understanding the Relational Model
    • Understanding Reverse-Engineering
    • Creating Models
  7. 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
  8. 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
  9. 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
  10. Mappings: Monitoring and Troubleshooting
    • Monitoring Mappings
    • Working with Errors
  11. Designing Mappings: Advanced Topics 1
    • Working with Business Rules
    • Using Variables
    • Datasets and Sets
    • Using Sequences
  12. Designing Mappings: Advanced Topics 2
    • Partitioning
    • Configuring Reusable Mappings
    • Using User Functions
    • Substitution Methods
    • Modifying Knowledge Modules
  13. Using ODI Procedures
    • Procedures: Overview
    • Creating a Blank Procedure
    • Adding Commands
    • Adding Options
    • Running a Procedure
  14. Using ODI Packages
    • Packages: Overview
    • Executing a Package
    • Review of Package Steps
    • Model, Submodel, and Datastore Steps
    • Variable Steps
    • Controlling the Execution Path
  15. Step-by-Step Debugger
    • Starting a Debug Session
    • New Functions
    • Menu Bar Icons
  16. Managing ODI Scenarios
    • Scenarios
    • Managing Scenarios
    • Preparing for Deployment
  17. Using Load Plans
    • What are load plans?
    • Load plan editor
    • Load plan step sequence
    • Defining restart behavior
  18. Enforcing Data Quality with ODI
    • Data Quality
    • Business Rules for Data Quality
    • Enforcing Data Quality with ODI
  19. Working with Changed Data Capture
    • CDC with ODI
    • CDC implementations with ODI
    • CDC implementation techniques
    • Journalizing
    • Results of CDC
  20. Advanced ODI Administration
    • Setting Up ODI Security
    • Managing ODI Reports
    • ODI Integration with Java EE

Course delivery details

Student Materials: Each participant will receive a Student Guide with course notes, code samples, software tutorials, step-by-step written lab instructions, diagrams and related reference materials and resource links. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Setup Made Simple. All course labs and solutions, data sets, Oracle software (limited version, for course use only), detailed courseware, lab guides and resources (as applicable) are provided for attendees in our easy access, no installation required, remote lab environment for the duration of the course. Our tech team will help set up, test and verify lab access for each attendee prior to the course start date, ensuring a smooth start to class and successful hands-on course experience for all participants.


  • Price: 2,495.00
  • Discounted Price: 1,621.75

Why choose Trivera Technologies LLC?

Over 25 years of technology training expertise.

Robust portfolio of over 1,000 leading edge technology courses.

Guaranteed to run courses and flexible learning options.

Contact this provider

Contact course provider

Before we redirect you to this supplier's website, do you mind filling out this form so that we can stay in touch? You can unsubscribe at any time.
If you want us to recommend other suitable courses, please fill out all fields below and check the box beside "Please recommend similar options"
Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Trivera Technologies LLC
7862 West Irlo Bronson Highway
STE 626
Kissimmee FL 34747

Trivera Technologies

Trivera Technologies is a IT education services & courseware firm that offers a range of wide professional technical education services including: end to end IT training development and delivery, skills-based mentoring programs,new hire training and re-skilling services, courseware licensing and...

Read more and show all training delivered by this supplier