tRelational and DPS at 5000 Feet
by Dan Sycalik
tRelational and DPS (Data Propagation System) are the two components of TSI's solution to a problem that more and more sites are facing: extracting data out of legacy ADABAS files and into RDBMS-based data stores, data warehouses, or packaged applications, and (perhaps more importantly) keeping the data in RDBMS tables synchronized with the data in ADABAS files.
I would like to provide an ADABAS data migration to RDBMS product summary from the 5000-foot level to explain how tRelational and DPS provide solutions for the following:
- Data Warehousing and Data Mart projects to provide Adhoc and OLAP reporting environments that satisfy DSS and ESS requirements. This may merge ADABAS data with other corporate data, improve customer access to valuable data, and eliminate the customer report backlog. Propagation of ADABAS data changes is a prerequisite for effective Data Warehousing.
- One-time ADABAS migrations of historical data for legacy system phase out and/or system re-engineering projects to satisfy business and regulatory data retention requirements.
- One-time or periodic migration of historical data (Archives) from large production databases to improve system performance.
tRelational
ADABAS C Data Analysis, Modeling, and Mapping: tRelational is written for and executes in the ADABAS/NATURAL environment. tRelational provides for capture and analysis of ADABAS file structures, including logical (PREDICT) and physical (FDT) definitions and resolution of discrepancies.
tRelational also provides for analysis of ADABAS data such as repeating structures (ADABAS MUs and PEs), candidate variable text (VARCHAR), and descriptor data. This analysis provides for a better understanding or confirmation of data to improve RDBMS modeling.
The Data Modeling and Mapping features provide for creation of RDBMS tables and columns with explicit ADABAS to RDMBS (field to column) mapping. The modeling and mapping task may be performed in a GUI "drag and drop" PC environment with tRelationalPC on a Windows 95/NT workstation.
Treehouse Remote Access (TRA) provides a TCP/IP protocol client/server connection to the mainframe tRelational repository. tRelational generates the RDBMS DDL to create tables, columns and constraints, and all necessary parameters for DPS.
Data Propagation System (DPS)
ADABAS C Data Extraction and Transformation: DPS is written in Assembler and executes on the mainframe in batch mode to read copies of the ADABAS data.
DPS Materialization extracts and transforms ADABAS data from an exclusive ADASAV and generates formatted sequential data and the corresponding SQL Load Utility control files (e.g., ORACLE SQL Loader or SYBASE BCP).
DPS Propagation extracts and transforms ADABAS data from the copied Protection Logs (PLOGs) and generates SQL statements (e.g., INSERT, UPDATE, and DELETE) for the target RDBMS.
The tools facilitate the fastest and most efficient implementation for migration of ADABAS data and propagation of changes. We welcome an opportunity to discuss the tRelational/DPS solution and your project needs. Please contact us at tsi@treehouse.com if you have any questions regarding our products, or if you would like an on-site installation and demonstration.
