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

Configuring CDC Restart Attributes

Configuring CDC Restart Attributes

The following table describes the optional restart connection attributes for CDC sessions:
Connection Attribute
Change or Real Time
Description
Application Name
Both
Application name for the extraction. This name is part of the audit trail for data extractions by the PowerExchange Listener.
The application name must be unique for each session. The name is case sensitive and cannot exceed 20 characters.
Default is the first 20 characters of the workflow name.
RestartToken File Folder
Both
Folder name that contains the restart token override file on the PowerCenter Integration Service node.
Default is $PMRootDir/Restart.
RestartToken File Name
Both
File name in the restart token file folder that contains the restart token override file. PWXPC uses the contents of this file, if any, in conjunction with the state information to determine the restart point for the session.
Default is the
Application Name
value if specified, or the workflow name if
Application Name
is not specified.
You can use numerous CDC reader application connection attributes to specify restart information. PWXPC uses the restart information to tell PowerExchange the point from which to start reading the captured change data.
Be careful when you use the default value for
Application Name
. The default might not result in a unique application name. The
Application Name
value and the
RestartToken File Name
values must be unique for every CDC session. If a non-unique name is specified for either attribute, CDC session failures and potential data loss can occur or results are unpredictable.

0 COMMENTS

We’d like to hear from you!