Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • PowerExchange CDC Publisher 1.1
  • All Products

Table of Contents

Search

  1. Preface
  2. PowerExchange CDC Publisher Overview
  3. Installing and Upgrading PowerExchange CDC Publisher
  4. PowerExchange CDC Publisher Key Concepts
  5. PowerExchange Change Capture Environment
  6. Target Messaging Systems
  7. Configuring PowerExchange CDC Publisher
  8. Streaming Change Data
  9. Monitoring PowerExchange CDC Publisher
  10. Administering PowerExchange CDC Publisher
  11. Command Reference for the Command-Line Utilities
  12. Avro Schema Formats
  13. Message Reference

User Guide

User Guide

Back Next

PowerExchange Extract Configuration Properties

PowerExchange Extract Configuration Properties

The sample cdcPublisherPowerExchange.cfg file contains properties that the PowerExchange CDC Publisher uses to extract change from PowerExchange and to retrieve PowerExchange extraction map definitions of source objects. The following list describes the properties in the sample file. It also includes some additional properties that you might want to use.

Property Descriptions

The following properties are in the sample cdcPublisherPowerExchange.cfg file:
Extract.pwxCapiConnectionName
Required. The NAME parameter value in the CAPX CAPI_CONNECTION statement in the PowerExchange DBMOVER configuration file. This CAPI_CONNECTION statement is used to connect to the PowerExchange change data stream to read data from PowerExchange Logger log files.
No default value is provided.
Extract.pwxExtractionMapSchemaName
Required. The PowerExchange-generated schema name that is included in the names of the PowerExchange extraction maps for the source objects. This schema name has the format u
nninstance
 or d
nninstance
, where "u" indicates a user-defined extraction map, "d" indicates the default extraction map generated from the capture registration,
nn
 is a two-digit value that represents the source type, and
instance
 is the instance value from the PowerExchange registration group for the data source. The schema name is the first part of the full extraction map name:
xnninstance
.
mapname
_
tablename
. This property is used to select the extraction maps that the CDC Publisher will use to extract change data.
All extraction maps with names that match the specified schema name or mask are selected. If you want to use a subset of these extraction maps, define the Extract.captureConsumerExcludeNameList or Extract.captureConsumerIncludeNameList property to filter the extraction maps.
No default value is provided.
Extract.captureConsumerIncludeNameList
A list of the extraction maps that match the specified schema name and that you want to explicitly
include
 in extraction processing. The PowerExchange CDC Publisher process will use only these included extraction maps. Any other extraction maps that were selected based on the extraction-map schema name are ignored. For each extraction map to include, enter the full extraction map name in the format
xnninstance
.
mapname
_
tablename
. Use a comma (,) separator between the values, for example: 
Extract.captureConsumerIncludeNameList=
xnninstance
.
mapname_tablename
1,
xnninstance
.
mapname_tablename
2
,...
You can include the asterisk (*) wildcard anywhere in the value to represent one or more characters, thereby creating a mask that matches multiple extraction maps.
Extract.captureConsumerExcludeNameList
A list of the extraction maps that match the specified schema name but that you want to
exclude
 from extraction processing. For each extraction map to exclude, enter the full extraction map name in the format
xnninstance
.
mapname
_
tablename
. Use a comma (,) separator between the values, for example: 
Extract.captureConsumerExcludeNameList=
xnninstance
.
mapname_tablename
1,
xnninstance
.
mapname_tablename
2
,...
You can include the asterisk (*) wildcard anywhere in the value to represent one or more characters, thereby creating a mask that matches multiple extraction maps.
Extract.pwxNodeLocation
Required. The node name (first positional parameter) in the NODE statement that is used to connect to the PowerExchange Listener for change data extraction. This statement is defined in the PowerExchange DBMOVER configuration file. This Listener runs on the system with the PowerExchange Logger for Linux, UNIX, and Windows log files.
No default value is provided.
Extract.pwxNodeUserId
A user ID that is authorized to access to the node that contains the PowerExchange Logger log files from which change data will be extracted. Define this property only if access to the node specified in the Extract.pwxNodeLocation property is secured by a user ID and password. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source system, this property value matches the CAPTURE_NODE_UID parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
No default value is provided.
Extract.pwxNodePwd
A clear-text or encrypted password that is associated with the user ID specified in the Extract.pwxNodeUserId property. To encrypt the password, run the PwxCDCAdmin utility with the ENCRYPT parameter. When you enter the encrypted password in this property, include the "ENC:" prefix.
Define this property only if access to the node specified in the Extract.pwxNodeLocation property is secured by a user ID and password. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source system, this property value matches the CAPTURE_NODE_PWD parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
If you use PowerExchange-encrypted passwords, specify the Extract.pwxNodeEPwd property instead.
No default value is provided.
Extract.pwxNodeEPwd
An encrypted password that is associated with the user ID specified in the Extract.pwxNodeUserId property. This password must have been encrypted by using the PowerExchange Navigator Encrypt Password facility.
Define this property only if access to the node specified in the Extract.pwxNodeLocation property is secured by a user ID and password. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source system, this property value matches the CAPTURE_NODE_EPWD parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
If you use clear-text passwords or passwords that have been encrypted by the CDC Publisher PwxCDCAdmin ENCRYPT command, specify the Extract.pwxNodePwd property instead.
No default value is provided.
Extract.pwxXmapLocation
The node name (first positional parameter) in the NODE statement that is used to connect to the PowerExchange Listener on the source system to retrieve extraction maps for source objects. This statement is defined in the local PowerExchange DBMOVER configuration file. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source machine, this property value matches the CAPTURE_NODE parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
If the data source and extraction maps are on the same node as the PowerExchange Listener and Logger, you do not need to specify this property. You can specify only the Extract.pwxNodeLocation property to connect the PowerExchange Listener that handles both requests for extraction maps and requests for change data extraction.
No default value is provided.
Extract.pwxXmapUserId
A user ID that is authorized to access the node that contains the PowerExchange extraction maps for source objects. Define this property only if access to the node specified in the Extract.pwxXmapLocation property is secured by a user ID and password. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source system, this property value matches the CAPTURE_NODE_UID parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
No default value is provided.
Extract.pwxXmapPwd
A clear-text or encrypted password that is associated with the user ID specified in the Extract.pwxXmapUserId property. To encrypt the password, run the PwxCDCAdmin utility with the ENCRYPT parameter. When you enter the encrypted password in this property, include the "ENC:" prefix.
Define this property only if access to the node specified in the Extract.pwxXmapLocation property is secured by a user ID and password. If you use remote logging of source data to PowerExchange Logger for Linux, UNIX, and Windows log files that reside off the source system, this property value matches the CAPTURE_NODE_PWD parameter value in the PowerExchange Logger configuration file, pwxccl.cfg.
No default value is provided.
The following additional properties can also be included the cdcPublisherPowerExchange.cfg file at your discretion:
Extract.pwxOffloadOption
Controls whether PowerExchange offloads some change data processing from the PowerExchange Listener system where the data resides to the CDC Publisher system. Valid values are:
  • N
    . Disable offloading processing. Typically, this value is acceptable.
  • Y
    . Enable offload processing.
Default is N.
Extract.pwxReadLatency
The maximum number of seconds that PowerExchange waits for more change data before flushing data to the PowerExchange client on the CDC Publisher machine.
Valid values are 1 through 86400. Default is 2.
Extract.pwxReturnLogInfoMessages
Controls whether the informational messages that PowerExchange returns to the CDC Publisher are written to the PwxCdcPublisher.out file in the logs subdirectory. Set this property to true to log the PowerExchange informational messages, or set this property to false to not log these informational messages. Default is false.
Extract.pwxUpdateImageOption
Indicates how UPDATEs that are read from the source are published to the CDC Publisher target. Valid values are:
  • AI
    . Process each update as a single UPDATE record that contains the after image only.
  • TU
    . Process each update as a single UPDATE record that contains both the before image and after image.
    To have the before-image values included in the generated messages to be sent to the target, you must also specify Formatter.avroIncludeBeforeImage=true in the cdcPublisherAvro.cfg configuration file.
  • BA
    . Process each update as a DELETE record that contains the before image followed by an INERT record that includes the after image.
Default is TU.
If the PowerExchange Logger for Linux, UNIX, and Windows is configured to log only after images, you must set this property to AI. Otherwise, PowerExchange issues a fatal error.
Extract.restart1
The PowerExchange sequence token value that you want to use to restart the CDC Publisher process from a specific point in the change stream. For this property value to be used, you must restart the PwxCdcPublisher process with the COLDSTART=Y or RESTART=FROM_CONFIG parameter. You must also specify the Extract.restart2 property. No default value is provided.
Extract.restart2
The PowerExchange restart token value that you want to use to restart the CDC Publisher process from a specific point in the change stream. For this property value to be used, you must restart the PwxCdcPublisher process with the COLDSTART=Y or RESTART=FROM_CONFIG parameter. You must also specify the Extract.restart1 property. No default value is provided.
0 COMMENTS
We’d like to hear from you!