tRelational/DPS is a software suite that facilitates the migration and synchronization of legacy Adabas database data to relational database management systems (RDBMS). It provides comprehensive modeling, mapping, and ETL (Extract, Transform, Load) capabilities, allowing organizations to transfer and integrate Adabas data into modern data environments for business intelligence, internet, and intranet applications. The solution supports both initial bulk data loads and ongoing change data capture (CDC) to keep RDBMS targets synchronized with Adabas sources, without requiring direct access to the original Adabas system.

Key Features

Adabas-to-RDBMS Modeling and Mapping Mapping and modeling of Adabas data structures to RDBMS schemas.

• Complete analysis and mapping of Adabas files and elements to RDBMS tables and columns.
• Optional auto-generation of RDBMS schema (tables, columns, keys) from Adabas file structures.
• Tools to analyze and determine optimal mapping for Adabas field types and keys.

ETL and Change Data Capture Automated data extraction, transformation, and loading, plus incremental updates.

• Initial bulk data load from Adabas to RDBMS using ETL processes.
• Incremental batch processing for ongoing synchronization via CDC.
• Extraction from Adabas ADASAV and PLOG files and transformation for RDBMS loaders.

Flexible Schema Integration Supports both new and existing RDBMS schemas.

• Auto-generates new RDBMS schema or maps to existing data warehouse/ERP schema.
• ODBC Import function for easy schema import and drag-and-drop mapping.

Graphical User Interface User-friendly modeling and mapping.

• tRelationalPC GUI for interactive modeling and mapping tasks.
• Drag-and-drop procedures for mapping Adabas to RDBMS.

Benefits

Modernization of Legacy Data Enables integration of legacy Adabas data into contemporary environments.

• Facilitates business intelligence, analytics, and application modernization.
• Reduces dependency on legacy systems by enabling data migration.

Efficiency and Productivity Streamlines complex data migration and synchronization tasks.

• Automates schema generation and mapping, minimizing manual effort.
• Supports large and complex environments with high performance and reliability.