CONNX Data Integration Suite 14.8.0 | Adabas Event Replicator for LUW | Introduction | Syncing with a Relational Database
 
Syncing with a Relational Database
The following diagram illustrates the Adabas Event Replicator for LUW architecture.
You have the Adabas Event Replicator for LUW Designer comprised of an Adabas Event Replicator for LUW Administrator with the Adabas SQL Gateway and Designer Data dictionary, all on Windows. Everything on the Windows platform connects to Adabas for Open systems and an Adabas Event Replicator for LUW Server. The Adabas for Open Systems has an Event Producer that takes information from all the necessary DBIDs and communicates it two-way with the Message Queue. The Adabas Event Replicator for LUW Server has a controller and an event consumer, which use the SQL Gateway target adapter and a Replication Data Dictionary to apply the changes to a target database.
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.