DPSync

Real-Time Propagation of ADABAS Transactions

DPSync delivers critical information stored in ADABAS to relational databases in real time, providing immediate access to ADABAS data updates without impacting ADABAS performance.

DPSync with tRelational/DPS was recently 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.

 

In today’s environment, critical business decisions must be based on up-to-date information. Whether it is management reporting or customer purchase/status information, your decision-makers need the most current information available. A solution that requires extensive custom programming to get desired information or one that slows down your production applications is not acceptable. Robust and mature components are required. Treehouse Software's DPSync is an off-the-shelf, total solution for native, real-time transformation and propagation of ADABAS data to RDBMSs that is fast, comprehensive, and minimizes the impact on production applications.

DPSync incorporates patented, mature, and supremely fault-tolerant capture and queueing technology from E-Net Corporation, vendor of the leading product for software-based disaster recovery, Remote Recovery Data Facility (RRDF). This helps assure DPSync customers that no data will be lost--ever. DPSync also incorporates as components tRelational and DPS, the leading ADABAS-to-RDBMS data transfer toolset since the mid-1990s.

DPSync provides all of the tools for analyzing ADABAS data, defining the RDBMS, defining the transformation process, generating the metadata for transformation, extracting, transforming, and loading the RDBMS tables, and transforming and applying the updates in real-time mode.

Unlike other solutions, DPSync customers are not obliged to acquire a separate, non-integrated message-oriented middleware product in order to complete the architecture.

  1. tRelational - ADABAS analysis, RDBMS modeling, and metadata management
  2. DPS - ADABAS-to-RDBMS transformation
  3. RRDF - Real-time ADABAS transaction capture and queueing
  4. RSU - Application of the generated SQL to the RDBMS
  5. DPS/R - Routing of ADABAS transactions from RRDF to DPS subtasks and routing of SQL to RSU

How does DPSync 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.

 

"As agencies have greater needs to share information, they will not always have the ability to replace a legacy system such as CJIS... This project demonstrates that it is not always necessary. DPSync allows us to take a big step forward without replacing CJIS”

     - Albert Locher
       Assistant Chief in the District Attorney’s Office / IJIS co-chair

 
     

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.

 

"DPSync is one more of the puzzle pieces that we have put in place to make our CJIS data more easily available to our end users.”

     -Brian Richards
      Project Manager
      County of Sacramento

 
     

Reliability of the data is ensured

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 Literature:

DPSync Product Overview
DPSync FactSheet (English)
DPSync FactSheet (German)

DPSync Presentation
County of Sacramento DPSync Case Study Presentation
by Brian Richards, Project Manager at the County of Sacramento


Contact Treehouse Software Today!

To receive more information about DPSync, or to request a free 30-day trial, contact Treehouse Software or your Treehouse affiliate.

TSI is looking for reference sites for our ADABAS-to-RDBMS data transfer software. If you are interested in becoming a reference site in exchange for special pricing and other considerations, contact TSI today!

TREEHOUSE SOFTWARE, INC.
409 Broad Street, Suite 140
Sewickley, PA 15143

Phone: (412) 741-1677
Fax: (412) 741-7245
Email: sales@treehouse.com


What's New | Products | Services | About Us | Newsletter | Management | Partners | Support
International | Employment | Evaluator Kits | Links | Site Map | Contact TSI | Home

Copyright © 2008 Treehouse Software, Inc.