Oracle Data Integrator 11g: Integration and Administration Training

Live Online & Classroom Enterprise Certification Training

Gain experience in configuring and administering the Oracle Data Integrator 11g (11.1.1.6) environment. Learn methods and techniques of data integration among various platforms based on the next-generation architecture of Extract Load Transform (EL-T).This offering details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms.

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 11g: Integration and Administration 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.

This offering details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which store configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

What are the objectives of Oracle Data Integrator 11g: Integration and Administration Certification Training ?

Describe ODI Model concepts
Describe architecture of Oracle Data Integrator 11g
Apply ODI Topology concepts for data integration
Design ODI Interfaces, Procedures, Packages, and Load Plans to perform ELT data transformations
Explore, audit data, and enforce data quality with ODI
Administer ODI resources and setup security with ODI
Implement Changed Data Capture with ODI
Use ODI Web services and perform integration of ODI with SOA

Who is Oracle Data Integrator 11g: Integration and Administration Certification Training for?

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

What are the prerequisites for Oracle Data Integrator 11g: Integration and Administration Certification Training?

Basic knowledge of ELT data processing
Working knowledge of SQL

Available Training Modes

Live Online Training

40 Hours

Classroom Training

5 Days

Course Outline Expand All

Expand All

Introduction

What is Oracle Data Integrator?

Overview of Oracle Data Integrator Repositories

Overview of ODI 11g Architecture

Types of ODI Agents

Why Oracle Data Integrator?

Overview of ODI 11g Components

About Graphical Modules

Identifying the Course Units

Administering ODI Repositories and Agents

Administrating the ODI Repositories

Creating and Connecting to the Master Repository

Creating and Connecting to the Work Repository

Example of Load Balancing

Creating Repository Storage Spaces

Creating a Physical Agent

Launching a Listener, Scheduler and Web Agent

Managing ODI Agents

ODI Topology Concepts

Overview of ODI Topology

Defining a Topology

Defining the Physical Architecture

About Data Servers and Physical Schemas

Defining the Logical Architecture

Defining Agents

Planning the Topology

Mapping Logical and Physical Resources

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

Using Markers

Organizing Projects and Folders

Exporting and Importing Objects

Understanding Knowledge Modules

Exchanging ODI Objects and Sharing Global Objects

Using Folders

Creating a New Project

Oracle Data Integrator Model Concepts

Creating Data stores

Organizing Models

Using Constraints in ODI

What is a Model?

Creating Models

Creating Keys and References

Understanding Reverse Engineering

Understanding Metadata in ODI

Organizing ODI Models and Creating Data stores

What is a Filter?

What is a Constraint?

What is a Staging Area?

Business Rules for Interfaces

What is a Mapping?

What is a Join?

What is an Interface?

Creating a Basic Interface

ODI Interface Concepts

Business Rules for Interfaces

Creating a Basic Interface

What is an Interface?

What is a Staging Area?

What is a Mapping, Filter, Join?

Overview of Integration Process

About Execution Location

Using Knowledge Modules (KM) with ODI Interface

Designing Interfaces

Creating Joins

Filtering data

Multiple Source Data stores

Disabling Transformations

Overview of the Flow

Selecting Knowledge Modules

Designing an Interface

Specifying the Staging Area

Interfaces: Monitoring and Debugging

How to Troubleshoot a Session

Tips for Preventing Errors

Monitoring Interfaces

How to Monitor Execution of an Interface

Viewing Sessions and Tasks

Using Operator

Keys to Reviewing the Generated Code

Working with Errors

Designing Interfaces: Advanced Topics

Using Substitution Methods

Using Business Rules in Interfaces

Modifying a KM

Overview of Business Rule Elements

Using User Functions

Showing Variable Values in Log

Using and Tracking Variables

Using RKM for Customized Reverse Engineering

Using ODI procedures

Adding Commands

Running a Procedure

Using Operator to View Results

Examples of Procedures

Adding Options

What is a Procedure?

Creating Procedures

Using ODI Packages

Controlling an Execution Path

What is a package?

Using the Advanced tab

Creating a Loop

Creating a package

Error handling

Executing a package

Creating Advanced Packages

Managing ODI Scenarios and Versions

Using Version Browser and Version Comparison Tool

Overview of ODI version management

Scheduling the ODI Scenario

Handling concurrent changes

What is a Scenario?

Preparing Scenarios for Deployment

Automating Scenario Management

Managing Scenarios with Load Plans

Enforcing Data Quality and Auditing Data with ODI

Data Quality in Source Applications

Data Quality in the Target Applications

Exploring Your Data

Why Data Quality?

Auditing Data Quality

When to Enforce Data Quality?

Enforcing Data Quality

Data Quality Control in the Integration Process

Working with Changed Data Capture

Changed Data Capture in ODI

Overview of ODI version management

Using CDC

CDC Strategies and Infrastructure

Techniques of Changed Data Capture

CDC Consistency

Viewing Data/Changed data

Using Journalizing

Administering ODI Resources: Advanced Topics

Setting Up ODI Security

Installing Open Tools

Defining Password Policies

Defining Security Policies

Using Open Tools in a Package

Using Open Tools in a Procedure or in a KM

Using Open Tools

Developing Your Own Open Tools

Using Web Services and Integration of Oracle Data Integrator with SOA

Installing Public Web Services

Using Data Services

Integrating ODI with SOA

Testing Data Services

Web Services in Action

Invoking Web Services

Setting Up Data Services

Using Public Web Services

Extending ODI with the SDK

Using SDK Public Interfaces

Integrating through ODI SDK

Examining SDK examples

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 11g: Integration and Administration 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