Szkolenia Oracle

Cel szkolenia dlearning

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.

Plan szkolenia Rozwiń listę

  1. 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
  2. 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
    • Managing ODI Agents
    • Creating a Physical Agent
    • Launching a Listener, Scheduler and Web Agent
    • Example of Load Balancing
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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?
  8. 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
  9. 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
  10. 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
  11. 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
  12. Creating and Running ODI procedures
    • What is a Procedure?
    • Examples of Procedures
    • Creating Procedures
    • Adding Commands
    • Adding Options
    • Running a Procedure
    • Viewing Results with Operator
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. Creating Web Services and Integration of ODI with SOA
    • 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
  19. Extending ODI with the SDK
    • Coding SDK Public Interfaces
    • Integrating through ODI SDK
    • Examining SDK examples
Pobierz konspekt szkolenia w formacie PDF

Dodatkowe informacje


Wymagane prerekwizyty:

  • Basic knowledge of ELT data processing

Sugerowane prerekwizyty:

  • Working knowledge of SQL
Poziom trudności
Czas trwania 5 dni

Uczestnicy szkoleń otrzymają zaświadczenia o ukończeniu kursu sygnowane przez firmę Oracle.


Autoryzowany wykładowca Oracle.

Wszystkie szkolenia Oracle
Szkolenia powiązane tematycznie


Systemy operacyjne