PostgreSQL CDC Connector > Introduction to PostgreSQL CDC Connector > Integration with the PowerExchange CDC environment
  

Integration with the PowerExchange CDC environment

You must have a functional on-premises PowerExchange CDC environment that can capture change records from PostgreSQL source tables and log them to PowerExchange Logger for Linux, UNIX, and Windows log files. Also, you must have a license that allows your organization to use the PostgreSQL CDC Connector and PowerExchangeClient packages on a Linux or Windows system.
On each system from which you plan to use PostgreSQL CDC Connector, you must install the Secure Agent. After you start the Secure Agent the first time, the PostgreSQL CDC Connector and PowerExchangeClient components are installed locally. You then can use the Cloud Data Integration, Administrator, and Monitor interfaces to configure PostgreSQL CDC connections, mappings, and mapping tasks and to run and monitor mapping tasks.
The following image shows the general architecture of the PostgreSQL CDC Connector components with Cloud Data Integration and a remote PowerExchange CDC and PostgreSQL source system:
In this configuration, the PowerExchange change capture process, PowerExchange Logger, and PostgreSQL source reside on one Linux, UNIX, or Windows system and the PostgreSQL CDC Connector components reside on another Linux or Windows system. The PowerExchange Navigator runs on a Windows system apart from both environments. Based on this image, the following processing occurs:
  1. 1PowerExchange reads change events, including data changes, from the PostgreSQL replication store table. PowerExchange captures change records for registered source tables and sends the change records to the PowerExchange Logger on a continuous basis.
    2. To capture change records, the PowerExchange capture process uses the capture registrations that are recorded in the PowerExchange CCT file. You defined a capture registration for each PostgreSQL source table in the PowerExchange Navigator. The PowerExchange Navigator generated a corresponding extraction map, which will be used to extract the change records.
  2. 2The PowerExchange Logger logs the change records in its log files.
    3. The pwxccl.cfg file defines the PowerExchange Logger configuration.
  3. 3When you design a mapping in Data Integration, you associate the Source transformation with a PostgreSQL CDC connection. You can define the connection in either Data Integration or Administrator. The PWX CDC Metadata Adapter then uses the PostgreSQL CDC connection to connect to the PowerExchange Listener and retrieve extraction-map metadata for the PostgreSQL source from the PowerExchange CAMAPS file.
    4. In the mapping, you must also define a Target transformation and connection and also map the source fields to target fields.
  4. 4The Secure Agent in conjunction with Data Integration sends the extraction-map metadata to the Informatica Intelligent Cloud Services repository in the cloud.
  5. 5When you run the mapping task that is associated with the mapping, all of the CDC metadata, connection properties, mapping information, advanced source properties, CDC runtime properties, and advanced session properties are pushed down to the on-premises Secure Agent in the form of a session .xml file.
  6. 6The PWX CDC Reader on the Secure Agent machine communicates with the PowerExchange Listener to retrieve the change records from PowerExchange Logger log files.
  7. 7Data Integration transmits the change records to the mapped target.
Alternative configurations of PowerExchange with PostgreSQL CDC Connector components and Cloud Data Integration are possible. For example: