tRelational / DPS is a robust product set that provides modeling and data transfer of legacy Adabas data into modern RDBMS-based platforms for Internet, Intranet, and Business Intelligence applications. Treehouse Software designed this product set to meet the demands of large and complex environments requiring product maturity, productivity, feature-richness, efficiency, and high performance.

tRelational provides complete analysis, modeling, and mapping of Adabas files and data elements to target RDBMS tables and columns. DPS (Data Propagation System) performs Extract, Transformation, and Load (ETL) functions for the initial bulk RDBMS load, as well as incremental Change Data Capture (CDC) batch processing to synchronize Adabas updates with the target RDBMS.

tRelational optionally auto-generates complete RDBMS schemata from existing Adabas files, and alternatively allows easy mapping of Adabas fields to an already existing data warehouse or ERP schema. After tRelational completes the mapping, DPS can materialize (initially load) and propagate (subsequently keep synchronized) the Adabas data into the RDBMS without requiring direct access to Adabas.

For materialization (Extraction, Transformation, Load), DPS extracts Adabas data from ADASAV files and transforms it into a relational form suitable for processing by the RDBMS loader utility (for example, Oracle’s SQL*Loader).

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 (for example, Oracle’s SQL*Plus).