ADABAS NATURAL
ADABAS Migration
TSG Software has a great deal of experience helping clients migrate from legacy database platforms to modern RDBMS platforms.
We can offer a proven automated migration for ADABAS databases to any of the major RDBMS (IBM DB2, Oracle, Microsoft SQL Server) either on or off the mainframe platform. The new database will provide a complete replacement for all ADABAS database functionality. Alongside this migration all Natural programs can be converted to CICS Cobol or C# .NET and application code written in other languages converted to access the new database.
Database Definition
Based on the characteristics and functionality of the original ADABAS database, TSG provides a functionally complete fully relational replacement. The DDL to create this new database is generated by the TSG conversion routines, automatically creating all required primary keys, foreign keys, index definitions and constraints.
Data Conversion
Fast and efficient Cobol routines are provided to unload the ADABAS data to the correct format for relational database load utility and the customised JCL to run these.
Other optional deliverables are control cards for the relational database data LOAD process, control cards for RI checking, control cards for RUNSTATS processing and DCLGEN control cards for the generation of Cobol layouts of the tables.
Customisation
Due to the automated nature of the migration, it is possible to tailor the deliverables to match the customer requirements.
Table, column, table space and index names can be customised to reflect site naming standards, rules based data cleansing can be built into the data extract routines and date fields can be manipulated to allow use of relational DATE data type. In addition several options to customise the data definitions are available.
Documentation
Since a complete understanding of the ADABAS database and how the relational database relates to it is key a wealth of documentation is produced as part of the migration process. This documentation is invaluable to both the customer and TSG and includes complete Entity Relationship Model (ERM) diagrams for the relational databases, matrices relating records to tables, elements to columns, ADABAS files to extract programs, etc in addition to many other standard and ad-hoc reports
Natural Conversion
Natural applications are converted to efficient and functionally equivalent CICS/Cobol or C# .NET using an automated process. The resulting C# and COBOL applications are multi-tiered, made up of User Interface, Business Logic and full-feature SQL-based Data Access layers.
All Natural components are converted including programs and subprograms, subroutines, maps, and local, global and parameter data area definitions. All ADABAS database access is converted to process against the new relational database. Due to the automated nature of the process, a large degree of customisation is possible.
Natural Utilities
Replacements for the utilities Natural utilities such as Entire Operations, Entire System Server, EntireX, Natural Construct, Natural Security, and Com-plete are available as part of the TSG migration.
Application code written in other languages can easily be converted to access the new database.