Oracle 12c Data Integrator (ODI)
Course
Online
Description
-
Type
Course
-
Methodology
Online
Oracle 12c ODI Data Integrator course; hands on training exploring ODI architecture, administration and key functionality and integration. Learning Objectives Oracle 12c Data Integrator, built on high performance ELT, platform flexibility and intuitive user experience is a key component and latest version of Oracle's complete OBI offering and enterprise data integration platform. Designed around continuous hands on labs iTrain's course provides attendees with essential skills and hands on experience to fully harness it's enterprise potential. The course will explore the product from architectural, implementation and best use perspectives, provding attendees with understanding how ODI maximises next generation Extract-Load-Transformation technology to provde crucial analytics and true business intelligence - converting data into a business asset; information. Attendees will start with basic blocking and interfaces creation through to more complex, advanced aspects of ODI including data workflows, management and monitoring, scheduling and impact analysis learning how to implement, administer and manage high volume movement and transformation of data between disparate platforms
About this course
BI Knowledge
Data Warehouse Design
Knowledge of ETL
Reviews
Subjects
- Monitoring
Course programme
Oracle Data Integrator Information, not data ODI Architecture ODI Components Graphical Modules ODI Agents Oracle Data Integrator Repositories overview Administering ODI Repositories and Agents Administrating the ODI Repositories Creating Repository Storage Spaces Creating and Connecting to the Master Repository Creating and Connecting to the Work Repository Creating a Wallet to Securely Store Credentials Managing ODI Agents Creating a Physical Agent
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
Setting Up a New ODI Project Creating a New Project Creating and Maintaining Folders Organizing Projects and Folders Exchanging ODI Objects and Sharing Global Objects Object export and import Creating and Labeling with Markers Oracle Data Integrator Model Concepts Model overview Understanding Metadata in ODI Understanding Reverse Engineering Creating Models Organizing Models Creating Data stores Configuring Constraints in ODI Creating Keys and References Organizing ODI Models and Creating Data Stores What is a Mapping? Business Rules for Mappings Creating a Basic Mapping What is a Join? What is a Filter? What is a Constraint? What is a Staging Area? ODI Mapping Concepts What is a Mapping? Business Rules for Mapping What is a Mapping, a Filter, a Join? Overview of Integration Process What is a Staging Area? Execution Location Creating an Intermediate Mapping Designing Mappings Designing a Mapping Multiple Source Data stores Creating Joins Filtering Data Disabling Transformations Overview of the Flow Specifying the Staging Area
Mapping: Monitoring and Debugging Monitoring Mappings Objects with Operator Sessions and Tasks Monitoring Execution of a Mapping Troubleshooting Keys to Reviewing the Generated Code Errors Creating and Running ODI Procedures Creating Procedures Adding Commands Adding Options Running a Procedure Viewing Results with Operator Using ODI Packages Creating a Package Executing a Package Creating Advanced Packages Error Handling Controlling an Execution Path Creating a Loop Using the Advanced tab ODI Scenarios and Versions Managing Scenarios with Load Plans Preparing Scenarios for Deployment Automating Scenario Management Scheduling the ODI Scenario Overview of ODI version management Handling concurrent changes
Oracle 12c Data Integrator (ODI)