PowerExchange Training: Mainframe Data Extraction and Change Data Capture

ExistBI is an Informatica Partner

Course Description

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. Applicable for software version 10.2

Course Objectives

At the end of the course, learners will 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

Course Summary

Next Public Course Dates

UK & Europe:

  • 11 - 13 August 2026
  • 8 - 10 September 2026
  • 13 - 15 October 2026

US & Canada:

  • 11 - 13 August 2026
  • 8 - 10 September 2026
  • 13 - 15 October 2026

More dates

Prerequisites
Duration
  • 3 Days
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite

Course Modules

PowerExchange Overview

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

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

Testimonials

“The PowerCenter training last week went very well. There were many practical exercises included which I really appreciated because they helped me understand the topics much better, I learned a lot and found the sessions very useful. I’m continuing to review and practice the content this week to consolidate what I’ve learned.

.”

★★★★★

- Taha Elmaadani, Data Integration Consultant, PTA IT Consulting

“Steve was a great instructor and was able to articulate the course material in a way that promoted learning.”

★★★★★

- Ben Ruddock, Analyst, GSP International Airport

“The BOW310/320 Web Intelligence Bootcamp was very good.  The experienced and friendly trainer was very patient with all our questions and made sure we completed each exercise correctly. The post class support was also excellent!”

★★★★★

- Kelly Delaberta, BI Data Analyst, US Air Force

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To discuss your training requirements or book a class, drop us a line

      To book this course, please fill in your details and submit the form.

        To book this course, please fill in your details and submit the form.