Oracle Data Integrator 12c: Integration and Administration Ed 3 Training

Live Online & Classroom Enterprise Certification Training

This Oracle Data Integrator (ODI) training provides experience in configuring and administering the ODI 12c environment. Learn methods and techniques of data integration among various platforms based on the architecture of Extract Load Transform (EL-T).

Looking for a private batch ?

REQUEST A CALLBACK

Certified Trainer
Authorized Courseware
Completion Certificate from ATP

Enterprise Reporting
Lifetime Access
CloudLabs
24x7 Support
Real-time code analysis and feedback

What is Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training about?

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.

Taking this course will teach you how to improve performance and reduce integration costs across your organization's heterogeneous systems. You'll be able to centralize data across databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security. In addition, Oracle Data Integrator can interact with the various tools of the Hadoop ecosystem (such as Hive, Hbase, HDFS, Oozie, etc), 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.

Please Note: The latest release of Oracle Data Integrator supports storing ODI artifacts into source code management systems (such as Subversion.) This course teaches you how to integrate ODI with Subversion.

What are the objectives of Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training ?

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

Who is Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training for?

Database Administrators
Database Administrators
Business Analysts
SOA Architect
Data Scientist
Data Warehouse Administrator

What are the prerequisites for Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training?

Suggested Prerequisite

Basic knowledge of ELT data processing

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

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?

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

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

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

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

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

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?

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

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

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

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

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

Using ODI Procedures

What is a Procedure?

Adding Commands

Examples of Procedures

Viewing Results with Operator Navigator

Running a Procedure

Adding Options

Creating Procedures

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

Step-by-Step Debugger

Menu Bar Icons

Screen Step Numbering

Control Execution Flow

Specifying Debug Properties

New Functionality

Starting a Session in Debug mode

Managing ODI Scenarios

Generating a Scenario

What is a Scenario?

Scheduling the ODI Scenario

Managing Schedules

Executing a Scenario

Automating Scenario Management

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

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

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)

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

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

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

Who is the instructor for this training?

The Trainer is Oracle certified Instructor with extensive domain experience, including years of experience training & mentoring professionals in the industry.

Oracle Data Integrator 12c: Integration and Administration Ed 3 Certification Training - Certification & Exam

SpringPeople is the Authorized Training Partner of Oracle.
The training fees is exclusive of exam cost.
For any queries; feel free to reach us at oracle@springpeople.com

Reviews

My outlook on training changed completely after attending SpringPeople BPC training. The content, the trainer and infrastructure at SpringPeople were top notch and perfectly in tune with the industry requirements. Regardless to say, training is now something that I look forward to to. Kudos to everyone at SpringPeople!

Shweta Priya

Sony

I attended the 3-day AngularJs training at SpringPeople. The trainer was an industry veteran with vast experience in the subject. Notably, the hands-on training, and the Q&A session stood out. Overall, I found SpringPeople a great place to learn with excellent facilities and great trainers. Would recommend SpringPeople to my colleagues and friends.

Swati Singh

I attended the training on API Design for Mulesoft. The sessions were well planned and value-laden. I benefited immensely from the hands-on experience enabled through virtual labs. I would like to specifically commend the efficiency of the support team who were always available to resolve my concerns.

Nikhil Kohli

Stryker

I attended the jQuery training batch, conducted by Mr. Vijay, an SME who did a thorough coverage of all the essentials. He took us through concepts such as jQuery animations, event handlers, plugins, and jQuery-UI by small programs, very easily. The sessions were useful and well structured. By the end of the training, I was well equipped to develop a SPA on Product Management System. Overall, the learning experience at SpringPeople was great!

Heena Rajan

Mindtree