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.
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
Who Should Attend?
Administrator
Analyst
Architect
Data Scientist
Database Administrator
Implementer
- Top-rated instructors: Our crew of subject matter experts have an average instructor rating of 4.8 out of 5 across thousands of reviews.
- Authorized content: We maintain more than 35 Authorized Training Partnerships with the top players in tech, ensuring your course materials contain the most relevant and up-to date information.
- Interactive classroom participation: Our virtual training includes live lectures, demonstrations and virtual labs that allow you to participate in discussions with your instructor and fellow classmates to get real-time feedback.
- Post Class Resources: Review your class content, catch up on any material you may have missed or perfect your new skills with access to resources after your course is complete.
- Private Group Training: Let our world-class instructors deliver exclusive training courses just for your employees. Our private group training is designed to promote your team’s shared growth and skill development.
- Tailored Training Solutions: Our subject matter experts can customize the class to specifically address the unique goals of your team.
Agenda
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