Managing 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 as purchase orders numbers do not match, account balances have been reset or many other reasons. Being able to quickly manipulate these files will save many hours spent manually editing the files or writing code to adjust specific values.
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
Features and benefits of Grid-Tools flat file management
- Easy data masking for flat files
- Reduce and eliminate rejections by updating data values
- Easily age data files
- Use coverage techniques to enrich data files
- Calculate check and sum totals automatically within the file
- Lookup data in back-end systems to ensure the data flows smoothly through your end-to-end test
Datamaker™The world´s most powerful test data generation, data obfuscation and database subsetting software
