View Course Agenda

PowerExchange: Mainframe Data Extraction and Change Data Capture

Instructor-led | Data Integration| 3 Days | Version 10.2

PowerExchange: Mainframe Data Extraction and Change Data Capture

Course Overview

Applicable for software version 10.2. Gain the skills necessary to use PowerExchange Client to create Data Maps, use SQL Syntax, process VSAM, DB2, SQL Server data, and integrate PowerExchange and PowerCenter.  Learn to deliver data on demand in batch and Change Data Capture (CDC) modes using PowerExchange with Oracle, SQL Server, and AS400 DB2. 

infa-university-lp-buttons.png 

Objectives

After successfully completing this course, students should be able to:

  • Discuss PowerExchange benefits and architecture
  • Use the Navigator to create data maps for flat files, and VSAM.
  • Create data maps for complex non-relational files
  • Create personal metadata
  • Create registrations for DB2
  • Integrate PowerExchange with PowerCenter 
  • Perform Oracle change data capture (CDC) with Databases such as Oracle, SQL Server, and DB2

Target Audience

  • Developer

Prerequisites

  • PowerCenter: Data Integration for Developers (Instructor Led) OR PowerCenter: Developer, Level 1 (onDemand)

Agenda

Module 01: PowerExchange Overview

  • PowerExchange Functionality
  • PowerExchange Architecture
  • PowerExchange components
  • Features and benefits
  • DBMOVER configuration file

Module 02: PowerExchange Navigator

  • Navigator Objects
  • Navigator functions
  • Data Maps
  • Copybooks
  • Personal Metadata
  • Managing Navigator Objects
  • Lab: Creating a Data Map from an EBCDIC file

Module 03: Data Maps

  • Creating a Data Map
  • Defining the Records in a File
  • Field Level Processing
  • Adding Expression Fields
  • Table Definitions
  • Array processing
  • Lab: Manual Data Map Creation
  • Lab: Importing a Multi-Record File with a COBOL Copybook Array Processing
  • Lab: Array Processing

Module 04: SQL Syntax and Personal Metadata

  • Using SQL WHERE Clause for Non-Relational Database
  • Using DTLDESCRIBE Function to Retrieve
  • Personal Metadata
  • Creating Personal Metadata
  • Testing Personal Metadata
  • Lab: Filtering Records and Array Handling
  • Lab: Adding Personal Metadata

Module 05: Processing Complex Flat Files

  • File and Field Data Formats
  • Variable Length Binary Data
  • Lab: Decoding a Complex Flat File

Module 06: VSAM Data Maps

  • VSAM overview
  • VSAM Datasets
  • Access Methods
  • Create Data Maps
  • Perform row tests
  • Lab: Creating a data map from a VSAM file
  • Lab: Creating a data map from a Multi layout file

Module 07: PowerExchange/PowerCenter Integration

  • Using PowerExchange Client for PowerCenter (PWXPC)
  • PWXPC Advantages
  • PWXPC Sources and Targets
  • Lab: Integrating with PowerCenter using PowerExchange Client for PowerCenter

Module 08: PowerExchange Oracle CDC Overview

  • PowerExchange Oracle RT CDC Architecture
  • Characteristics of applications to extract changes
  • Pre-requisites for using PWX Oracle CDC
  • Register an Oracle Source for CDC using PWX
  • Lab: Creating a Registration group

Module 09: Integrating PowerExchange Oracle CDC with PowerCenter

  • Creating PowerCenter mappings and workflows using PowerExchange Client for PowerCenter (PWXPC) to connect to PowerExchange
  • Session restart/recovery features with PWXPC
  • Remote logging of data
  • PowerExchange CDC Publisher
  • Lab: Materializing the Target with PowerExchange Mapping and Workflow Integration
  • Lab: PowerExchange CDC Mapping and Workflow Integration
  • Lab: Oracle Remote logging of data
  • Lab: PowerExchange CDC Mapping and Workflow Integration (Remote)
  • Lab: PowerExchange CDC Publisher

Module 10: PowerExchange Field Sensitive Capture

  • Field Sensitive Change Capture concepts
  • Differences between CI (Change Indicator) and BI ( Before Image)
  • Filtering unwanted change records from an extraction
  • Lab: Field Sensitive Change Capture

Module 11: PowerExchange Oracle CDC Overview 

  • PowerExchange SQL Server CDC Architecture
  • Pre-requisites for using PWX SQL Server CDC
  • Configuring Consumer API (CAPI) parameters
  • Enable distribution through SQL Server Management console
  • Register an SQL Server source for CDC using PWX
  • Manage schema changes
  • Lab: Create a Registration group and perform CDC

Module 12: PowerExchange MySQL CDC Overview

  • MySQL Change Data Capture
  • Configure MySQL for CDC
  • Configure PowerExchange for MySQL CDC
  • Create MySQL Registration Group
  • Perform row test
  • Lab: Setting up MySQL
  • Lab: Create a registration group and perform CDC

Module 13: PowerExchange i5/OS CDC Overview

  • i5/OS Change Data Capture
  • i5/OS PowerExchange CDC Architeture
  • Extraction maps
  • Extration process
  • DB2 for i5/OS Change Data Capture
  • Task flow for extracting Change Data
  • Demo: Setting up a AS400 DB2 for Change Data Capture
  • Demo: Creating Registration Group and Perform DB2 AS/400 CDC
  • Demo: Creating Registration and Performing CDC for DB2 i series/zOS

Module 14: PowerExchange Utilities

  • Data Map Utility (STLURDMO)
  • Remote Program Utility (DTLREXE)
  • Reporting Utlities
  • Execution Management and Monitoring Utlities

Module 15: Monitoring, Troubleshooting, and Recovery

  • Monitoring of CDC processes
  • Heartbeat tables
  • Long running transactions
  • PowerExchange Services failover
  • Performance enhancement opportunities in the PWX Oracle CDC environment
  • Best Practices for using PWX Oracle CDC
  • Troubleshoot some common problems
 
Enroll Now 

Back to Course Overview

QUESTIONS?

Instructor-led | Data Integration | 3 Days | Version 10.2

 

Print Friendly and PDF