captcharefresh

Powered by ChronoForms - ChronoEngine.com

ENQUIRY
LIVE CHAT

Oracle Data Integration

Duration: 3 Days

 

What you will learn

This Oracle Data Integrator training covers advanced techniques for using Oracle Data Integrator 11g (ODI). Learn to implement high-performance movement and transformation of data among various platforms.

  • Learn To:
    • Perform data integration and transformation among various platforms using advance techniques.
    • Design advanced ODI interfaces, procedures and packages to perform EL-T data transformations.
    • Set up ODI security by implementing strongly secured approach with non-generic profiles and external user authentication.
    • Develop and customize Knowledge Modules with substitution methods and Java.
    • Automate ODI tasks using Groovy script editor.
    • Implement various integration strategies with ODI using best practices.
    • Use ODI Web services and perform integration of ODI in an Enterprise environment and SOA.
  • Benefits to You
    • Improve performance and reduce integration costs across your organizations' heterogeneous systems. Centralize data across databases using your new skills to perform data integration, design advanced ODI interfaces, setup ODI security, and automate ODI tasks.
  • Administering the IT infrastructure & Metadata
    • This course will help you learn to use the ODI Studio for developing projects and models. Expert Oracle instructors will also explore how to monitor executions through instruction and hands-on exercises.
  • Advanced ODI development for High-Performance Data Integration
    • Furthermore, this course will teach you how to perform advanced ODI topology configuration. Learn to design advanced ODI interfaces, procedures, packages and other objects for high-performance data integration among various technologies.
  • Perform Extract Load Transform (EL-T) in Enterprise Environment
    • For enterprise SOA deployments, there is almost always a need for enterprise data extraction, loading and transformation. By leveraging the native SOA architecture within Oracle Data Integrator, this course will help you perform EL-T from SOA applications. You'll also learn how to implement the integration of ODI in an Enterprise environment and in SOA. In addition, this course will teach you how to execute ODI transformation from a BPEL process.
  • Apply Strongly Secured Approach
    • Taking this course will help you learn how to enhance the ODI security by applying the Strongly Secured Approach and by implementing External Authentication. This course is based on Oracle Data Integrator 11g(11.1.1.6).
  • Audience
    • Business Analysts
    • Data Modelers
    • Data Warehouse Administrator
    • Database Administrators
    • SOA Architect
    • Technical Consultant

Related Training

  • Required Prerequisitese
    • Basic Knowledge of ODI 11g
    • Basic knowledge of ELT data processing
    • Basic knowledge of SQL
  • Suggested Prerequisites
    • Oracle Data Integrator 11g: Integration and Administration
    • Working Knowledge of ODI 11g
    • Working knowledge of SQL

Course Objectives

  • Develop and enhance Knowledge Modules
  • Design advanced integration interfaces
  • Automate ODI tasks using ODI Groovy editor
  • Enhance ODI security with strongly secured approach
  • Expose ODI Scenarios as Web services
  • Integrate ODI in Enterprise environment and SOA
  • Describe best practices for implementing integration strategies
  • Describe Various ODI Integration Patterns

Course Topics

  • Developing ODI Knowledge Modules
    • Overview of Different Types of KMs
    • Guidelines for KM Developers
    • Working with Substitution Methods
    • Applying Various ODI Tags
    • Implementing Java in KMs
    • Troubleshooting and Debugging KMs
  • Designing Advanced Integration Interfaces
    • Designing Integration Interfaces: E-LT and ETL - Style Interfaces
    • Selecting LKM and Mono-Connection (Single Technology) IKM
    • Applying Best Practices for Integration Interfaces Design
    • Designing Temporary Interfaces
    • Implementing Lookups
    • Combining Multiple Datasets
    • Using Set-Based Operators
    • Partitioning ODI Datastores
  • Using variables
    • Describing a Variable's Scope Inserting
    • Variables in Object Properties Using
    • Variables within Variables
    • Defining Variables in the Resource Name of a Datastore
    • Applying Variables in Topology Objects
    • Setting Variables as Start Up Parameters
    • Tracking Variables
  • Using Groovy in ODI
    • Interacting Programmatically with ODI
    • Overview of ODI SDK
    • Introduction to Groovy
    • Using Groovy Editor
    • Automating Development Tasks with Groovy
  • Using Complex Files
    • What are Complex Files
    • Determining Technical Requirements for Complex Files Project
    • Applying nXSD Schema: an Example
    • Setting up the Topology for Complex Files
    • Creating and Reverse-Engineering a Complex Files Model
    • Designing an Interface with Complex Files
  • Enhancing ODI Security
    • Overview of ODI Security
    • Best Practices for Enhancing ODI Security
    • Applying Non-Generic Profiles Configuring
    • External Authentication
    • Configuring LDAP for External Authentication with ODI
  • Integration of ODI in Enterprise Environment
    • Configuring Java EE Agent
    • Monitoring ODI Environment with Enterprise Manager
    • Monitoring ODI Environment with ODI Console
  • Integration of ODI within SOA
    • Working with Web Services with ODI
    • Overview of Public Web Services Invoking
    • Web Services from ODI Exposing ODI
    • Scenario as a Web Service
    • Configuring the OdiInvokeWebService Tool
    • Executing an ODI Scenario from a BPEL Process within SOA
  • Choosing Integration Strategies: Best Practices
    • Selecting Integration Strategies
    • Loading and Integration Patterns
    • Selecting Staging Area Location
    • Working with Slowly Changing Dimensions
    • Working with Changed Data Capture
    • Using ODI with Oracle Golden Gate

Duration: 4 Days

 

What you will learn

The Oracle GoldenGate 11g: Fundamentals for Oracle Edition 2 course focuses on Oracle-to-Oracle database replication. This course introduces the Oracle GoldenGate architecture as well as various product features. Participants learn to install Oracle GoldenGate and prepare the source and target environments. The course teaches how to use the Oracle GoldenGate command line interface (GGSCI) efficiently. Participants configure Change Capture (Extract), Change Delivery (Replicat), and Initial Load. They learn to extract trails and files using Data Pump, create parameter files, and to manage Oracle GoldenGate instances. Capture of both DML and DDL will be configured for both uni- and bi-directional replication.

  • Learn To:
    • Install Oracle GoldenGate on Linux and Windows platforms
    • Issue GGSCI commands
    • Configure, start, stop, and monitor Change Capture and Delivery processes
    • Manage Extract trails and files using Data Pump and logdump
    • Create parameter files to transform data
    • Manage multiple Oracle GoldenGate instances
    • This course is based on Oracle Golden Gate version 11.2.1.

Audience

  • Configuration Consultant
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Data Warehouse Developer
  • Database Administrators
  • Database Designers
  • System Integrator
  • Technical Consultant
  • This course is based on Oracle Golden Gate version 11.2.1.

Related Training

  • Required Prerequisites
    • Familiarity with Oracle Database and basic SQL using SQL*Plus.
  • Suggested Prerequisites
    • Familiarity with Linux text editors such as vi or gedit

Course Objectives

  • Design replication solutions using Oracle GoldenGate products and environments
  • Install Oracle GoldenGate on Linux and Windows platforms (the labs are Linux)
  • Prepare the source and target database environments (assumes Oracle-to-Oracle replication)
  • Issue GGSCI commands (batch Obey scripts and command-line interactive)
  • Configure, start, stop, and monitor Change Capture (Extract)
  • Configure, start, stop, and monitor Change Delivery (Replicat)
  • Configure, start, stop, and monitor Initial Load
  • Manage Extract trails and files using Data Pump and utilities such as logdump
  • Control network transmission using compression and encryption
  • Create parameter files
  • Transform data
  • Manage multiple Oracle GoldenGate instances

Course Topics

  • Introduction
    • Discussing Required versus Suggested Knowledge
    • Listing Course Objectives
    • Discussing Course Non-Objectives (available as other follow-on courses)
  • Technology Overview
    • Creating Oracle GoldenGate Topologies
    • Reviewing Oracle GoldenGate Use Cases
    • Assembling Building Blocks
    • Listing Supported OS
    • Listing Supported Databases
    • Listing the Oracle Goldengate Product Line
    • Describing GUI Management Options
    • Listing Non-Database Sources and Targets
  • Oracle GoldenGate Architecture
    • Describing Oracle GoldenGate Process Groups
    • Explaining change Capture and Delivery (with and without a data pump)
    • Explaining Initial Data Load
    • Contrasting Batch and Online Operation
    • Explaining Oracle GoldenGate Checkpointing
    • Describing Commit Sequence Numbers (CSN)
    • Describing Oracle GoldenGate Files and Directories
  • Installing Oracle GoldenGate
    • Listing System Requirements
    • Performing Installation Configuring
    • Environment Variables Using
    • GGSCI
    • Running Oracle GoldenGate from the OS shell.
  • Configuration Overview and Preparing the Environment
    • Reviewing Configuration Overview
    • Configuring Manager Process
    • Creating Source Definitions
    • Preparing the Source Database
    • Assigning Oracle Database Roles/Privileges Required
  • Configuring Change Capture (Extract)
    • Reviewing Extract Overview
    • Accessing Logs on Oracle ASM
    • Accessing Logs Remotely
    • Configuring Extract Tasks
    • Adding Extract Group
    • Editing Extract Parameters
    • Extracting Use of Archived Transaction Logs
    • Adding Trails
  • Configuring Change Delivery (Replicat)
    • Reviewing Replicat Overview
    • Configuring Replicat Tasks
    • Configuring a Sample Environment
  • Configuring Extract Trails and Files (Data Pump)
    • Reviewing Extract Trails and Files
    • Overview Describing Trail Formats
    • Using Logdump for Viewing Trails
    • Reversing the Trail Sequence
    • Configuring and Using Data Pumps
  • Performing Initial Load
    • Oracle GoldenGate Methods Listing
    • Database-specific Methods
    • Describing Resource Limitations
    • Listing Advantages of Oracle GoldenGate Methods
    • Configuring File Load Methods
    • Configuring Direct Load Methods
    • Handling Collisions with Initial Load
  • Editing Configuration Parameters
    • Editing Parameter Files
    • Contrasting GLOBALS versus Process Parameters
    • Configuring GLOBALS Parameters
    • Configuring Manager Parameters
    • Configuring Extract Parameters
    • Configuring Replicat Parameters
  • Filtering and Data Selection
    • Filtering and Data Selection
    • Mapping Columns Between Different Schemas
    • Using Built-in "@" (at) Functions
    • Using SQLEXEC to Interact Directly with a Database
  • Additional Transformation Concepts
    • Configuring and Using Macros
    • Configuring and Using User Tokens
    • Configuring and Using User Exits
    • Configuring and Using Oracle Sequences
  • Configuration Options
    • Configuring and Using BATCHSQL
    • Configuring and Using Compression
    • Configuring and Using Encryption
    • Configuring and Using Event Actions
  • Bidirectional Replication
    • Reviewing Bidirectional Considerations
    • Detecting Loops
    • Avoiding Conflicts
    • Configuring and Using Conflict Detection and Resolution
    • escribing Identity Types Issues
  • DDL Replication
    • Reviewing Data Description Language Replication Overview
    • Configuring and Using Options for DDL Replication
    • Configuring and Using String Substitution in DDL
Best viewed in IE 10+, Firefox 20+, Chrome , Safari5+, Opera12+
Cyret Copyright @ 2018. All Rights Reserved
Go Top