Do you need an easier way to:
- create test DBs with structurally and referentially correct data
- simulate and share file and report layouts
- develop and stress-test applications
- benchmark new hardware and software
- conduct data warehouse ETL testing
using your data models and metadata, but not production data?
Table views, index orders, key relationships, and file and report contents, must reflect reality to be useful in testing. Generating realistic values and formats with safe data in ideal ranges -- and populating large targets -- can take a long time with other tools or programs.
With IRI RowGen (or IRI CoSort), you can generate multiple test data targets for test database loads, flat-file structures, and custom report formats.
RowGen leverages the DDL information for Oracle, DB2 UDB, SQL Server, Sybase, Teradata, and other RDBs to create realistic tables with structural and referential integrity. Use RowGen to populate an entire test enterprise data warehouse (EDW).
RowGen can also create test data directly in many sequential file formats:
- Record, line, or variable sequential
- Text (fixed or delimited)
- COBOL index
- Mainframe blocked
- Detail/summary report
RowGen randomly generates field values in more than 100 data types. It can also randomly select data from set files at the field level. That, along with custom/compound data values, value ranges, and distributions, improve test data realism.
Support for standard and complex data transformations, set files, and conditional selection also contribute to RowGen's value in simulating production table and file formats for a variety of applications.
See these links for more information on using safe test data for:
- The Case for Factoring Data Privacy and Security Considerations into a Company's Outsourcing Strategy - Jacqueline Klosek and Andrew Lurie