Description

Duration

3 Days

18 CPD hours

This course is intended for

This intermediate-level hands-on course is geared for experienced Administrators, Analysts, Architects, Data Scientists, Database Administrators and Implementers

Overview

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

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

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 Images

Oracle Data Integrator 19c Configuration and Administration (TTOR30319)

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews