The following components must be configured inside an iWay Service Manager channel to achieve near real-time database replication on the destination database:
The following sample process flow contains the SQLCDCAdapter (Log Event Adapter), SqlTransactionLogToDML agent, transaction splitter, and iWay CDC SQL Batch Agent (Oracle_SQLAgent), which performs create/update/delete operations on the target database.
The parameters that are required by the Log Event Adapter (such as SQL server host, database name, user, password, and so on) are passed to the adapter using the cdc.config configuration file. This file is located in the following directory:
<iway_home>/etc/setup/cdc/mssqlserver/client
For more information on creating the cdc.config file, see Creating the Configuration File (cdc.config).
iWay Software |