Syncing with a Relational Database
The following diagram illustrates the Adabas Event Replicator for LUW architecture.
In the diagram, the Adabas Event Replicator for LUW components are spread across three different servers, which is the recommended configuration. You can also install all components on a single Windows server (because the Replication Administrator must reside on Windows), or on two servers (the Replication Administrator must reside on Windows, the other components can reside on Windows, Linux or Unix servers).
Adabas Event Replicator for LUW consists of the following components:

Component | Description
Adabas for Open Systems | The Adabas Event Replicator for LUW real-time change data capture capability is only available in Adabas for Open Systems, and requires a special Adabas replication license. Contact Software AG for more information about obtaining the Adabas Event Replicator for LUW license.
Replication Administrator | The Adabas Event Replicator for LUW graphical user interface is written in C#.NET and can only run in a Windows environment. Using the Replication Administrator, you can define new replications in less than a minute.
Event Producer (EP) | The Event Producer is a DLL (shared library) that is loaded by the Adabas nucleus. Every time a change is made to an Adabas database, the EP is notified of the change in real time. Transactions are grouped together and placed on the Message Queue, to be picked up by the Event Consumer.
Message Queue (CNXMQ) | The CONNX Message Queue stores messages so the system can recover if communication is lost between components. If the Event Consumer or Controller components shut down for any reason (such as power outages or system reboots), the Message Queue ensures full recoverability when the components are brought back online again. Until the components are available, the EP persistently stores Adabas transactions that affect data content in the message queue for future retrieval.
Controller | The Controller manages starting and stopping the Event Consumer. It also distributes the replication plan deployed by the Replication Administrator to the EP and the Event Consumer.
Event Consumer (EC) | The Event Consumer is the heart of event replication. The EC reads the transactions placed on the Message Queue by the EP, and, using the appropriate CONNX SQL Engine Adapter, recreates the transaction on the target database.
CONNX SQL Engine | The EC uses the CONNX SQL Engine to perform "initial states." An "initial state" moves all the data from a source Adabas file to a target table for the first time. Initial states can also be automatically initiated by Adabas Event Replicator for LUW if an unrecoverable error occurs such as the Adabas database shutting down improperly.
Designer Data Dictionary | The CONNX SQL Engine Adabas Event Replicator for LUW Designer requires a data dictionary containing the Adabas files' SQL based definitions.
CONNX SQL Engine Target Adapter | In addition to the CONNX SQL Engine, Adabas Event Replicator for LUW requires adapters for the target databases. The CONNX SQL Engine has target adapters for Oracle, SQL Server, DB2, Sybase, and Informix.