• India Flag
    Call Us:

    +91 769-409-5404

  • USA Flag
    Call Us:

    +1 786-629-6893

About Course:

This training program is designed to prepare the students for Oracle Data Integration Developer track. This training program teaches student 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.


Duration : 30 hours

Fee: 319


Job Trends


Who Should Learn?

DBA, 

Students who want to make their career in database 

Prerequisite

basic knowledge of SQL and relational database

Delivery Methodology

We are using an experiential delivering methodology that blends theoretical concepts with hands-on practical learning to ensure a holistic understanding of the subject or course.

Class Delivery

Live Interactive classes with expert

Training Calender

Date Time Type Attend
10th August 2019 7:30 AM   IST Demo
13th August 2019 7:30 AM   IST Regular
Contact Us

+91 769-409-5404

Includes
  • 24 hours on-demand video
  • Articles
  • Coding Exercises
  • Full lifetime access
  • Certificate of Completion

Curriculum

Oracle Data Integration 12C

Oracle Data Integration 12c Training

Course Overview:

Class: 1 Introduction to ODI

Identifying the Course Units

Why Oracle Data Integrator?

Overview of ODI Architecture

Overview of ODI Components

About Graphical Modules

Types of ODI Agents

Overview of Oracle Data Integrator Repositories

Class: 2 Installation of ODI 12c

Identifying the required software's.

Prerequisites

System Requirements

Installation of ODI

Repository Configuration using RCU

Setting the sample database for hands-on

Class: 3 Introduction to ODI Repository and Agents

Administrating the ODI Repositories

Connecting to the Master Repository

Connecting to the Work Repository

Managing ODI Agents

Creating a Physical Agent

Class: 4 ODI 12c Features

The Benefits of Using ODI 12c

Overview of ODI 12g Architecture and Components

The features of New ODI 12c User Interface and its Components

Overview of ODI 12g New Features

Class: 5 ODI Topology Navigator

Creating Physical Architecture

Creating a Data Server

Testing a Data Server Connection

Creating a Physical Schema

Creating Logical Architecture

Overview of Logical Architecture and Context Views

Linking the Logical and Physical Architecture

Class: 6 ODI Models and datastores

What is a Model?

Understanding Metadata in ODI

Understanding Reverse Engineering

Creating Models

Organizing Models

Creating Data stores

Configuring Constraints in ODI

Creating Keys and References

Class: 7 ODI 12c Mapping

What is a Mapping?

Designing a Mapping

Business Rules for Mapping

What is a Mapping, a Filter, a Join?

Overview of Integration Process

What is a Staging Area?

Execution Location

Mapping with Knowledge Modules (KM)

Creating an Intermediate Mapping

Class: 8 ODI 12c MappingMonitoring and Debugging

Monitoring Mappings

Creating Objects with Operator

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

Class: 9 Designing Mappings: 1

Mapping with Business Rules

Overview of Business Rule Elements

Creating and Tracking Variables

Creating User Functions

Mapping Substitution Methods

Showing Variable Values in Log

Customizing Reverse Engineering Using RKM

Class: 10 Designing Mappings: 2

Using Partitioning in a Mapping

Reusable Mappings

Derived Select (Subselect) for Reusable Mappings

Using User Functions

Creating a User Function

Using Substitution Methods

Class: 11 ODI Procedures

What is a Procedure?

Examples of Procedures

Creating Procedures

Adding Commands

Adding Options

Running a Procedure

Viewing Results with Operator

Class: 12 ODI Packages

What is a Package?

Creating a Package

Executing a Package

Creating Advanced Packages

Error Handling

Controlling an Execution Path

Creating a Loop

Class: 13 ODI Scenarios and versions

What is a Scenario?

Managing Scenarios with Load Plans

Preparing Scenarios for Deployment

Automating Scenario Management

Scheduling the ODI Scenario

Overview of ODI version management

Handling concurrent changes

Class: 14 Enforcing Data Quality

Why Data Quality?

When to Enforce Data Quality?

Data Quality in Source Applications

Data Quality Control in the Integration Process

Data Quality in the Target Applications

Enforcing Data Quality

Exploring Your Data

Auditing Data Quality

Class: 15 ODI Changed Data Capture

Techniques of Changed Data Capture

Changed Data Capture in ODI

CDC Strategies and Infrastructure

CDC Consistency

Creating Change Data Capture (CDC)

Viewing Data/Changed data

Journalizing

Class: 16 Load Plans

What Are Load Plans?

Load Plan Editor

Load Plan Steps

Defining the Restart Behavior

Benefits of Using Load Plans

Handling Failed Load Plans

Class: 17 ODI Security Navigator

Security Concepts: Overview,

Defining Security Policies

Creating Profiles, Creating Users,

Assigning a Profile to a User,

Assigning an Authorization by Profile or User

Defining Password Policies,

Generating Topology Reports

Class: 18 Step-by-Step Debugger

Benefits of Using Step-by Step Debugger

Overview of the Features of Step-by-Step Debugger

Debugging Mappings using the Debugger

Debugging Packages using the Debugger

Class: 19 Developing ODI Knowledge Modules

Overview of Different Types of KMs

Guidelines for KM Developers

Working with Substitution Methods

Applying Various ODI Tags

Implementing Java in KMs

Troubleshooting and Debugging KMs

Class: 20 Using Groovy in ODI

Interacting Programmatically with ODI

Overview of ODI SDK

Introduction to Groovy

Using Groovy Editor

Automating Development Tasks with Groovy

Watch demo videos:
 

Use Case

Use Case 1

Certificate

Certificate
Benefits of Certificate

Certification demonstrates your dedication, motivation and technical knowledge on a specific platform. Having a certification shows that you not only possess comprehensive knowledge of that technology but you also care enough about your own career to spend the time and money to get the certification.

We are welcoming our Students or professionals to participate in our professional online courses. We are offering great variety of online training programs and professional courses that you can always find as desired. After the completion of training program they will receive a certificate from BISP. As a Certified professional you can apply that knowledge in your future profession and enjoy with better salaries & career prospects.

Signup for free newsletter and
business tips

Any Questions?
Talk to our Course Co-ordinator

+91 769-409-5404
Want to see a live demo? We'll be in touch within 24 hours?