View Course Agenda

PowerExchange: Mainframe Data Extraction

Instructor Led | Data Integration | 2 Days

PowerExchange: Mainframe Data Extraction

Course Overview

Explore the basics of the PowerExchange Client for PowerCenter in order to enhance your current PowerCenter experience. Topics covered include PowerExchange Navigator, Data Maps, SQL Syntax, Processing Complex Flat Files, and PowerExchange/PowerCenter Integration.

Enroll Now


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

  • Understand PowerExchange benefits and architecture
  • Use the Navigator to: Create data maps for flat files, filter and check data integrity and create data maps for complex non-relational files
  • Create personal metadata
  • Integrate PowerExchange with PowerCenter using PowerExchange Client for PowerCenter

Target Audience

  • Developer


  • None


Module 1: PowerExchange Overview

  • PowerExchange Functionality
  • PowerExchange Architecture

Module 2: PowerExchange Navigator

  • Navigator Functions, Configuration and Setup
  • Data Maps
  • Personal Metadata
  • Managing Navigator Objects
  • Lab2: Creating a Data Map from an EBCDIC file

Module 3: Data Maps in Depth

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

Module 4: SQL Syntax

  • Using SQL WHERE Clause for Non-Relational
  • Using DTLDESCRIBE Function to Retrieve
  • Lab4: Filtering Records and Array Handling

Module 5: Personal Metadata

  • Creating Personal Metadata
  • Testing Personal Metadata
  • Lab5: Adding Personal Metadata

Module 6: Processing Complex Flat Files

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

Module 7: PowerExchange/PowerCenter Integration

  • Using PowerExchange Client for PowerCenter (PWXPC)
  • Lab 7: Integrating with PowerCenter using PowerExchange
  • Client for PowerCenter

Module 8: PowerExchange Utilities


Enroll Now

Back to Course Overview


Instructor Led | Data Integration | 2 Days

Print Friendly and PDF