Home
 

  What's New?

 
 
  About Us
 
 

Products
Data Migration / Replication / Integration / Products for the Mainframe
    tcACCESS
    tcVISION
    tRelational
    DPS
    DPSync
    DPS X-Link
    NatQuery
    NatCDC
    DataMirror Products
 Mainframe Emulators
    SEDIT
    S/REXX
    S/REXX Debugger
 ADABAS/NATURAL
    ADAMAGIC
    ADAREORG
    ADASTRIP
    AUDITRE
    CHART
    ESPCONTROL
    N2O - N2O/3GL
    PROFILER
    SECURITRE
    TRIM
 
 
  Customers
 
 
  Services
 
 
  Support
 
 
  Partners
 
 
  Management
 
 
  Newsletter
 
 
  Links
 
 
  International
 
 
  Evaluator Kits
 
 
  Employment
 
 
  Site Map
 
 
  Contact Us
 

DPS

Data Propagation System for ADABAS-to-RDBMS Data Transfer

tRelational and Data Propagation System (DPS) are robust products that provide modeling and data transfer of legacy ADABAS data into modern RDBMS-based platform for Internet/Intranet/Business Intelligence applications. Treehouse Software designed these products to meet the demands of large, complex environments requiring product maturity, productivity, feature-richness, efficiency and high performance.

Map it, Pump It, and Sync It

Learn More about DPS:

Download DPS Literature and Presentations below!
 

Using mapping instructions generated by tRelational, DPS materializes (initially loads) and propagates (subsequently keeps synchronized) ADABAS data into any RDBMS without requiring direct access to ADABAS.

For materialization (Extract Transformation Load), DPS extracts ADABAS data from ADASAV files and transforms it into a relational form suitable for processing by the RDBMS loader utility (e.g., Oracle's SQL*Loader utility).

For propagation (Change Data Capture), DPS extracts ADABAS data from copies of PLOG files and transforms it into a relational form suitable for processing by the RDBMS SQL processing utility (e.g., Oracle's SQL*Plus utility).

"I would strongly recommend the use of the tRelational and DPS products for any other State agencies that are currently utilizing ADABAS, especially if they need to do any migration to another platform for data warehouses."

     -Nancy Kane
      Systems & Programming DBA Manager
      Arizona DES

more data transfer success stories

Keeping ADABAS and RDBMS Data Synchronized

As applications process transactions, changes are made to the ADABAS data. Each change is recorded in a compressed form on the ADABAS Protection Log, so that the database can be recovered in an emergency. DPS reads a copy of the Protection Log, extracts the relevant changes to the ADABAS data, and transforms those changes into SQL "UPDATE", "INSERT", and "DELETE" statements for processing by the RDBMS.

DPS Features

Extracts materialization (Extract Transformation Load) data from existing ADASAV backups and propagation (Change Data Capture) data from existing ADABAS Protection Log (PLOG) copies, resulting in NO impact on ADABAS applications

  • Processes compressed ADASAV and PLOG images for maximum throughput
  • Ensures transaction integrity with ADABAS End Transaction (ET) PLOG entries
  • Optionally uses Treehouse Software's ADABAS PLOG Consolidation utility (APC) to produce a file of compressed PLOG images
  • Extracts logical file “subsets” out of physical ADABAS files for materialization and propagation
  • Incorporates special transformation and data cleansing logic through use of “External Transformation Routines”

"tRelational and DPS are the tools that allowed us to reach our goals in a pragmatic and non-invasive way."

     -Roberto Licandro
      IT Architectures
      B-Source SA

more success stories

Compatibility

DPS runs in MVS, VSE, and BS2000. DPS is an open solution that can support all popular RDBMS products. DPS currently has built in support for Microsoft SQL Server, ORACLE, Sybase, IBM's DB2. and NCR Teradata.

DPS and tRelational Interactive Web Site

Visit the tRelational/DPS section of the Treehouse Software Web site devoted to our ADABAS-to-RDBMS solution. You can view Flash demonstrations of ADABAS File Implementation, ADABAS Data Analysis, Auto Generation of Normalized Tables for an ADABAS File, Output Generation, Data Propagation System (DPS) - Materialization, Data Propagation System (DPS) - Propagation, and much more.

Designing DPS

View "behind-the-scenes" design documents that show the design methodology generally employed for DPS.

.

DPS and tRelational Literature and Presentations:

DPS FactSheet (English)
DPS FactSheet (German)

tRelational FactSheet (English)
tRelational FactSheet (German)

tRelational/DPS Product Overview

tRelational/DPS Getting Started Guide

tRelational/DPS Presentation

Contact Treehouse Software Today!

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

TSI is looking for reference sites for the DPS software. If you are interested in becoming a DPS 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.