Bulk Data Movement Guide

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

Back Next

Bulk Data Movement Task Flow

After you install PowerExchange, perform tasks to implement a bulk data movement that uses PowerExchange in conjunction with PowerCenter.

The following table lists the high-level tasks that you perform and provides references to documentation for performing the tasks:

Step	Task	References
1	Configure the PowerExchange Listener.	PowerExchange Listener
2	Start the PowerExchange Listener.	PowerExchange Listener
3	Create the target database structure, if necessary.	Your DBMS documentation
4	From the PowerExchange Navigator, create data maps for any nonrelational sources and for any DB2 sources that require user-defined fields and expressions.	PowerExchange Navigator User Guide
5	(Optional, if using a data map) From the PowerExchange Navigator, perform a database row test of each data source to verify that PowerExchange can access the data and to test any data maps that you are using.	PowerExchange Navigator User Guide
6	From the PowerCenter Designer, create a mapping.	PowerExchange Interfaces for PowerCenter PowerCenter Designer Guide
7	From the PowerCenter Workflow Manager, define a workflow and session, configure a connection, and run the workflow to perform the bulk data movement	PowerExchange Interfaces for PowerCenter PowerCenter Workflow Basics Guide

The task flow can vary significantly by DBMS type and bulk data movement strategy. For example, for DB2 for z/OS, you can use a DB2 image copy as a data source or use the DB2 LOAD utility to load data to the target. For IMS and IDMS, you can use a netport job.

Rename Saved Search

Table of Contents

Bulk Data Movement Guide

Bulk Data Movement Guide

Bulk Data Movement Task Flow

Bulk Data Movement Task Flow