Integration with the PowerExchange CDC environment
You must have a functional on-premises PowerExchange environment that can connect to a Db2 for z/OS database.
You must have a license that allows your organization to use the Db2 for z/OS Bulk Load Connector and PowerExchangeClient packages. On each system from which you plan to use Db2 for z/OS Bulk Load Connector, install the Secure Agent. After you start the Secure Agent the first time, the Db2 for z/OS Bulk Load Connector and PowerExchangeClient package are installed locally. You then can use Cloud Data Integration, Administrator, and Monitor interfaces to configure Db2 for z/OS Bulk Load connections, mappings, and mapping tasks and to run and monitor mapping tasks.
The following image shows the general architecture of the Db2 for z/OS Bulk Load Connector components in relation to Cloud Data Integration and the remote Db2 for z/OS Bulk Load source system:
This configuration spans the following on-premises systems:
•The z/OS system where the Db2 tables and PowerExchange Listener run.
•The system where the Db2 for z/OS Bulk Load Connector components and Secure Agent run.
Based on this configuration, the following processing occurs:
1PowerExchange writes to Db2 for z/OS bulk load data sets where the PowerExchange Listener for z/OS resides.
2When you design a mapping in Data Integration, you associate the target transformation with a Db2 for z/OS Bulk Load connection. You can define the connection in either Data Integration or Administrator. The PWX Bulk Metadata Adapter then uses the connection to connect to the PowerExchange Listener on z/OS and read from the Db2 tables to fetch the metadata.
In the mapping, you must also define a Source transformation and connection and map the source fields to target fields.
3The Secure Agent in conjunction with Data Integration sends the Db2 metadata to the Informatica Intelligent Cloud Services repository in the cloud.
4When you run the mapping task that is associated with the mapping, all of the metadata, connection properties, mapping information, advanced source properties, runtime properties, and advanced session properties are pushed down to the on-premises Secure Agent in the form of a session .xml file.
5The PWX Bulk Writer on the Secure Agent machine communicates with the PowerExchange Listener on the z/OS machine to move bulk data through to the PowerExchange Listener.