Product Overview

When migrating applications from one platform to another, it is often the case that a process of Extra, Transform and Load (ETL) is undertaken to take advantage of new features. This usually involves the extraction of existing data from the As-Is system, transforming it to structures in flat files that are compatible to the To-Be system and then performing the loading of the data in those files into the new system.

Proteros Data System’s Frurion™ product suite provides a number of tools that are used to prepare test data and create the flat files that are required when testing an ETL process or migration. The Frurion™ Data File Generator is used to create test data to any flat-file definition, and can be used in conjunction with the Frurion™ Excel Interface to create test data in Excel that is then used to populate the file structures.

Technical Details

Although initially created to test ETL migration processes the same tools have also been found to be useful when testing mainframe COBOL or PL/1 applications.Mainframe COBOL applications still form core or major parts of large organisation’s IT infrastructure and comprise huge investments to support often business-critical applications. And although they are seen as legacy systems they are continually being developed and enhanced with new functions.Testing these applications, which are predominately batch file systems, is simplified with the file generator tools in the Frurion™ Product suite. Mainframe files can be generated from data held in Excel and then uploaded to the mainframe for processing. From extract to upload, the whole process an be automated, leaving the test analyst to concentrate on creating meaningful test data not the mechanics of how to create a file correctly or how to get it to the mainframe.

Additional Information

Utilising the Frurion™ internal XML structures in conjunction with the Frurion™ data dictionary, it is possible to create test data file that can be used in a host of processing systems and the whole process can be automated to run unattended.