Oracle Data Integrator 12c: Integration and Administration

DesTech
Remote
Schedule

Partner
Remote
Schedule

Course DateStart TimeEnd TimeTime ZoneLocationDaysPrice
Nov 28, 202209:0005:00ESTToronto - In Class or by Video Conference5$5,000 USDPurchase


O12C: ODIADM

Oracle Data Integrator 12c: Integration and Administration

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 (ELT) architecture leverages disparate RDBMS engines to process and transform the data - the approach that optimizes performance, scalability and lowers overall solution costs.

Duration: 5 Days

Prerequisites

  • Basic knowledge of ELT data processing
  • Working knowledge of SQL (suggested)

Audience

  • Business Analysts
  • Data Modelers
  • Data Warehouse Administrators
  • Database Administrators
  • SOA Architects
  • Technical Consultants

Learning Objectives

  • Describe ODI Model concepts
  • 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
  • Set up and maintain a secure, multi-user ODI environment
  • Implement change data capture with ODI
  • Use ODI Web services and perform integration of ODI with SOA

Topics

  • Administering ODI Repositories and Agents
  • ODI Topology Concepts
  • Describing the Physical and Logical Architecture
  • Setting Up a New ODI Project
  • Oracle Data Integrator Model Concepts
  • Organizing ODI Models and Creating Data Stores
  • ODI Mapping Concepts
  • Designing Mappings
  • Mapping: Monitoring and Debugging
  • Designing Mappings: Advanced Topics
  • Creating and Running ODI Procedures
  • Creating and Running ODI Packages
  • Managing ODI Scenarios and Versions
  • Enforcing Data Quality and Auditing Data with ODI
  • Working with Changed Data Capture
  • Administering ODI Resources: Advanced Topics
  • Creating Web Services and Integration of ODI with SOA
  • Extending ODI with the SDK
  • Creating Web Services and Integration of ODI with SOA
  • Extending ODI with the SDK
Right Menu IconMENU