RowGen GUI

Inside IRI Workbench, Built on Eclipse™

IRI RowGen™ is the fastest, safest, and most intelligent test data generator for the realistic population of:

  • relational databases
  • flat files in any format
  • custom detail and summary reports


Simple, explicit RowGen Control Language (RCL) job scripts -- which use the same "SortCL" syntax and metadata with other IRI tools -- define the content and structure of the test data you need to:

  • develop and stress test applications
  • prototype databases and ETL/ELT operations
  • safely outsource formatted data targets

when production data are confidential or unavailable.


Because these and other RowGen features are supported in the IRI Workbench GUI, developers and test teams can use help-enabled job wizards and dialogs to create RCL scripts automatically. RCL files describe the precise layout of the data to be randomly generated or selected, including the size, position, and data type of each field element. A dynamic job outline links back to the script and GUI dialogs. A syntax-aware editor is also included for those who prefer writing or modifying their jobs manually.

To help you create realistic and referentially correct test data for databases, the RowGen GUI parses the data model information of any JDBC-connected database. The GUI's 'DB Test Data' wizard converts the SQL definitions for the selected table structures, and their primary and/or foreign key relationships, into RowGen job controls. When the RCL job scripts run, they produce pre-sorted test data sets and bulk database load utility control files to auto-populate your target tables.

Additional GUI wizards and dialogs for RowGen:

  • control composite data format and set file creation
  • set up and graph frequency (value occurrence) distributions
  • help you create data in all pairs and joined pairs combinations


Some of the other convenient aspects of using the RowGen GUI in the IRI Workbench include:

Eclipse Feature

Benefits in IRI RowGen GUI

Project Explorer

Management of input and output files, job scripts, and metadata

Text Search

Test data metadata lineage and impact analysis

Team Plug-Ins

Test data job script / project sharing and version control

Data Tools Platform / Data Source Explorer

Browsing and populating databases

IRI CoSort Metadata and Job Integration

Easily add transformation, conversion, and reporting functions to RowGen jobs