Oracle Data integrator 12c – Developer

Oracle Data Integrator 12c Developer
Intended for Administrators and Developers
Prerequisites None
Duration 3 days
Code EDU_001

Summary

Oracle Data Integrator (ODI) is a data integration platform focused on fast bulk data movement and handling complex data transformations. It provides data movement and transformation among enterprise platforms with its open and integrated E-LT architecture and extended support for Big Data.

Oracle Data Integrator’s E-LT architecture generates native code for different RDBMS or big data engines. The E-LT architecture extracts data from the sources, loads it into a target, and executes transformations using the power of the database or Hadoop.

In ODI 12c, Oracle has introduced a feature that they call Declarative Flow-Based User Interface. What it basically means is that we can now create data flows (Interfaces were re-named to Mappings in new ODI) that combine the two approaches:

  • Visual approach of Mappings and Operators that is well known from Oracle Warehouse Builder
  • Powerful declarative design approach from Oracle Data Integrator

With this new paradigm you essentially get the best of both worlds: ease of visual data flow development and the power of the declarative design approach.

Who is the target audience?

  • Developers and data analysts
  • Private company employees
  • Those who wants to develop themselves in Data Warehouse and Business Intelligence subjects
  • Data Scientists
  • Those who wants to learn ODI product and develop themselves in this subject

 

What Will You Learn?

  • Understand ODI Architecture and philosophy of the tool
  • Develop ODI mappings
  • Develop and design all kind of ODI jobs – Packages, Schedules, etc…
  • Understand Knowledge Module structures
  • Create Topology and understand installation logic
  • Step by Step ODI 12C Components and Structures
  • Load Tables with different Knowledge Modules

 

Required Prerequisites

  • Basic knowledge of ELT/ETL data processing

 

Agenda

Architecture and basics

Overview of ODI Architecture

Overview of ODI Components

About Graphical Modules

Types of ODI Agents

Overview of Oracle Data Integrator Repositories

Overview of ODI Topology with exercises to set up ODI environment

 

Datastores

  • Creating datastores
  • Reverse engineer datastores
  • Business rules on datastores

 

ODI Basic Mapping Concepts

  • What is a Mapping?
  • Business Rules for Mapping
  • Basics – What is a Mapping, a Filter and a Join?
  • Overview of Integration Process
  • What is a Staging Area?
  • Mapping with Knowledge Modules (KM)
  • Simple mappings – Exercises

 

Advanced Usage of ODI Mappings

Designing Mappings

  • Designing a Mapping
  • Multiple Source Data stores
  • Creating Joins
  • Filtering Data
  • Overview of the Flow
  • Using variables in mappings
  • Specifying the Staging Area
  • Selecting Knowledge Modules
  • Text files as sources

 

Mappings, Basics, Monitoring and Debugging

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

 

Mapping – Advanced topics

  • Mapping with Business Rules
  • Overview of Business Rule Elements
  • Creating and Tracking Variables
  • Reusable Mappings
  • Creating Aggregates and facts
  • Using all mapping operators in various exercises

 

Data flow orchestration – Packages, Procedures, Scenarios and Load plans

Packages

  • Introduction and how to use packages
  • Overview of element palette
  • Exercises using different elements in packages

 

Procedures

  • Concept of ODI procedures
  • Source and target execution
  • Exercises involving procedure usage

 

Managing ODI Scenarios and Versions

  • What is a Scenario?
  • Managing Scenarios with Load Plans
  • Scheduling the ODI Scenario
  • Overview of ODI version management

 

Using Load Plans

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

 

Advanced topics

  • Groovy scripting
  • Developing knowledge modules
  • Big data and ODI
  • Introduction to ODI Security