Skip to Scheduled Dates
Course Overview
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.
Learn How To:
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.
Who Should Attend
Administrator
Analyst
Architect
Data Scientist
Database Administrator
Implementer
Course Objectives
- 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
Course Outline
1 - Outline
- Introduction
- 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