Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Bulk Extraction Mode

Bulk Extraction Mode

Use PWX batch application and relational connections to extract and load data for relational databases and nonrelational data sets and files through PowerExchange. PWXPC connects to PowerExchange through the PowerExchange Call Level Interface (SCLI).
When you use PWXPC, you can extract all records for multiple record types in a single pass for IMS unload data sets, VSAM data sets, and sequential files. In contrast, PowerExchange ODBC connections read a single record type at a time, which requires multiple passes of the data.
The following figure shows the data flow of source data from PowerExchange through PWXPC and PowerCenter to the target tables:
Data flows from the data source to the PowerExchange Listener. From the Listener, data flows across the network to the PowerExchange SCLI and then the PowerCenter Integration Service. From there, data flows to the target table.

0 COMMENTS

We’d like to hear from you!