Seminar / Kurs
Oracle Data Integrator 12c: Integration and Administration in Rostock
PROTRANET GmbH
PROTRANET GmbH
Inhalte
- 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
- 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 ...
Lernziele
Introduction
- Identifying the Course Units
- 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
- 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
- Launching a Listener, Scheduler and Web Agent
- 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
- 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
- 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
- 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
- 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?
- 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 a Mapping
- Multiple Source Data stores
- Creating Joins
- Filtering Data
- Disabling Transformations
- Overview of the Flow
- Specifying the Staging Area
- Selecting Knowledge Modules
- 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
- 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
- Using Partitioning in a Mapping
- Reusable Mappings
- Derived Select (Subselect) for Reusable Mappings
- Using User Functions
- Creating a User Function
- Using Substitution Methods
- Developing Your Own Knowledge Module
- What is a Procedure?
- Examples of Procedures
- Creating Procedures
- Adding Commands
- Adding Options
- Running a Procedure
- Viewing Results with Operator
- 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
- Starting a Session in Debug mode
- Specifying Debug Properties
- Control Execution Flow
- Screen Step Numbering
- 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
- What Are Load Plans?
- Load Plan Editor
- Load Plan Steps
- Defining the Restart Behavior
- Benefits of Using Load Plans
- Handling Failed Load Plans
- 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
- 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
- Introduction to ODI Security Navigator
- Security Concepts: Overview, Defining Security Policies
- Creating Profiles, Creating Users, Assigning a Profile to a User, Assigning an Authorization by Profile or User
- Defining Password Policies, Implementing External Authentication
- Generating Topology Reports
- Integration of ODI with Enterprise Manager
- Java EE Agent and Enterprise Manager Configuration with WebLogic Domain
- Using ODI Console
- ODI: VCS Integration
- ODI: Selecting the Required VCS
- SVN Connections
- Configuring the Subversion Repository with ODI
- Adding a Single Non-Versioned Object to SVN, Adding Multiple Non-Versioned Objects to SVN
- Creating a New Version for an Object
- Creating Full or Partial Tags in the Subversion Repository
- Performing a Branch Merge
- Big Data Concepts
- Emergence of Apache Hadoop
- Hadoop Ecosystem
- Apache HBase, Apache Hive, Apache Pig
- Apache Spark, Apache Sqoop, Apache Oozie
- Hadoop Data Integration: Overview
- Big Data Knowledge Modules Matrix
- ODI: Hadoop Integration Process
Introduction
- Identifying the Course Units
- Why Oracle Data Integrator?
- Overview of ODI Architecture
- Overview of ODI Components
- About Graphical Modules
- Types of ODI Agents
- Overview of Ora...
Zielgruppen
- Database Administrators
- Business Analysts
- Technical Consultant
- Data Modelers
- SOA Architect
- Data Scientist
- Data Warehouse Administrator
- Database Administrators
- Business Analysts
- Technical Consultant
- Data Modelers
- SOA Architect
- Data Scientist
- Data Warehouse Administrator
Termine und Orte
| Datum | Dauer | Preis | ||
|---|---|---|---|---|
| Rostock, DE | ||||
| 10.08.2026 - 14.08.2026 40 h | 40 h | Details | Details Jetzt buchen | |
| Datum | Dauer | Preis | ||
|---|---|---|---|---|
| Rostock, DE | ||||
| 10.08.2026 - 14.08.2026 40 h | 40 h | Details | Details Jetzt buchen | |