PowerExchange Interfaces for PowerCenter

10.5.5
- 10.5.8
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

PowerExchange Interfaces for PowerCenter Overview

You can use the following interfaces to extract and load data through PowerExchange when you use PowerCenter:

PowerExchange Client for PowerCenter (PWXPC)
. Part I describes PWXPC. You can use it to extract and load data through PowerExchange for a variety of datatypes on a variety of platforms. PWXPC is fully integrated into PowerCenter.

PowerExchange ODBC
. Part II describes the PowerExchange ODBC interface. You can use PowerExchange ODBC connections with PowerCenter to extract and load data through PowerExchange for a variety of datatypes on a variety of platforms.

When connecting to PowerExchange, Informatica recommends that you use PWXPC instead of PowerExchange ODBC. PWXPC has additional functionality as well as improved performance and superior CDC recovery and restart.

The following table compares the interface functionality of the PowerExchange Client for PowerCenter and PowerExchange ODBC:

PWXPC	ODBC	Function	Description
Yes	Yes	Extracts bulk data and changed data	PowerExchange extracts bulk data for relational and nonrelational sources and changed data for CDC sources.
Yes	No	Extracts data for multiple sources or records in a single pass	PowerExchange uses group source to extract changed data for multiple data sources or bulk data for multiple record types in a VSAM and sequential files in a single pass.
Yes	No	Saves target data and CDC restart information in a single commit	CDC restart information is stored in the same database as the relational target table or MQ queue. The restart information is updated in the same commit as the target data providing guaranteed restart and recovery for CDC data.
Yes	No	Uses PowerCenter graceful stop for real-time sessions	PowerCenter stops real-time sessions after all data in the pipeline is written to the targets.
Yes	No	Uses the change indicator to determine the type of change record	Each change record indicates whether it is an insert, update, or delete. When the change indicator is used, an Update Strategy transformation is not required to process inserts, updates, and deletes.
Yes	No	Creates source definitions from PowerExchange extraction maps	Extraction maps contain the PowerExchange auto-generated columns minimizing modification of the source definition in Designer.
Yes	No	Uses the file name in the PowerCenter source definition	PowerCenter source definition can specify the file name and override the file name specified in the PowerExchange data map.

Rename Saved Search

Table of Contents

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter Overview

PowerExchange Interfaces for PowerCenter Overview