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