Table of Contents

Search

  1. Introduction
  2. PowerExchange Client for PowerCenter (PWXPC)
  3. PowerExchange ODBC
  4. PowerExchange Interfaces for PowerCenter Tips
  5. Datatypes and Code Pages
  6. PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring PowerExchange Services for Workflows

Configuring PowerExchange Services for Workflows

Before you run a workflow that uses PowerExchange services, you must configure the services.
To configure PowerExchange Services for workflows:
  1. Install PowerExchange on the PowerCenter Integration Service machine and on each node where you plan to run the Listener Service and Logger Service.
  2. Customize the DBMOVER file on each node where you plan to run PowerExchange Services, as follows:
    • Configure the LISTENER statement to identify the PowerExchange Listener.
    • For CDC sessions, configure CAPI_CONNECTION statements to control extraction processing. Include the same statements in each DBMOVER file.
    • If the PowerExchange Listener will connect to the PowerExchange Logger for Linux, UNIX, and Windows, customize the settings required for the PowerExchange Logger.
  3. Customize the DBMOVER file on each node that runs the PowerCenter Integration Service. Configure the SERVICE_NAME parameter of the NODE statement to identify the Listener Service.
  4. If the PowerExchange Listener for the data source will connect to a PowerExchange Logger, customize the pwxccl.cfg file on each node where you plan to run the Logger Service. Configure each pwxccl.cfg file to point to the same PowerExchange Logger files, and verify that the files are accessible to each node.
  5. Create a PowerExchange Listener Service on the primary and backup nodes for the service.
  6. If the PowerExchange Listener for the data source will connect to a PowerExchange Logger, create a PowerExchange Logger Service on the primary and backup nodes for the service.
  7. Start the services in the Administrator tool.

0 COMMENTS

We’d like to hear from you!