Oracle Data Integrator 12c: Integration and Administration

• Business Analysts
• Data Modelers
• Data Warehouse Administrator
• Database Administrators
• SOA Architect
• Technical Consultant

• 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.

• Describe ODI Model concepts
• Describe architecture of Oracle Data Integrator 12c
• Apply ODI Topology concepts for data integration
• Design ODI Mappings, Procedures, Packages, and Load Plans to perform ELT data transformations
• Explore, audit data, and enforce data quality with ODI
• Administer ODI resources and setup security with ODI
• Implement Changed Data Capture with ODI
• Use ODI Web services and perform integration of ODI with SOA

Basic knowledge of ELT data processing
Working knowledge of SQL

Metody výuky

Odborný výklad s praktickými ukázkami, cvičení na počítačích.

Formáty školení Oracle

Velmi oblíbenou formou školení jsou nahrávané kurzy On Demand zahrnující 90 dnů samostudia kdykoliv a kdekoliv s TOP lektorem. Dalšími možnými formáty studia jsou kurzy probíhající přímo v učebně v Počítačové škole Gopas nebo ve společnosti Oracle, dále formát Live Virtual Class (školení on-line) či Selft-Study (samostudium ve formě CD, nebo download). Podrobnější informace k těmto možnostem studia najdete zde.

Studijní materiály

Elektronické autorizované materiály Oracle v anglickém jazyce.

Introduction

• Identifying the Course Units
• What is Oracle Data Integrator?
• Why Oracle Data Integrator?
• Overview of ODI Architecture
• Overview of ODI Components
• About Graphical Modules
• Types of ODI Agents
• Overview of Oracle Data Integrator Repositories

Administering ODI Repositories and Agents

• Administrating the ODI Repositories
• Copyright © 2013, Oracle. All rights reserved. Page 2
• Creating Repository Storage Spaces
• Creating and Connecting to the Master Repository
• Creating and Connecting to the Work Repository
• Managing ODI Agents
• Creating a Physical Agent
• Launching a Listener, Scheduler and Web Agent
• Example of Load Balancing

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
• Defining Agents
• Defining a Topology
• Planning the Topology

Describing the Physical and Logical Architecture

• Overview of Topology Navigator
• Creating Physical Architecture
• Creating a Data Server
• Testing a Data Server Connection
• Creating a Physical Schema
• Creating Logical Architecture
• Overview of Logical Architecture and Context Views
• Linking the Logical and Physical Architecture

Setting Up a New ODI Project

• Overview of ODI Projects
• Creating a New Project
• Creating and Maintaining Folders
• Organizing Projects and Folders
• Understanding Knowledge Modules
• Exchanging ODI Objects and Sharing Global Objects
• Exporting and Importing Objects
• Creating and Labeling with Markers

Oracle Data Integrator Model Concepts

• What is a Model?
• 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
• Copyright © 2013, Oracle. All rights reserved. Page 3
• 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
• Mapping with Knowledge Modules (KM)
• 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
• Selecting Knowledge Modules

Mapping: Monitoring and Debugging

• Monitoring Mappings
• Creating Objects with Operator
• Viewing Sessions and Tasks
• How to Monitor Execution of a Mapping
• How to Troubleshoot a Session
• Keys to Reviewing the Generated Code
• Working with Errors
• Tips for Preventing Errors

Designing Mappings: Advanced Topics

• Mapping with Business Rules
• Overview of Business Rule Elements
• Creating and Tracking Variables
• Creating User Functions
• Mapping Substitution Methods
• Modifying a KM
• Showing Variable Values in Log
• Customizing Reverse Engineering Using RKM

Creating and Running ODI procedures

• What is a Procedure?
• Examples of Procedures
• Creating Procedures
• Adding Commands
• Adding Options
• Running a Procedure
• Copyright © 2013, Oracle. All rights reserved. Page 4
• Viewing Results with Operator

Creating and Running ODI Packages

• What is a Package?
• Creating a Package
• Executing a Package
• Creating Advanced Packages
• Error Handling
• Controlling an Execution Path
• Creating a Loop
• Using the Advanced tab

Managing ODI Scenarios and Versions

• What is a Scenario?
• Managing Scenarios with Load Plans
• Preparing Scenarios for Deployment
• Automating Scenario Management
• Scheduling the ODI Scenario
• Overview of ODI version management
• Handling concurrent changes

Enforcing Data Quality and Auditing Data with ODI

• Why Data Quality?
• When to Enforce Data Quality?
• Data Quality in Source Applications
• Data Quality Control in the Integration Process
• Data Quality in the Target Applications
• Enforcing Data Quality
• Exploring Your Data
• Auditing Data Quality

Working with Changed Data Capture

• Overview of ODI version management
• Techniques of Changed Data Capture
• Changed Data Capture in ODI
• CDC Strategies and Infrastructure
• CDC Consistency
• Creating Change Data Capture (CDC)
• Viewing Data/Changed data
• Journalizing

Administering ODI Resources: Advanced Topics

• Using Open Tools
• Installing Open Tools
• Using Open Tools in a Package
• Using Open Tools in a Procedure or in a KM
• Developing Your Own Open Tools
• Setting Up ODI Security
• Defining Security Policies
• Defining Password Policies

Creating Web Services and Integration of ODI with SOA

• Copyright © 2013, Oracle. All rights reserved. Page 5
• Web Services in Action
• Using Data Services
• Setting Up Data Services
• Testing Data Services
• Installing Public Web Services
• Using Public Web Services
• Invoking Web Services
• Integrating ODI with SOA

Extending ODI with the SDK

• Coding SDK Public Interfaces
• Integrating through ODI SDK
• Examining SDK examples
• Copyright