Oracle data integrator Training

Oracle data integrator online training Hyderabad

Oracle data integrator online training offer by vlr training. One of the best Oracle data integrator online training institute in Hyderabad, Oracle Data Integrator (ODI) is an Extract, load and transform (ELT) (in contrast with the ETL common approach) tool produced by Oracle that offers a graphical environment to build, manage and maintain data integration processes in business intelligence systems.

Oracle data integrator online training


Oracle data integrator online training course Details

  • Course Duration:60 Days
  • Mon-Fri 7:30 am (IST)
  • Mode of Training Online only
  • Real-time Trainer
  • After class, we will provide class recording for reference purpose


Please Subscribe To Our You Tube Channel For Free Demo Videos


E-L-T vs. E-T-L

Oracle Data Integrator, or ODI, provides a new declarative design approach to defining data transformation and integration processes based on a unique Extract-Load-Transform (ELT) architecture.  The declarative design approach separates the declarative rules from the implementation details.

ODI architecture eliminates the need for a standalone ETL (Extract-Transform-Load) server and proprietary engine while leveraging the inherent power of RDBMS engines.


Oracle data integrator online training

Why oracle data integrator online training?

Some of the key features that would help in making a decision if Oracle Data Integrator satisfies the data integration needs are:

  • ODI reduces the time spent in learning the product as well and helps in increasing developer productivity
  • ODI Eliminates the need for a standalone ETL server and proprietary engine.  It leverages the power of a relational database like Oracle for processing. Through this, ODI leverages set-based operations and as a result, provides much higher performance.
  • ODI also helps in providing a certain level of data quality without using an external data quality engine. This is achieved by using the data integrity rules and constraints that are defined on the target data warehouse and/or in the ODI tool models.
  • ODI also supports heterogeneous databases other than Oracle such as Teradata, DB2, etc. It also supports other technologies like web services, flat files, XML, etc


Please watch Oracle Data Integrator online training Demo


Register Now to Enroll Oracle Data Integrator Online Training


How does oracle data integrator work and what does it look like?



Oracle data integrator online training.png



Repositories are the central component of Oracle Data Integrator architecture. Objects developed or configured through the user interfaces are stored in the repositories. There are two types of repositories in ODI:  1.) Master Repository and 2.) Work Repository. There can be only one Master Repository and several Work Repositories configured in an ODI platform.

The Master Repository stores the following metadata
  • ODI Platform Security Information – Users, Profiles and Rights.
  • Topology Information – Technologies (Database Platforms), Server Definitions, Contexts, Languages.
  • Version Control Information – Objects are archived and stored with a version number.
The Work Repository stores the following metadata
  • Models (Data Models) – Tables, Data Quality Constraints, Relations, Lineage, etc.
  • Projects – Interfaces (“Mappings” for those familiar with Informatica), Packages, Procedures, Knowledge Modules (Pre-built modules for data integration like CDC, SCD, etc.).
  • Scenario Execution – Load plans, Scenarios, Schedules, Logs, etc.

A work repository containing only the execution information is known as an Execution Repository, usually is used in a production environment.

Graphical User Interfaces

The Graphical User Interface is called as ODI Studio. The ODI Studio is used to access the Master and Work Repositories. The various tools/components (which will be discussed below) within the ODI Studio help in administering the infrastructure, developing projects, scheduling and monitoring executions.

Oracle data integrator online training


ODI provides 4 tools to manage different aspects and steps of an ODI project:
  1. Designer
  2. Operator
  3. Topology Manager
  4. Security Manager 

1. Designer

The Designer Navigator is the component of ODI where the most metadata of a project will be defined. It is used for designing ODI metadata and mapping objects. Some of the metadata components defined in a designer are as follows:

  • Models: Models are basically the source or target definitions in an integration project. ODI supports models on various technologies; some of them are Oracle, DB2, Teradata, XML, Flat Files, Web Services, etc.
  • Projects: Projects are the components that hold all the loading and transformation rules either for a functional module or an entire enterprise data warehouse. Some of the components in the projects are interfaces, procedures, and packages.

2. Operator

In the operator navigator, you can monitor the execution of interfaces, packages, scenarios or load plans. The step by step session monitoring helps in performing debugging as well.

3. Topology Manager

The topology manager is used to describe the logical and physical architecture of the information system. The topology manager reads and writes only to the master repository as it maintains the technologies, data servers, schemas, contexts, and other related information for each of the physical environments. This enables ODI to execute the same integration interfaces across different physical environments.

4. Security Manager

The security manager as called is used for managing security in ODI. Users and Profiles can be created here and privileges can be assigned to these users or profiles. The security manager metadata that is defined will be stored in the master repository.

Run-Time Agents

The run-time agents are responsible for executing the interfaces/packages/scenarios in ODI. The agents retrieve the code from the repository and orchestrate the execution of the code on the data servers. It also retrieves the return codes and messages for the execution.

There are two types of agents in ODI:

1. Standalone Agent

  • Runs in a simple java local node
  • Can be deployed where needed to perform integration flows

2. Java EE Agent

  • Can be deployed as a web application
  • Benefits from the features of an application server

ODI Console

The ODI Console is a web-based user interface (UI) where business users, developers, administrators, and operators can have read access to the repository.  These business users can also perform topology configuration and production operations.

  • Deployed on Oracle Weblogic Server.
  • Plug-in available to integrate with the Oracle Fusion Middleware Control Console

Oracle data integrator online training Course Content:


Introduction to Oracle data integrator

Module 1: Oracle Data Integrator
  • What is Oracle Data Integrator?
    Why Oracle Data Integrator?
    Overview of ODI 11g/12c Architecture
    Overview of ODI 11g/12c Components
    About Graphical Modules
    Types of ODI Agents
    Overview of Oracle Data Integrator Repositories
Module 2: Administration ODI Repositories and Agents              
  • Administrating the ODI Repositories
    Creating Repository Storage Spaces
    Creating & Connecting to the Master Repository
    Creating & Connecting to the Work Repository
    Managing ODI Agents
    Creating a Physical Agent
    Launching a Listener, Scheduler and Web Agent
    Example of Load Balancing


Module 3: ODI Topology Concepts
  • Overview of ODI Topology
    About Data Servers and Physical Schemas
    Defining the Physical Architecture
    Defining the Logical Architecture
    Mapping Logical and Physical Resources
    Defining Agents
    Defining a Topology
    Planning the Topology

Module 4: Setting Up a New ODI Project

  • Overview of ODI Projects
    Creating a New Project
    Using Folders
    Organizing Projects and Folders
    Understanding Knowledge Modules Exchanging ODI Objects
    Exporting and Importing Objects
    Using Markers

Module 5: Describing the Physical and Logical Architecture

  • Overview of 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 & Context Views
    Linking the Logical and Physical Architecture

Module 6: ODI Model Concepts

  • What is a Model?
    Understanding Metadata in ODI
    Understanding Reverse Engineering
    Creating Models
    Organizing Models
    Creating Datastores
    Using Constraints in ODI
    Creating Keys and References

Module 7: ODI Designer Components

  • Business Rules for Mapping
    What is a Mapping, Filter, Join, set operators?
    Overview of Integration Process
    What is Staging Area?
    About Execution Location
    Using Knowledge Modules (KM) with ODI Interface

Module 8: ODI Knowledge Modules & Loading Strategies

    Control Appenednd & Appened
    SCD1 & SCD2

Module 9: Designing Mapping

  • Designing a Mapping
    Multiple Source Data Stores
    Creating Joins
    Filtering Data
    Overview of the Flow
    Specifying the Staging Area
    Selecting Knowledge Modules

Module 10: Using ODI Procedure

  • What is a Procedure?
    Examples of Procedures
    Creating Procedures
    Adding Commands
    Adding Options
    Running a Procedure
    Using Operator to View Results

Module 11: Managing ODI Scenarios and Versions

  • What is a Scenario?
    Managing Scenarios
    Preparing Scenarios for Deployment
    Automating Scenario Management
    Scheduling the ODI Scenario

Module 12: Monitoring and Debugging Using Operator Debugger

  • Monitoring Mapping
    Using Operator
    Viewing Sessions and Tasks How to Monitor Execution of an Interface
    How to Troubleshoot a Session
    Working with Break Points
    Keys to Reviewing the Generated Code
    Working with Errors
    Tips for Preventing Errors

Module 13: Using ODI Packages

  • What is a package?
    Creating a package
    Executing a package
    Creating Advanced Packages
    Error handling
    Controlling an Execution Path

Module 14: Using ODI Packages Tools

  • What is a package tool?
    Creating a package tool?
    Executing a package tool?

Module 15: ODI Administration

  • Working with Security Navigator
    Creating Users
    Creating profiles
    Assigning profiles to users
    Object level access

Module 16: ODI Integration with other Oracle applications

  • ODI integration with SOA
    ODI integration with OGG
    ODI Integration with Oracle ERP applications (BIAPPS)
    ODI integration with Big Data
    OWB migration to ODI
    ODI integration with web logic
Module 17: CDC Loading Strategies
  • Timestamp-based CDC load
    Log-based CDC Load
    Trigger-based CDC Load

VLR Training Address:
Plot No 126/b,2nd floor, Street Number 4,
Addagutta Society, Near Jntuh,Pragarthi Nagar Road,
Kukatpally, Hyderabad, Telangana 500072
Name: Oracle data integrator online training Hyderabad
Opening hours:7 Am to 9 Pm (IST)

1 thought on “Oracle data integrator online training Hyderabad”

Leave a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.