Oracle Data Integrator 12c training program covers all data integration needs from high-performance, high-volume batch loads, to event-driven integration processes and SOA Allowed 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 enhance performance, lowers overall solution costs as well as scalability.

Radiant Teachlearning offers Oracle Data Integrator 12c: Integration and Administration Training Program in Classroom and Virtual instructor Led/Online mode.


Duration: 5 days


Learning Objectives

  • Use Oracle Data Integrator to perform transformation of data among various platforms.
  • Design ODI mappings, procedures, and packages to perform ELT data transformations.
  • Administer ODI resources and set up security with ODI.
  • Perform data integration and transformation among various platforms.
  • Use the ODI graphical interface to define procedures, packages, and ELT jobs.
  • Set up and maintain a secure, multi-user ODI environment.
  • Implement changed data capture with ODI.
  • Use ODI Web services and perform integration of ODI with SOA.
  • Administer ODI resources and setup security with ODI
  • Apply ODI Topology concepts for data integration
  • Describe ODI Model concepts
  • Describe 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


Benefits to You

Taking this training program will teach professionals way to optimize performance and minimize integration costs across your organization’s heterogeneous systems. Professionals will be able to centralize data across databases using your new skills to perform design ODI Mappings, data integration, 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 minimize 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.


Implement High-Performance Movement and Transformation

Expert instructors will teach professionals way to use Oracle Data Integrator (ODI) 12c to execute high performance movement and transformation of data among different platforms. This training program covers using ODI graphical user interfaces that allow users to access varies ODI resources as well as components that form ODI infrastructure.


ODI Repositories

Using the graphical interfaces, professionals will develop the understanding to create manage and maintain ODI repositories, which store configuration information about the metadata for all applications, the IT infrastructure, projects, models as well as other ODI artifacts.


ODI Topology, Models, Mappings, and Other Objects

Furthermore, professionals will develop the ability to create the ODI Topology, organize ODI models and design ODI Mappings, procedures, packages and other objects. This training program is based on Oracle Data Integrator 12c (12.2.1).


Please Note

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


Audience Profile

  • Administrator
  • Analyst
  • Architect
  • Data Scientist
  • Database Administrator
  • Implementer

Course Content


  • Administering ODI Repositories and Agents
  • ODI Topology Concepts

Describing the Physical and Logical Architecture

  • Setting Up a New ODI Project
  • Oracle Data Integrator Model Concepts

Organizing ODI Models and Creating Data stores

  • ODI Mapping Concepts
  • Designing Mappings

Mapping: Monitoring and Debugging

  • Designing Mappings: Advanced Topics 1
  • Designing Mappings: Advanced Topics 2

Creating and Running ODI procedures

  • Using ODI Packages
  • Step-by-Step Debugger

Managing ODI Scenarios and Versions

  • Using Load Plans
  • Enforcing Data Quality and Auditing Data with ODI

Working with Changed Data Capture

  • Advanced ODI Administration
  • Integrating ODI with Subversion

Integrating Big Data with ODI


Q: What audience is expected for this training?


A: This course is  beneficial for following type of professionals :-

  • Administrator
  • Analyst
  • Database Administrator
  • Architect
  • Implementer
  • Data Scientist


Q: What is the role of ODI?


A: ODI offers graphical atmosphere to build data integration systems with maintaining and management for business integrated platforms.


Q: What is meant by ELT data transformation?


A: Extract, Load and transform is the data integration process which transfers the raw data received from the source server and then transfer the data to a targeted server for downstream uses.


Q: What is the role of ODI topology?


A: Topology is the representation of the information system in Oracle Data Integrator which uses topology to connect information in the integration processes.


Q: What are the benefits of CDC?


A: It provides faster and accurate decision for more current data. It reduces the probability of disruptions in production workloads.


Q: What are the benefits of hadoop ecosystem in ODI?


A: Hadoop ecosystem is resilient to failure plus it provides fast, secure and flexible storage platform. That’s why it is preferred.


Q: Why one should prefer Radiant Techlearning ?


A: Radiant believes in practical and creative approach to training and development which distinguishes it from the other training and developmental platforms. Moreover training courses are undertaken by some of the experts who are having vast range of experience in their domain.


Q: What if I/we have doubts after attending your training program?


A: Radiant team of experts would be available on the e-mail to answer your technical queries even after the training program.


Q: Does this training program include any project?


A: Yes, Radiant will provide you most updated high value and relevant real time projects and case studies in each training program.


Q: If I face technical difficulty during the session then is there any remedy for that?


A: Technical issues are unpredictable and might occur with us as well.   Participants have to ensure that they have access to the required configuration with good internet speed.


Q: What is schedule of training program?


A: Radiant Techlearning offers training programs on weekday, weekend and combination of weekday and weekend.  We provide you complete liberty to choose the schedule that suits to your need.

Categories: ,

Unble To Find a Batch..?

Request a Batch