Manage, enhance and control flat file data
How can Grid-Tools help to manage your flat file data?
Managing flat file data in integrated systems is one of the most complex problems a tester can face. Datamaker™ provides a complete system to help testers and developers manage these files. Existing files can be quickly used as the basis for creating new versions of the files. The newly created files can be simply updated with more current dates or can be updated to reflect down-stream application requirements.
Quite often production files are used in development to test input processes or to prepare data for testing. These files often fail validation when purchase order numbers do not match, account balances have been reset ... or many other reasons. The ability to quickly manipulate these files will save many hours spent manually editing files or writing code to adjust specific values. Now there is finally a solution to the current struggles testers face when preparing and managing flat files.
Datamaker™ can handle all types of flat file structures, including:
- Fixed definition including multi-record types
- VSAM/ISAM copybooks
- Tab or other separated
- Excel and CSV
- XML
Datamaker™ provides a variety of easy-to-use functions to manage flat files including:
- Generating synthetic flat files
- Storing flat files in a central repository for easy editing
- Mass edits of multiple files
- Subset selection of records – cut down a file easily while retaining consistency of control totals and checksums
- Full version control – if a file structure changes all of the data can quickly be upgraded
- Downstream and upstream lookup of values in interdependent applications
- Easy masking of data in files – full before and after viewing of masked data
- A vast array of data manipulation functions to edit specific columns or calculate derived values such as trailer totals
- Easy data ageing