Home    Blog   White Papers   Contact Us
How DPSync Works | Ensuring Data Reliability | Treehouse Software

Quick Product Links

Data Integration, Replication, and Migration

Application Modernization and Portfolio Management


Product Resources


DPSync: How Does It Work?

When ADABAS processes transactions from application programs, the updates are applied to the database, and Before and After Images of the records are written to a protection log (PLOG). DPSync acquires the PLOG data in real time as the images are written. It then transmits the data in real time to local or remote locations. By using PLOG data already being written by ADABAS through its normal housekeeping, DPSync does not affect the performance of the production ADABAS system. Transaction information is captured and propagated as it occurs, without waiting for a PLOG switch and copy, keeping critical information current.

DPSync offers high-speed processing of ADABAS data with minimal performance overhead. By using static ADABAS data sources for ETL (materialization/initial loading) and CDC (propagation/ongoing synchronization), instead of making direct calls to ADABAS, DPSync provides optimal system performance and reduces the impact on other critical production applications. And with DPSync, only committed ADABAS changes are processed. Other solutions relying on direct interaction with ADABAS may compromise ADABAS application performance and stability through "extended holding" of updates during replication, and may compromise data integrity by utilizing ADABAS "dirty read" processing when extracting data for initial loading.

DPSync provides extensive analysis, modeling and mapping capabilities using an intuitive graphical user interface. Options are supplied to auto-generate complete RDBMS schemata from existing ADABAS files, or alternatively to allow easy mapping of ADABAS fields to an already-existing data warehouse or ERP schema. Rich transformational capabilities are provided to support complex application requirements.

DPSync can be configured for a single or distributed system environment. Capture, queueing, transformation, and RDBMS-updating components can exist within the same MVS-OS/390-z/OS image or in separate systems–even those in different geographic locations. DPSync is adaptable to your environment.

Ensuring Data Reliability

DPSync's mature and robust spill and gap recovery processing provides reliability, scalability, and fault tolerance. If a PLOG transmission is interrupted or the destination database cannot process changes for any reason, updates are automatically buffered first in memory and then in disk spill files. When communication is restored to normal, DPSync automatically transmits the spill file data in parallel with acquiring and transmitting newly-generated transactions from ADABAS. During remote site outages or software/hardware failures, DPSync automatically retrieves and properly sequences any lost data (gaps) from ADABAS PLOG archives, once again in parallel with acquisition of new updates. DPSync's highly-parallelized, guaranteed-recovery architecture ensures arrival of the transformed data at the target, while ensuring the integrity of the complete transaction -- only committed data, correctly sequenced, and without duplication.

After transforming ADABAS transactions into the corresponding native SQL statements, DPSync's RSU component applies the statements to the target tables, ensuring successful execution and responding automatically to exception conditions.

The DPSync Console allows operators to monitor status and throughput statistics, issue commands to DPSync components, and define scripts for response to exceptions.

Additional Capabilities

DPSync's RRDF component, which as a standalone product has led the market since the late 1980s, also provides comprehensive, proven, and multi-DBMS functionality for data replication and disaster recovery. RRDF addresses both recovery time and recovery point requirements. Using RRDF, a database can be recovered right up to the point of a disaster. RRDF uses real-time log capture and sophisticated buffering and queuing technology to achieve remote site recovery and homogeneous replication objectives without affecting production system performance and availability. In addition to ADABAS, RRDF supports many other mainframe data sources, including DB2, IMS, IDMS and CICS/VSAM.



DPSync Fact Sheet

DPS Fact Sheet

tRelational Fact Sheet

tRelational/DPS Product Overview


Free White Paper

Data Modernization as the
Gateway to Legacy Modernization

By Wayne Lashley,
Treehouse Software, Inc.


Success Story

DPSync with tRelational/DPS was chosen by Dexia Banque Internationale Ă  Luxembourg over its principal competitors.

Established in 1856, Dexia BIL is a pre-eminent European institution in the fields of retail banking, private banking, trading on financial markets, asset management, and fund administration. The Dexia BIL team members analyzed the options and made their decision based on a matrix of their needs. tRelational/DPS impressed everyone with its RDBMS data model generation capabilities, product maturity, stability, replication to different targets (like Oracle, Sybase, and flat files), graphical user interface, quality of support and responsiveness to questions, ease of installation, and no impact on ADABAS nuclei.

Products | Services | Partners | About Us | Support | Contact Us | Request a Demo | Home | © 2017 Treehouse Software, Inc.