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.
Benefits to You
Improve performance and reduce integration costs across your organization's heterogeneous systems. Centralize data across databases using your new skills to perform data integration, design ODI Mappings, and set up ODI security.
Implement High-Performance Movement and Transformation
This offering details on how to use Oracle Data Integrator (ODI) 12c to implement high-performance movement and transformation of data among various platforms.
ODI Graphical User Interface
The training covers usage of ODI graphical user interfaces that enable users 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.
ODI Topology, Models, Mappings, and other
You also learn how to create the ODI Topology, organize ODI models and design ODI Mappings, procedures, packages and other objects.
This course is based on Oracle Data Integrator 12c (12.1.2)
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
Mapping: Monitoring and Debugging
Designing Mappings: Advanced Topics
Creating and Running ODI procedures
Creating and Running ODI Packages
Managing ODI Scenarios and Versions
Enforcing Data Quality and Auditing Data with ODI
Working with Changed Data Capture
Administering ODI Resources: Advanced Topics
Creating Web Services and Integration of ODI with SOA
Extending ODI with the SDK
Recommended Related Training Courses:
Oracle Enterprise Data Quality: Match and Parse
Learn how to match, merge, parse and standardize data and verify addresses with version 9.0.2 of Oracle Enterprise Data Quality.This course teaches you how to use Oracle Enterprise Data Quality's sophistictaed match functionality to find records that are the same or similar and how to extract key data from free text fields via parsing.
Oracle Data Integrator 11g: Advanced Integration and Development
This Oracle Data Integrator training teaches advanced topics for developing data integration applications. Learn to create an integration environment based on the architecture of Extract Load Transform (EL-T), along with advanced methods & techniques.
Oracle Enterprise Data Quality: Profile, Audit and Operate
Learn how to create, automate and reuse processes to troubleshoot and analyze data with Oracle Enterprise Data Quality. This course teaches the participants to import profile, audit, export data and to create Oracle Enterprise Data Quality processes and jobs.This course is based on Oracle Enterprise Data Quality version 9.0.2 .
Oracle Database: Introduction to SQL
This Database Intro to SQL training teaches essential SQL skills to write queries against single and multiple tables, manipulate data in tables and create database objects. This course is ideal for 10g and 11g audience.