Migration VSAM files to SQL Database

In the present day, data is everything. From use of data-mining applications for recognizing patterns in data, legislative reasons such as open government, to the rise of IoT, there is a move to make data more accessible. Opening up VSAM data on a mainframe is not as easy. Traditionally, opening up mainframe data involved a manual redesign of the system to replace VSAM APIs with embedded SQL statements. This can be a long and laborious exercise.

Moving to cloud

Once the application has been migrated to a Java or C#, and once data has been ported to SQL database, the system can be ported to the cloud via IBM BlueMix, Microsoft Azure, private cloud or other cloud solutions.

SoftwareMining's translation to Java/C# can achieve this automatically:

• SQL schema is generated via the structures defined in FILE-DEFINITION or WORKING-STORAGE sections of the code
• VSAM's READ/WRITE statements are translated to an Object-Relational layer, which would AUTOMATICALLY and dynamically generate the required SQL to communicate with the database
• Data Migration utilities support EBCDIC to ASCII migration and GDG.

VSAM to SQL migration is an in-built feature of SoftwareMining's COBOL to Java translation, improving the overall value of the modernization project.

  © 2022 SoftwareMining is a trademark of Software Modernization Technologies Ltd (UK). Registered in England company no: 07300248. Reg Offices: 79 Stevens House, Jerome Place, Kingston Upon Thames, KT1 1HX, United Kingdom.