Data Generator

What is Data Generator?

Automated generation of test data

Generate meaningful test data

Populate database directly or generate insert scripts

Data generation based on column characteristics

Customize data generators (if desired)

Large collection of pre-installed generators (country/language specific)

Supported databases: Oracle, MySQL, MS SQL Server, MS Access, MS Azure, SQLite, InterBase, Firebird and PostgreSQL

Datanamic Data Generator is a powerful data generator that allows developers to easily populate databases with thousands of meaningful and syntactically correct test data rows for database testing purposes.

An empty database is not useful for ensuring that your application works as designed. You need test data. Writing your own test data generators or scripts is time-consuming. The Datanamic Data Generator will help you. The tool can be used by DBAs, developers, or testers, who need sample data to test a database-driven application.

Datanamic Data Generator makes generating database test data easy and painless. It reads your database and displays tables and columns with your data generation settings. Only a few simple inputs are needed to generate comprehensive (realistic) test data. The tool can be used to generate test data from scratch or from existing data.

Resources

Datanamic Data Generator is a software tool for generating test data for database testing purposes. It inserts generated data directly into the database or creates insert SQL statements. Below you can find a list of features.

Data generation for multiple database platforms

Supported databases:

Oracle 9i, 10g, 11g, 12c and 18c.

MySQL 4, 5, 6 and 8.

PostgreSQL 7, 8, 9, 10 and 11.

MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016 and 2017.

MS Access 2000, 2003, 2007, 2010 and 2013.

Microsoft SQL Azure.

Firebird 1.x, 2.x, and 3.x.

InterBase 6, 7, 2009 and XE.

SQLite 3.0 and higher.

Intelligently associates a column with a generator based on the characteristics of the column

When the tool analyzes the database schema, it automatically selects an appropriate generator for each column, based on the column name, language used, data type, constraints, etc. Of course, you can change the generator for that column if you want.

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

A large collection of lists, csv files (with addresses), date generators, string generators, expression generators, etc. are 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.

Generating data that matches the database schema

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

Data generated from output to the database or to an SQL insert script

When you start generating the data, you can choose to send it to the database or to an SQL file with insert statements.

One-click test data generation

When you connect to a database, Datanamic Data Generator automatically chooses the most appropriate data generation settings for each field. Of course you can adjust these settings, but you can also choose to generate data with these default settings. All you have to do is click the "Generate Data" button.

Referential integrity support

The Datanamic Data Generator for racle automatically controls referential integrity for linked tables. When data is entered, it is done in the correct order. When a child column is part of a relationship, by default, it loads random data from the parent column into the parent table. The 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 meets your needs is to fill in a field using the "Random text wearing mask" generator. 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 column of data that has a data type that accepts a string (char, varchar, clob, string, text) and user-defined types (domains) based on those string types.

System Requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD/SSD: 50 GB of free space on main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768