Home    Blog   White Papers   Contact Us
 
ADABAS-to-RDBMS | ADABAS Data Migration | Treehouse Software



Quick Product Links


Data Integration, Replication, and Migration


Application Modernization and Portfolio Management


Legacy


Product Resources

 

ADABAS-to-RDBMS Data Migration and Change Data Capture

tRelational and Data Propagation System (DPS)

tRelational and DPS are robust products that provide modeling and data transfer of legacy ADABAS data into modern RDBMS-based platforms 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.

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

Map it and Pump It

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 does the mapping, DPS can then 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 (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).

ADABAS-to-RDBMS Modeling and Mapping

  • RDBMS data modeling and mapping of ADABAS structures to RDBMS structures
  • Optional auto-generation of complete RDBMS schemata (Tables, Columns, Primary Key, and Foreign Keys) based upon existing ADABAS file structures. ADABAS Periodic Groups and Multiple Value Fields may be mapped as child tables or as discrete columns (or both) in the generated RDBMS data model.
  • Generation of DDL statements to create RDBMS structures in the target relational database.
  • Analysis tools for (1) determining which alphanumeric ADABAS fields should be mapped to "VARCHAR" RDBMS columns, (2) analyzing which ADABAS descriptors are candidates for an RDBMS primary key or alternate index, and (3) analyzing the physical characteristics of ADABAS PE and MU fields to determine the kind of RDBMS structures to which they should be mapped.
  • tRelationalPC GUI interface for modeling and mapping.
  • tRelational produces all parameters required by DPS to perform materialization (initial loading) and propagation (ongoing synchronization) of data from ADABAS to the RDBMS.
  • The "ODBC Import" function makes it even easier for a site to import existing RDBMS schema into tRelationalPC (no need to type in those Tables, Columns, and Constraints manually). A simple drag-and-drop procedure is then all that is required for the creation of ADABAS-to-RDBMS mappings.
 

Downloads

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.


 

Compatibility & Requirements

tRelational is available for mainframe Adabas/Natural sites. Supported target RDBMSs include Oracle, Microsoft SQL Server, Sybase, DB2 (mainframe and LUW) and Teradata.

tRelational operates under z/OS, z/VSE and BS2000.

The tRelationalPC component runs on Windows XP/7.

DPS runs in z/OS and z/VSE. An open solution that can support all popular RDBMS products, DPS has built-in support for Microsoft SQL Server, Oracle Database, Sybase Adaptive Server, IBM DB2 (mainframe and LUW). and Teradata.


 

 


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