DPSync by Treehouse Software is an off-the-shelf solution enabling real-time, native transformation and propagation of ADABAS mainframe database transactions to relational database management systems (RDBMS). It delivers immediate access to updated ADABAS data in RDBMS environments while minimizing performance impact on the source system. DPSync includes all necessary tools for data analysis, RDBMS modeling, transformation process definition, metadata generation, extraction, transformation, loading, and real-time update application. The architecture is designed to avoid the need for additional middleware and supports flexible deployment across distributed environments.

Key Features

Real-Time Change Data Capture Captures and propagates ADABAS transaction changes as they occur.

• Immediate access to updated data in RDBMS.
• No waiting for batch cycles or PLOG switches.

Comprehensive ETL and Transformation Supports full extract, transform, and load (ETL) for initial and ongoing data synchronization.

• Data analysis and mapping from ADABAS to RDBMS.
• Metadata generation and schema modeling.

Minimal Production Impact Operates using ADABAS protection logs (PLOG) without direct calls to ADABAS.

• Reduces CPU and I/O overhead on production systems.
• Processes only committed transactions, ensuring data integrity.

Integrated Architecture Includes all required components for end-to-end replication.

• No need for separate, external middleware.
• Components for analysis, transformation, queueing, and SQL application.

High Reliability and Fault Tolerance Utilizes proven, fault-tolerant queueing and capture technology.

• Guaranteed data delivery and integrity.
• Mature components with a long track record.

Flexible Target Support Supports multiple RDBMS platforms and targets.

• Can output to SQL, XML, JMS, or flat files (with DPSync EC).
• Supports distributed and remote deployment.

Benefits

Up-to-Date Decision Making Ensures business users and applications have the latest data.

• Supports real-time analytics and reporting.
• Enables timely customer and operational insights.

Operational Efficiency Reduces manual integration and custom programming.

• Streamlines data replication and transformation processes.
• Minimizes system resource consumption and operational costs.

Data Integrity and Reliability Processes only committed and correctly sequenced transactions.

• Avoids data loss and duplication.
• Maintains consistency between ADABAS and RDBMS environments.