Automated Test Data Generation

Data generation for multiple database platforms

Databases supported:

• Oracle
• MS SQL Server
• PostgreSQL
• MS Access
• MySQL
• Microsoft SQL Azure.
• Firebird
• InterBase
• SQLite

Intelligently associates a column with a generator based on column characteristics

When the tool analyzes your database schema it automatically selects an appropriate generator for each column based on the column name, language used, data type, constraints etc. Ofcourse you cna change the generator for that column if that is desired.

Over 40 built in/predefined (and customizable) data generators

A large collection of lists, csv files (with addresses etc), date generators, string generators, expression generators etc is included.

Generate test data from scratch or from existing data

You can reuse data from existing sources such as another table or data in an external file.

Generation of data that matches to your database schema

Datanamic Data Generator reads the database schema details from your database. This schema information (metadata) is used for generating syntactically correct data that automatically matches your domain values (data types).

Output generated data to the database or to a SQL insert script

When you start generating the data, you can choose to output to the database or to a SQL file with insert statements.

Single-click test data generation

When you have connected to a database, Datanamic Data Generator automatically chooses the most appropriate data generation settings for each field. Ofcourse you can fine-tune these settings but you can also choose to generate data with this default settings. All you have to do then, is clicking the "Generate data" button.

Referential integrity support

Datanamic Data Generator for racle automatically controls referential integrity for linked tables. When data is inserted, it will be done in the correct order. When a child column is part of a relationship it will by default load random data from the parent column in the parent table. Datanamic Data Generator also correctly handles multi-column foreign key constraints.

Generates data based on user-defined masks

A powerful way to generate meaningful data that matches your needs is to fill a field using the "Random text using mask" generator. By using the "Random text using mask" fill type, you can generate strings that match a defined pattern. You can use the "random text using mask" generator with any data column that has a data type that accepts a string (char, varchar, clob, string, text, etc...) and user-defined types (domains) based on these string types.