Innovative Routines International (IRI), Inc., The CoSort Company

Realistic Data in Real Formats

Do you need an easier way to:

• load a test database with referential integrity
• simulate and share file and report layouts
• develop and stress-test your applications
• benchmark new hardware and software
• conduct data warehouse ETL testing

using your data models and metadata, but not production data?

File and report layouts, table views, index orders, and key relationships must reflect reality to be useful in testing. Generating real file and report formats with safe values in ideal ranges -- and loading large tables -- can take a long time with other tools or programs.

Now, with IRI's new Test Data package, RowGen, you can generate multiple test files in multiple formats -- all in one job script and I/O pass -- for referentially correct test database loads, flat-file structures, and custom report formats.

RowGen leverages your DDL models for Oracle, DB2 UDB, SQL Server, Sybase, Teradata, and packaged apps so you can create realistic tables with referential integrity to test-populate an entire enterprise data warehouse.

If you need to create realistic flat or index files, RowGen can create test data directly in custom and standard file formats:

• Record, line or variable sequential
• CSV
• LDIF
• Text (fixed or delimited)
• XML
• COBOL index
• Mainframe blocked
• Detail / summary report

RowGen can randomly create field values in more than 100 data types, and apply intelligent selection and ranging criteria to improve data reaslism. RowGen's support for standard and complex data tansformations, set files, and conditional selection all contribute to the tool's usefulness in simulating production table and file formats for a variety of applications.

See these links for more information on using safe test data for:

• Benchmarking
• DB Population
• Prototyping (Application Development)
• Outsourcing
• Ranging and Stress-Testing