Oracle Data Integrator 12c: Integration and Administration Ed 3

Course code

ODI12cIA

Duration

5 Days, 40 Acad. Hours

Download pdf

Course Overview

Objectives

Prerequisites

Course Outline

Course Overview

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.

Objectives

Course Objectives

Administer ODI resources and setup security with ODI
Apply ODI Topology concepts for data integration
Describe ODI Model concepts
Describe the architecture of Oracle Data Integrator 12c
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
Integrate ODI with Version Control Systems (Subversion)
Extend ODI to include the Big Data Hadoop ecosystem

Prerequisites

Suggested Prerequisite

Basic knowledge of ELT data processing

Audience

Database Administrators
Business Analysts
Technical Consultant
Data Modelers
SOA Architect
Data Scientist
Data Warehouse Administrator

Course Outline

Course Topics

1. Introduction

Overview of ODI Components
Overview of Oracle Data Integrator Repositories
Identifying the Course Units
Types of ODI Agents
Overview of ODI Architecture
About Graphical Modules
Why Oracle Data Integrator?

2. Administering ODI Repositories and Agents

Creating a Wallet to Securely Store Credentials
Administrating the ODI Repositories
Creating Repository Storage Spaces
Creating and Connecting to the Work Repository
Managing ODI Agents
Creating and Connecting to the Master Repository

3. ODI Topology Concepts

Overview of ODI Topology
Defining a Topology
Planning the Topology
About Data Servers and Physical Schemas
Mapping Logical and Physical Resources
Defining the Logical Architecture
Defining Agents
Defining the Physical Architecture

4. Describing the Physical and Logical Architecture

Creating Logical Architecture
Testing a Data Server Connection
Overview of Logical Architecture and Context Views
Creating a Physical Schema
Creating Physical Architecture
Creating a Data Server
Overview of Topology Navigator
Linking the Logical and Physical Architecture

5. Setting Up a New ODI Project

Overview of ODI Projects
Creating and Maintaining Folders
Creating and Labeling with Markers
Exporting and Importing Objects
Creating a New Project
Understanding Knowledge Modules
Exchanging ODI Objects and Sharing Global Objects
Organizing Projects and Folders

6. Oracle Data Integrator Model Concepts

Creating Data stores
Organizing Models
Understanding Metadata in ODI
What is a Model?
Creating Models
Creating Keys and References
Understanding Reverse Engineering
Configuring Constraints in ODI

7. Organizing ODI Models and Creating Data stores

What is a Filter?
What is a Constraint?
Creating a Basic Mapping
Business Rules for Mappings
What is a Mapping?
What is a Join?
What is a Staging Area?

8. ODI Mapping Concepts

Mapping with Knowledge Modules (KM)
Execution Location
Creating an Intermediate Mapping
What is a Staging Area?
What is a Mapping, a Filter, a Join?
What is a Mapping?
Overview of Integration Process
Business Rules for Mapping

9. Designing Mappings

Creating Joins
Filtering Data
Multiple Source Data stores
Designing a Mapping
Overview of the Flow
Selecting Knowledge Modules
Disabling Transformations
Specifying the Staging Area

10. Mapping: Monitoring and Debugging

How to Troubleshoot a Session
Tips for Preventing Errors
Monitoring Mappings
Keys to Reviewing the Generated Code
Working with Errors
Viewing Sessions and Tasks
How to Monitor Execution of a Mapping
Creating Objects with Operator

11. Designing Mappings: Advanced Topics 1

Mapping with Business Rules
Creating User Functions
Mapping Substitution Methods
Modifying a KM
Showing Variable Values in Log
Creating and Tracking Variables
Customizing Reverse Engineering Using RKM
Overview of Business Rule Elements

12. Designing Mappings: Advanced Topics 2

Using Substitution Methods
Developing Your Own Knowledge Module
Using User Functions
Reusable Mappings
Creating a User Function
Using Partitioning in a Mapping
Derived Select (Subselect) for Reusable Mappings

13. Using ODI Procedures

What is a Procedure?
Adding Commands
Examples of Procedures
Viewing Results with Operator Navigator
Running a Procedure
Adding Options
Creating Procedures

14. Using ODI Packages

Variable Steps
Controlling the Execution Path
Error Handling
Review of Package Steps
Executing a Package
What is a Package?
Creating Model, Submodel and Datastore Steps
Creating a Package

15. Step-by-Step Debugger

Menu Bar Icons
Screen Step Numbering
Control Execution Flow
Specifying Debug Properties
New Functionality
Starting a Session in Debug mode

16. Managing ODI Scenarios

Generating a Scenario
What is a Scenario?
Scheduling the ODI Scenario
Managing Schedules
Executing a Scenario
Automating Scenario Management

17. Using Load Plans

Defining the Restart Behavior
What Are Load Plans?
Load Plan Editor
Load Plan Steps
Benefits of Using Load Plans
Handling Failed Load Plans

18. Enforcing Data Quality with ODI

Why Data Quality? When to Enforce Data Quality?
Data Quality in Source Applications
Enabling Static or Flow Control for a Mapping
Data Quality Business Rules
Data Quality Control in the Integration Process
Data Quality in the Target Applications
Setting the Options, Selecting Which Constraints to Enforce
Reviewing Erroneous Records

19. Working with Changed Data Capture (CDC)

Journalizing
Oracle GoldenGate Integration
Changed Data Capture in ODI
Viewing Data/Changed data
CDC Strategies and Infrastructure
Why Changed Data Capture? Techniques of Changed Data Capture
CDC Consistency
Creating Change Data Capture (CDC)

20. Advanced ODI Administration

Generating Topology Reports
Integration of ODI with Enterprise Manager
Java EE Agent and Enterprise Manager Configuration with WebLogic Domain
Defining Password Policies
Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
Introduction to ODI Security Navigator. Security Concepts: Overview, Defining Security Policies
Implementing External Authentication
Using ODI Console

21. Integrating ODI with Subversion

Configuring the Subversion Repository with ODI
Creating Full or Partial Tags in the Subversion Repository
SVN Connections
Performing a Branch Merge
Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN
ODI: VCS Integration
Creating a New Version for an Object. Creating Full or Partial Tags in the Subversion Repository
ODI: Selecting the Required VCS

22. Integrating Big Data with ODI