Oracle ODI Training | Online Certification Course

Key Highlights

+1 930 200 4823

( Toll Free )

25 Hrs Instructor Led Training

Self-paced Videos

20 Hrs Project & Exercises

Certification

Job Assistance

Flexible Schedule

Lifetime Free Upgrade

Mentor Support

Curriculum

A complete index of
job-ready skills curated
to meet the industrial need.
Explore.

Getting Started with Oracle Data Integrator

Define Oracle Data Integrator
Importance of Oracle Data Integrator
Introduction to Oracle 11g Components
Introduction to Oracle 11g Architecture
Graphical Modules
Kinds of ODI Agents
Oracle Data Integrator Repositories

Administering ODI Agents and Repositories

Handling ODI Agents
Creating the Physical Agent
Starting a Scheduler, Listener, and Web Agent
Administrating the ODI Repositories
Creating and Connecting to the Work Repository
Creating and Connecting to the Master Repository
Creating Repository Storage Spaces

ODI Topology

Introduction to ODI Topology
Physical Schemas and Data Servers
Physical Architecture and Login Architecture
Mapping Physical and Logical Resources
Defining the Topology and Agents
Planning the Topology

Physical and Logical Architecture

Topology Navigator
Creating a Data Server and Physical Architecture
Testing the Data Server Architecture
Creating a Physical Schema and Logical Architecture
Introduction to Context Views and Logical Architecture
Connecting the Physical and Logical Architecture

Configuring the ODI Project

Introduction to ODI Projects
Creating the new project
Utilizing the Folders
Organizing the Folders and Projects
Understanding the knowledge Modules
Sharing Global Objects and Exchanging the ODI Objects
Importing and Exporting the Objects
Utilizing the Markers

Oracle Data Integrator Model Concepts

Define Model
Reverse Engineering
Metadata in ODI
Creating and Organizing Models
Creating Data Stores, References, and Keys
Using the Constraints in ODI

Creating Data Stores and Organizing the ODI Models

Interface
Business Rules for Interface
Mapping and Join
Filters and Constraints
Staging Areas
Creating the Basic Interfaces

Designing Interfaces

Designing the Interface
Creating the Joins
Multiple Source Data Stores
Filtering the data
Disabling the Transformations
Introduction to Flow
Defining the Staging Area
Choosing the Knowledge Modules

Interfaces: Debugging and Monitoring

Utilizing Operators
Monitoring the Interfaces
Viewing Tasks and Sessions
Monitoring the Interface Execution
Troubleshooting the Session
Working with the errors
Factors for reviewing the created code
Tricks to prevent the errors

Designing the Interfaces

Utilizing the business rules in the interface
Introduction to business rule elements
Tracking and Using the Variables
Utilizing the User functions
Utilizing the Substitution methods
Changing a KM
Displaying the Variable Values in Log
Utilizing the RKM for Customised Reverse Engineering

ODI Procedures

Define Procedure and Examples for Procedures
Creating Procedures
Inserting the Commands
Inserting the Options
Executing the Procedure
Utilizing the Operator for seeing the results

ODI Packages

Define a Package
Creating and Executing a Package
Error Handling
Creating Advanced Packages
Controlling the execution path
Creating the Loop
Utilizing the Advanced Tab

ODI Scenarios and Versions

Scenario
Handling Scenarios with Load Plans
Developing Scenarios for the Deployment
Automating the Scenario Management
Planning the ODI Scenarios
ODI Version Management
Version Comparison and Version Browser Tool
Managing Concurrent Changes

Defining Simple Procedures

What Is a Procedure? & Procedure Examples
Using Procedures: Overview
How to Create a New Procedure
Creating a New Command
Arranging Steps in Order
Which Parameters Should be Set?
Valid Types of Commands
Types of Options
Variables and Sequences

Applying Auditing Data and Data Quality with ODI

Need of Data Quality
When to Apply Data Quality
Data Quality in the Source Applications
Data Quality Control in the integration process
Data Quality in the target application
Applying Data Quality
Exploring our Data
Auditing the data quality

Working with the Changed Data Capture

ODI version management
Techniques of Modified Data Capture
Modified Data Capture in ODI
CDC Infrastructure and Strategies
Utilizing the CDC
CDC Consistency
Changed Data/Viewing Data
Utilizing Journalizing

Administrating the ODI Resources

Installing and Utilizing Open Tools
Utilizing the Open tools in the Package
Utilizing the Open tools in the KM or the Procedure
Building our open tools
Configuring the ODI Security
Specifying Password Policies and Security Policies

Utilizing Web Services and Integration of ODI with SOA

Web Services in Action
Utilizing and Configuring Data Services
Testing the Data Services
Using and Installing Public Web Services
Calling the Web Services
Integrating the ODI with SOA

Expanding the ODI with SDK

Utilizing the SDK Public Interfaces
Integrating the ODI SDK
Reviewing the SDK examples

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

Project Details

We bring you the best learning experience by delivering all our training sessions practical. Following are the few use cases we shall discuss during the training.

Oracle ODI Training Objectives

1. What are the Main Objectives of this Oracle ODI Training?

The main objective of this Oracle ODI training is to teach you how to configure and handle the ODI 12c environment. It makes you an expert in creating bulk data integrations in the Oracle Fusion Middleware stack. Through our well-structured course content, certified trainers, 30hrs of interactive training sessions, LMS, and Simulation learning, you can enhance your data integration skills and accelerate your career.

2. What are the Prerequisites to take this ODI Training?

Having prior knowledge of database concepts and data sources is helpful but not mandatory to join this ODI Training.

3. Who Should Take this ODI Training?

This ODI Training is helpful for aspirants who want to start a career in the data integration domain can take this ODI Training.

4. Why Should You Join this ODI Training?

ODI is the leading ETL tool in the Data Integration industry. The primary benefit of ODI is it utilizes the inherent capability of the target and source systems which doesn’t need a separate server for installing the ODI. It does not need a high-performance server nor even a standalone server. The integration of PaaS is expected to reach $22billion by 2025. According to ziprecruiter.com, the average salary of an ODI Developer in the US is around $161K per annum.

5. What are the essential skills covered in this ODI Training?

During this ODI Training, you will master the following skills:

Oracle 11g Architecture
Oracle Data Integrator Repositories
Topology Navigator
Data Server Architecture
Metadata in ODI
Staging Areas
Creating Procedures
Substitution Methods
Filters
ODI Packages
Creating the Loop
Web Services in Action

6. What Job roles are offered to ODI Professionals?

By the end of this ODI training, you will acquire the proficiency to get your dream job. Following Job roles are offered to ODI professionals:

ODI Developer
ODI Application Technical Consultant
Oracle Data Integrator
Oracle ODI Consultant

+1 930 200 4823

( Toll Free )

Training Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

Duration

One-on-one Session

Support

Resources

Time

Fee

Live Online.

25 Hours

Yes

24x7

Additional tips from the trainer

30 July 2024, 07:00 AM

03 August 2024, 08:00 AM

Self-Paced

25 Hours

Weekdays & Working Hours

Accessible through LMS

At your convenience

Oracle ODI Training Upcoming Batches

Weekday

30 July 2024 to 30 August 2024

07:00 AM

Weekend

03 August 2024 to 03 September 2024

08:00 AM

Weekday

06 August 2024 to 06 September 2024

07:00 AM

Weekend

10 August 2024 to 10 September 2024

07:30 AM

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

The Oracle ODI trainer was very concise and to the point. The hands-on exercises were beneficial in achieving a job. Thank you Tekslate.

Pratyusha

Recently I’ve taken Oracle ODI training from Tekslate.com. The trainer is very knowledgeable about the subject. After the course, I’ve attempted the Oracle ODI certification and got qualified.

Niharika

The training was provided using real-time examples taken on the field. The case studies are beneficial in the matter at hand. The trainer was very careful with our requirements and gave us exactly what we asked for, something that is seldom done.

Prince

Oracle ODI Training FAQ'S

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

1. What is ODI(Oracle Data Integrator)?

Oracle Data Integrator(ODI) is an ELT(Elastic, Load, and Transform) tool developed by Oracle that provides a graphical environment for developing, handling, and maintaining the data integration processes in the business intelligence systems.

2. Is ODI a Middleware?

The Oracle Data Integrator(ODI) platform incorporates Using a more comprehensive fusion middleware platform and turns as an essential element of the stack.

3. What are ODI Packages?

The ODI package is a workflow that we use for sequencing the execution steps of a data integration process.