The following components must be configured inside an iWay Service Manager channel to achieve near real-time database replication on the destination database:

1. Schedule Listener. A listener that is configured to run every 60 seconds. This makes the process run in a loop for every 60 seconds.
2. DOT NET Adapter. Points to the location of the wrapper that uses the DOT NET adapter and calls the server-side API, which then receives the data from SQL Server logs for processing.
3. iWay CDC SQL Batch Agent (XDCDCSQLBatchAgent). An agent that interacts with the target Oracle database and performs the DML operation.

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 a configuration file (cdc.config) as shown below. This file must be placed in the same directory where the iwsqlcdc.dll file is located, so that it can be read during adapter run time.

For more information on creating the cdc.config file, see Creating the Configuration File (cdc.config).