Курс: Oracle Data Integrator 12c: Administration and Development

Продолжительность курса: 24 ак. ч.

Формат обучения:
• Очно - на территории нашего учебного центра или на территории Заказчика (для корпоративных клиентов)
• Онлайн обучение с помощью вебинаров в режиме "здесь и сейчас"
• Дистанционно с помощью системы СДО в любое удобное для вас время

Описание курса:
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.
This offering details on how to use Oracle Data Integrator (ODI) to implement high-performance movement and transformation of data among various platforms. It also deals with usage of ODI graphical user interfaces that enable user to access different ODI components and resources that form ODI infrastructure. Using the graphical interfaces, you create and manage ODI repositories, which stores configuration information about the IT infrastructure, the metadata for all applications, projects, models and other ODI artifacts. You also learn how to create the ODI Topology, organize ODI models and design ODI interfaces, procedures, packages and other objects.

Аудитория:
• Data Modelers
• SOA Architect
• Data Warehouse Administrator
• Database Administrators
• Business Analysts
• Technical Consultant

Результат обучения:
После изучения курса слушатель будет уметь:
• Describe architecture of Oracle Data Integrator 10g
• Apply ODI Topology concepts for data integration
• Describe ODI Model concepts
• Design ODI Interfaces, Procedures, and Packages 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

Программа курса:
Модуль 1. Introduction
• What is Oracle Data Integrator?
• Types of ODI Agents
• Overview of Oracle Data Integrator Repositories
• About Graphical Modules
• Identifying the Course Units
• Why Oracle Data Integrator?
• Overview of ODI 10g Architecture
• Overview of ODI 10g Components

Модуль 2. Administering ODI Repositories and Agents
• Administrating the ODI Repositories
• Creating Repository Storage Spaces
• Managing ODI Agents
• Launching a Listener, Scheduler and Web Agent
• Creating and Connecting to the WorkRepository
• Creating a Physical Agent
• Example of Load Balancing
• Creating and Connecting to the Master Repository

Модуль 3. ODI Topology Concepts
• Overview of ODI Topology
• Defining a Topology
• Defining the Physical Architecture
• About Data Servers and Physical Schemas
• Defining the Logical Architecture
• Defining Agents
• Planning the Topology
• Mapping Logical and Physical Resources

Модуль 4. Describing the Physical and Logical Architecture
• Creating Logical Architecture
• Testing a Data Server Connection
• Overview of Logical Architecture and Context Views
• Creating a Physical Schema
• Linking the Logical and Physical Architecture
• Overview of Topology Manager
• Creating Physical Architecture
• Creating a Data Server

Модуль 5. Setting Up a New ODI Project
• Overview of ODI Projects
• Exchanging ODI Objects
• Using Markers
• Exporting and Importing Objects
• Creating a New Project
• Understanding Knowledge Modules
• Using Folders
• Organizing Projects and Folders

Модуль 6. Oracle Data Integrator Model Concepts
• Organizing Models
• Creating Datastores
• Using Constraints in ODI
• What is a Model?
• Creating Models
• Creating Keys and References
• Understanding Reverse Engineering
• Understanding Metadata in ODI

Модуль 7. Organizing ODI Models and Creating Datastores
• What is a Filter?
• What is a Constraint?
• What is a Staging Area?
• Business Rules for Interfaces
• What is a Mapping?
• What is a Join?
• What is an Interface?
• Creating a Basic Interface

Модуль 8. ODI Interface Concepts
• Creating a Basic Interface
• What is an Interface?
• Using Knowledge Modules (KM) with ODI Interface
• What is a Staging Area?
• Overview of Integration Process
• About Execution Location
• Business Rules for Interfaces
• What is a Mapping, Filter, Join?

Модуль 9. Designing Interfaces
• Creating Joins
• Filtering data
• Specifying the Staging Area
• Multiple Source Datastores
• Selecting Knowledge Modules
• Designing an Interface
• Disabling Transformations
• Overview of the Flow

Модуль 10. Interfaces: Monitoring and Debugging
• Keys to Reviewing the Generated Code
• Tips for Preventing Errors
• How to Troubleshoot a Session
• Working with Errors
• Monitoring Interfaces
• Viewing Sessions and Tasks
• Using Operator
• How to Monitor Execution of an Interface

Модуль 11. Designing Interfaces: Advanced Topics
• Using Substitution Methods
• Developing Your Own KM
• Using Business Rules in Interfaces
• Using RKM for Customized Reverse Engineering
• Using variables
• Using User Functions
• Overview of Business Rule Elements
• Modifying a KM

Модуль 12. Using ODI procedures
• Using Operator to View Results
• Examples of Procedures
• What is a Procedure?
• Running a Procedure
• Adding Commands
• Adding Options
• Creating Procedures

Модуль 13. Using ODI Packages
• Using the Advanced tab
• Controlling an Execution Path
• What is a package?
• Creating a Loop
• Creating Advanced Packages
• Error handling
• Creating a package
• Executing a package

Модуль 14. Managing ODI Scenarios and Versions
• Scheduling the ODI Scenario
• Overview of ODI version management
• Using Version Browser and Version Comparison Tool
• Handling concurrent changes
• Managing Scenarios
• Preparing Scenarios for Deployment
• What is a Scenario?
• Automating Scenario Management

Модуль 15. Enforcing Data Quality and Auditing Data with ODI
• Enforcing Data Quality
• Data Quality in the Target Applications
• Why Data Quality?
• Data Quality in Source Applications
• Exploring Your Data
• Data Quality Control in the Integration Process
• When to Enforce Data Quality?
• Auditing Data Quality

Модуль 16. Working with Changed Data Capture
• CDC Strategies and Infrastructure
• Overview of ODI version management
• Techniques of Changed Data Capture
• Changed Data Capture in ODI
• Using Journalizing
• CDC Consistency
• Viewing Data/Changed data
• Using CDC

Модуль 17. Administering ODI Resources: Advanced Topics
• Using Open Tools
• Setting Up ODI Security
• Defining Password Policies
• Defining Security Policies
• Using Open Tools in a Package
• Installing Open Tools
• Developing Your Own Open Tools
• Using Open Tools in a Procedure or in a KM

Модуль 18. Using Web Services and Integration of Oracle Data Integrator with SOA
• Using Public Web Services
• Using Data Services
• Testing Data Services
• Web Services in Action
• Invoking Web Services
• Installing Public Web Services
• Integrating ODI with SOA
• Setting Up Data Services Записаться на курс