Отримати консультацію
Training Center MUKКурсыOracleMiddlewareOracle Data Integrator 12c: Integration and Administration Ed 3

Oracle Data Integrator 12c: Integration and Administration Ed 3

Код курсу
5 Днів, 40 Ак. Годин
Опис курсу
Програма курсу
Опис курсу

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.


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

Suggested Prerequisite

  • Basic knowledge of ELT data processing


  • Database Administrators
  • Business Analysts
  • Technical Consultant
  • Data Modelers
  • SOA Architect
  • Data Scientist
  • Data Warehouse Administrator
Програма курсу

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

  • Emergence of Apache Hadoop. Hadoop Ecosystem
  • Big Data Concepts
  • ODI: Hadoop Integration Process
  • Big Data Knowledge Modules Matrix
  • Apache HBase, Apache Hive, Apache Pig. Apache Spark, Apache Sqoop, Apache Oozie
  • Hadoop Data Integration: Overview
Реєстрація на найближчий курс
Oracle Data Integrator 12c: Integration and Administration Ed 3
Код курсу:
5 Днів, 40 Ак. Годин
Місце проведення
Отримати консультацію
Свяжитесь со мной
Отримати консультацію
Отправить заявку
Реєстрація на вебінар
Отправить заявку
Ваша заявка отримана!
Ми зв`яжимося з вами найближчим часом.