Architecture of the iWay Log Event Adapter for Microsoft SQL Server

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. SQL Server Wrapper. A .NET application that reads source database transactions using the server-side components.
  3. Server-side Components. Stored procedures and .dll files, which allow the iWay Log Event Adapter for Microsoft SQL Server to read the SQL Server transaction logs.
  4. DOT NET Adapter. An adapter that reads the SQL Server wrapper and captures the XML for the transactions.
  5. iWay CDC SQL Batch Agent (XDCDCSQLBatchAgent). An agent that converts transactions from XML format to DML statements.

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