FeaturesDatanamic Data Generator MultiDB is a software tool to generate test data for database testing purposes. It inserts generated data directly into the database, or builds insert SQL statements. Below you can find a list of features.
Data generation for multiple database platformsDatabases supported:
- Oracle 9i, 10g, 11g and 12. Works without Oracle client software.
- MS SQL Server 2000, 2005, 2008, 2012 and 2014.
- Microsoft Azure.
- MySQL 3,4 and 5.
- PostgreSQL 7,8 and 9.
- MS Access 2000, 2003, 2007, 2010 and 2013.
- SQLite 3.
Intelligently associates a column with a generator based on column characteristicsWhen 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 generatorsA large collection of lists, csv files (with addresses etc), date generators, string generators, expression generators etc is included.
Create your own named generatorsYou can create your own generator based on a built in data generator. You give this user defined generator a name and you can specify for which kind of columns this generator must be used.
Generate test data from scratch or from existing dataYou can reuse data from existing sources such as another table or data in an external file.
Detection of metadata changesWhen you refresh the tables (Project | Refresh tables) in an opened project or when you re-open an existing data generator project, Datanamic Data Generator automatically reads the database and detects when a column or table has changed or has been deleted. It will then automatically apply this change to the table(s) in the project.
Generation of data for multiple tablesYou can select the tables you wish to fill with test data. A Datanamic Data Generator MultiDB project can hold one or hundreds of tables.
Generation of data that matches to your database schemaDatanamic 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).
Conversion of source dataSource data that is from a different data type, will be converted automatically.
Single-click test data generationWhen you have connected to a database, Datanamic Data Generator MultiDB 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.
Validation of data generation settingsDatanamic Data Generator MultiDB will check your table settings and field settings before test data is being generated. It will check for wrongly entered values and it will check if a field setting is valid based on the other settings (such as for example the number of rows to generate). It is for example possible that you've selected a fill method "Random value from data table" for a field with a unique constraint. If the number of records (lines) in the data table is not enough to generate unique values for the specified number of rows to generate, Datanamic Data Generator will raise an error.
Generation of data from an extensive set of included CSV filesWhen you install Datanamic Data Generator MultiDB, a number of CSV files (delimited text files) with thousands of names, zip codes, cities, countries, and more, will be installed.
Project-oriented architectureDatanamic Data Generator MultiDB is project-oriented, so a user can create a project that indicates which database and which tables to fill and how to generate the test data. Projects can be as simple as loading a single table, or as complex as loading hundreds of tables.
Generates data based on user-defined masksA 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.
Randomly generated values can be constrained to a range of valuesDatanamic Data Generator MultiDB allows you to place restrictions on data values it will generate. For example, integers can be constrained to a range of values. Date/time values can be constrained to a date range. Text strings can be constrained to a fixed set of choices (also known as enumerations).
Output generated data to the database or to a SQL insert scriptWhen you start generating the data, you can choose to output to the database or to a SQL file with insert statements.
Preview of dataRealtime preview of table data that will be generated with your current settings.
Disable triggersTo avoid potential problems when inserting data, you have got the option to disable triggers before data generation. These triggers will be enabled again after data generation.
Disable foreign key constraintsTo avoid potential dependency problems when inserting data, you have got the option to disable foreign keys before data generation. These constraints will be enabled again after data generation.
Empty tables optionWhen you have checked the "Empty table" setting for a table, you are prompted to clear the contents of the table before inserting rows. Datanamic Data Generator MultiDB then deletes the existing data in the table before generating the new data.
Referential integrity supportDatanamic 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.
Pre/post data generation SQLYou have got the option to use (and execute) user defined SQL code before and after data generation.
Advanced data generator settingsYou can specify the percentage of null values for each column. You can also define for how many rows a generated value must be used. This is very useful when generating data for a master and child table. You can for example specify that each Customer may have at least 5 but not more than 10 Orders.
The easiest way to see if Datanamic Data Generator MultiDB can help you is to try it out: