NatCDCSP: The NATURAL Change Data Capture Answer for Adabas
As Adabas handles Store, Update or Delete transactions that occur against files, the specific details of each transaction can be optionally recorded in a sequential file called the Adabas Protection Log (PLOG).
While the primary purpose of the PLOG is for use as a data recovery mechanism in the case of a system failure affecting Adabas, the data contained in the PLOG is ideal for use as a source in providing Change Data Capture (CDC) from Adabas. The problem is that PLOG data must be carefully processed in order to convert it into a usable format.
Fortunately, Software AG delivers utility programs with Adabas that are specifically designed to work with PLOG data. Unfortunately, these existing utilities fall very short of providing a complete answer for delivering PLOG data into a usable format. Many organizations requiring CDC from Adabas have hand-written custom processing to leverage these existing PLOG utilities. This hand-written approach, however, does not lend itself to the rapid delivery of needed CDC. Furthermore, once these custom CDC processes are written, they become in-house applications that must be maintained if file layouts change (which they often do), and/or the requirements of CDC changes (which they always do).
NatCDC is the Natural answer that leverages the PLOG utilities Software AG provided with Adabas, and provides for the graphical generation of Natural programs to handle the output of these utilities to produce usable CDC from Adabas.
This approach results in a low-cost, high-performance CDC solution that utilizes the raw horsepower already present in a Software AG environment, and which generates or regenerates complete, ready-to-execute replication processing in minutes.
General List of Features
All generation is accomplished from a full GUI
Optionally delivers either "Optimistic" or "Committed" transactions
Optionally delivers Delta images, Logical First and Last images, or All images
Converts all Adabas data from EBCDIC to ASCII, and properly handles difficult datatypes like Adabas Date and Timestamp fields
Optionally generates files that describe the layout of the final delivered data so that the data can be immediately integrated into ETL tools such as IBM's DataStage Suite
Optionally generates an Offset Report for manual integration with desired targets
Integrates with server through automated FTP
Delivers output in fixed-length format with the capability to easily drop non-required fields
Provides full reporting on all transactions processed
2605 Nicholson Road, Suite 1230
Sewickley, PA 15143
Normal business hours are
Monday - Friday,
8:30 AM - 5:00 PM
Eastern Time USA
If you have a critical support issue after hours that requires immediate assistance, please contact us via our after-hours service by calling (412) 324-1525.