Adabas, Natural, migrate data from the Adabas db to relational db

, , , ,
1

I have an old computer and Adabas on Mainframe. I need to migrate all data from the Adabas database to relational.
Does anybody have an idea?

2

Assuming you need an offline process you will need to UNLOAD DECOMPRESS the files from the mainframe database, transfer it to the target system, find a reasonable mapping for the individual fields, most likely normalize the MUs and PEs and “somehow” load it into your relational database with their native toolset.

3

Look for a product called AdaMagic

James

4

Software AG has a product called ADABAS EVENT replicator and TREEHOUSE also has a product that will do this, however I suspect you do not want to purchase a product and want to do this manually. In that case you can use ADABAS utilities as Wolfgand mentioned or just write NATURAL programs to write to a work file. For MU’s and PE’s to normalize (as per Wolfgang) you will need to include two additional fields on the MU or PE records: the ISN and occurrence number. This is how you will link the Child Table to the Parent.

5

This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.