Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange Bulk Data Movement
  3. PowerExchange Listener
  4. Adabas Bulk Data Movement
  5. Datacom Bulk Data Movement
  6. DB2 for i5/OS Bulk Data Movement
  7. DB2 for Linux, UNIX, and Windows Bulk Data Movement
  8. DB2 for z/OS Bulk Data Movement
  9. IDMS Bulk Data Movement
  10. IMS Bulk Data Movement
  11. Microsoft SQL Server Bulk Data Movement
  12. Oracle Bulk Data Movement
  13. Sequential File Bulk Data Movement
  14. VSAM Bulk Data Movement
  15. Writing Data with Fault Tolerance
  16. Monitoring and Tuning Options

Bulk Data Movement Guide

Bulk Data Movement Guide

Bulk Data Movement Components

Bulk Data Movement Components

PowerExchange uses some or all of the following components to move bulk data:
PowerExchange Client for PowerCenter (PWXPC)
A PowerCenter component that integrates PowerCenter with PowerExchange so that PowerCenter can access PowerExchange-controlled data and write it to various targets. Alternatively, you can use the PowerExchange ODBC drivers. However, Informatica recommends using PWXPC instead of the ODBC drivers. PWXPC provides additional functionality and better performance.
For information about PWXPC and the ODBC drivers, see
PowerExchange Interfaces for PowerCenter
.
PowerExchange Navigator
The graphical user interface from which you define and manage data maps for nonrelational data sources and targets and for DB2 tables that require user-defined fields and expressions. PowerExchange uses these definitions to determine the data sources and targets to process. Also, from the PowerExchange Navigator, you can create optional personal metadata profiles and perform database row tests. By performing a row test on a data map, you can view the source data to verify that PowerExchange can access it. By performing a row test on a personal metadata profile, you can view metadata for a data source.
PowerExchange Listener
A PowerExchange component that manages data maps for nonrelational files and DB2 tables and maintains them in the DATAMAPS file. The PowerExchange Listener also handles bulk data extraction requests from PowerCenter.
If a data source or target is on a system that is remote from the one on which you are using PowerExchange, you must run an additional PowerExchange Listener on that remote system to communicate with PowerExchange.

0 COMMENTS

We’d like to hear from you!