The PowerExchange CDC Publisher must be able to connect to the system where the PowerExchange Logger for Linux, UNIX, and Windows log files reside and to the system with the source extraction maps. To configure connectivity to PowerExchange, you must specify certain PowerExchange dbmover statements and CDC Publisher properties.
DBMOVER Configuration Statements
If the CDC Publisher and PowerExchange Logger are on the same system, they can share the same local PowerExchange dbmover configuration file.
If the CDC Publisher is remote from the PowerExchange Logger or source system, you must create a dbmover configuration file on the CDC Publisher system. In this dbmover configuration file, configure one or both of the following connectivity statements:
If the CDC Publisher system is remote from the PowerExchange Logger system, define a NODE statement that points to the PowerExchange Logger host system.
If the CDC Publisher is remote from the source system where the extraction maps reside, define a NODE statement that points to the source host with the extraction maps.
Also ensure that the PWX_CONFIG environment variable points to the local dbmover configuration file on the CDC Publisher system.
For more information about the NODE statement, see the
PowerExchange Reference Manual
.
CDC Publisher Configuration Properties
In the cdcPublisherPowerExchange.cfg file on the CDC Publisher system, specify the following properties:
If the location of the extraction maps is different from the Extract.pwxNodeLocation location from which change data will be extracted, specify the Extract.pwxXmapLocation property. In this property, specify the node name from the NODE statement that points to the location of the extraction maps. If a user ID and password are required to access this node, also specify the Extract.pwxXmapUserId and Extract.pwxXmapPwd properties.
In the Extract.pwxNodeLocation property, specify the node name from the NODE statement that points to the PowerExchange Listener on the system from which change data will be extracted. If a user ID and password are required to access this node, also specify the Extract.pwxNodeUserId property and the Extract.pwxNodePwd or Extract.pwxNodeEPwd property.
In the Extract.pwxCapiConnectionName property, specify the NAME value from the CAPX CAPI_CONNECTION statement that is in the dbmover configuration file on the PowerExchange Logger system. This statement is used to continuously extract change data from PowerExchange Logger log files.