You must have a functional on-premises PowerExchange environment that can replicate data from Db2 source tables on an IBM i system and transmit the data to a supported target.
You must have a license that allows your organization to use the Db2 for i Connector and PowerExchange Client packages on a Linux or Windows system. On each system from which you plan to use Db2 for i Connector, install the Secure Agent. After you start the Secure Agent the first time, the Db2 for i Connector and PowerExchange Client package are installed locally. You then can use Cloud Data Integration, Administrator, and Monitor interfaces to configure Db2 for i connections, mappings, and mapping tasks and to run and monitor mapping tasks.
The following image shows the general architecture of the Db2 for i Connector components in relation to Cloud Data Integration, the remote Db2 for i source system:
This configuration spans the following on-premises systems:
•The IBM i system where the Db2 for i database and PowerExchange Listener run.
•The system where the Db2 for i Connector components and Secure Agent run.
Based on this configuration, the following processing occurs:
1PowerExchange reads from and writes to Db2 tables where the PowerExchange Listener for IBM i resides.
2When you design a mapping in Data Integration, you associate the Source transformation with a Db2 for i 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 IBM i and and read from and write to Db2 tables.
In the mapping, you must also define a Target 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 or mapping task, 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 Reader and Writer on the Secure Agent machine communicates with the PowerExchange Listener on the IBM i machine to move bulk data from the source tables.
6Data Integration transmits the records to the mapped target.
