IRI RowGen is the only tool designed for big, structured data environments with multiple targets requiring safe, realistic test data.
RowGen produces huge test data volumes for databases, BI and DW ETL/ELT tools, flat files, and custom report formats. RowGen's simple batch execution paradigm is database- and platform-agnostic, making it ideal for automating test data generations across operating systems, and precluding the need for other products.
There are a number of reasons why RowGen is the best package for building test data for databases, and in custom file and report formats:
Unlike most test data tools, RowGen does not require access to original production files or databases. RowGen can make safe use of real data through random selections from real tables or "set" files, but it also allows you to create data based strictly on common database DDL, or file/report metadata in IRI DDF formats.
RowGen can automatically, accurately, and reliably build and populate test data for an entire VLDB platform or enterprise data warehouse from scratch, without the need for data masking, NDAs, learning curves or consulting engagements. Built-in audit logs and available version control support compliance with data privacy laws and safe project outsourcing, respectively.
RowGen test data conforms to production data characteristics. RowGen delivers realism to database application development and prototyping through:
- preservation of referential integrity (primary-foreign key links and various constraints)
- determination of row counts per table and null occurrences
- customization of value appearances, ranges, and frequency distributions
- transformation of test data during generation (e.g., filter, sort, join, aggregate, convert)
- generation of all and valid (joined) pair value combinations
RowGen delivers realism to software application development with the above, and through:
- modification of test file formats, record layouts, and report templates
- compound data value definitions, or format masks
- conditional display of constants and variables, like time/date stamps
- random pulls from real set data, inline sets, and literal value ranges, as field-level rules
- math and custom computation functions (e.g., to create valid national ID values)
Other test data tools are strictly GUI-driven, and the processes of job design and maintenance can be complex or require consulting. The metadata behind their creation and population of the test data may also be cryptic or hidden. RowGen by contrast exposes and holds its data generation, manipulation, and population metadata in simple, portable text files that are easy to create -- either by hand, or automatically with wizards in the IRI Workbench GUI for RowGen, built on Eclipse.™
Your editor, or the GUI, will show how easy RowGen jobs are to learn, export, modify, and run. The self-documenting 4GL syntax and familiar GUI interact seamlessly to speed job design, execution, and metadata management. RowGen GUI users also enjoy the metadata links, job scripting compatibility, and graphical integration, with the data transformation (integration and staging), data profiling, data masking, reporting, and advanced BI functions (BIRT) in the IRI Workbench environment at no additional cost.
Only RowGen has the high volume, high performance data generation, manipulation, and pre-sorted bulk-loading capabilities of CoSort that DBAs and big data architects require to test queries, applications, and operations across billions of rows.
Only RowGen can also meet the test data and compliance requirements of outsourcers and software developers who rely on safe, intelligent test data in multiple flat file and custom report formats. RowGen not only runs faster than other test data generators, it saves time in learning, test data definition, deployment, and project management.
RowGen is the only test data package compatible with Eclipse, and the easiest to configure with any relational databases supported by the Eclipse Data Tools Platform (DTP) plug-in.
RowGen job scripts are compatible with the metadata of the CoSort SortCL program for data transformation and reporting, as well as IRI NextForm for data and database migrations, and IRI FieldShield for data masking. Thus if if you have data or job definitions for any of those tools, you can re-use them in RowGen (and vice versa, when you're in production).
Only RowGen is compatible with the Dan Linstedt's Data Vault architecture, the Meta Integration Model Bridge (MIMB), and the Analytix DS Mapping Manager frameworks for test data metadata interchange with third-party data modeling and ETL tool architectures.