CONNX Data Integration Suite 14.7.0 | InstantdbSync for Adabas | Introduction | Syncing with a Relational Database
 
Syncing with a Relational Database
The following diagram illustrates the InstantdbSync architecture.
You have the InstantdbSync Designer comprised of an InstantdbSync 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 InstantdbSync Server. The Adabas for Open Systems has an Event Producer that takes information from all the necessarry DBIDs and communicates it two-way with the Message Queue. The InstantdbSync Server has a controller and an event consumer, which use the SQL Gateway target Adaptor and a Replication Data Dictionary to apply the changes to a target database.
In the diagram, the InstantdbSync 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).
InstantdbSync consists of the following components:
Component
Description
Adabas v6.1 (or above) for Open Systems
The InstantdbSync real-time change data capture capability is only available in Adabas for Open Systems version 6.1 and above, and requires a special Adabas replication license. Contact Software AG for more information about obtaining the InstantdbSync license.
Replication Administrator
The InstantdbSync 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 Adaptor, recreates the transaction on the target database.
CONNX SQL Engine
The EC uses the CONNXX 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 InstantdbSync if an unrecoverable error occurs such as the Adabas database shutting down improperly.
Designer Data Dictionary
The CONNX SQL Engine InstantdbSync Designer requires a data dictionary containing the Adabas files' SQL based definitions.
CONNX SQL Engine Target Adaptor
In addition to the CONNX SQL Engine, InstantdbSync requires adaptors for the target databases. The CONNX SQL Engine has target adaptors for Oracle, SQL Server, DB2, Sybase, and Informix.