Automated Test Data Generation For Azure Databases
- Generate meaningful test data
- Generates data that is appropriate for the database schema
- Populate database directly or generate insert scripts
- Customize data generators (if desired)
- Large collection of predefined generators
- Project oriented architecture
When developing a database, you would be wise to test it. You need test data to run your application against. To test the performance effectively, you must have enough test data. Datanamic Data Generator for Azure comes with features that will help you generating meaningful test data for your Azure database quickly.
Datanamic Data Generator for Azure generates realistic test data that is appropriate for the database schema (with referential integrity support). The data can be inserted in the database directly or you can generate a SQL script with insert statements.
You load the database and select the tables you want to populate with test data. The test data generation plan defines which data is generated for each column. For each column, the tool chooses an appropriate generator that generates data of a particular type. Ofcourse you can select another data generator or customize the generator. Datanamic Data Generator for Azure includes more than 40 built-in data generators for generating different kinds of data. You can create your own data generators also.
You save time by using Datanamic Data Generator for Azure to generate test data. You don't have to create your test data manually anymore. When your underlying database changes, the tool detects that and automatically chooses appropriate data generators so that you don't have to start all over again. To further automate your test data generation process, you can use the included command-line utility.
A large number of data generators to choose from, an intuitive user interface and intelligent association of columns with an appropriate data generator. Test data generation with Datanamic Data Generator for Azure is easy and painless.
FeaturesDatanamic Data Generator for Azure is a software tool that generates test data for Azure databases. It inserts generated data directly into the database, or builds a script with insert SQL statements.
- Generate test data with just a few clicks.
Select the target database and the tables you want to fill and press "Generate test data". Ofcourse you can fine-tune the data generators if desired.
- More than 40 built-in data generators.
Datanamic Data Generator for Azure includes several built-in data generators for generating different kinds of data. For example, the integer generator provides random integer values, the date generator provides random dates, and the expression/mask generator provides strings that match a pattern that you specify.
- Generation of data for multiple tables.
You can select the tables you wish to fill with test data. A Datanamic Data Generator for Azure project can hold one or hundreds of tables.
- Generates realistic data.
Intelligent use of the expression/mask generator (for for example postal codes) and a large collection of (contry/language specific) lists with names, addresses, cities, streets, etc makes your test data more realistic.
- Insert data directly into the database or generate a SQL script with insert statements.
- Load data from external sources.
You can load (random, sequantial) data from CSV files or from other tables in the database. Source data that is from a different data type, will be converted automatically.
- Generates data that is appropriate for the database schema.
Syntactically correct data is generated for each column.
- High performance.
The tool inserts thousands of test data records per second.
- Referential integrity support.
Datanamic Data Generator for Azure 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.
- Advanced data generator settings.
You 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.
- Clear and intuitive user inter face.
Clear and simple inter face with a list of tables and the columns with their data generator settings.
- Realtime preview of data.
You can preview the data that will be generated for each table. As soon as you change a data generator setting, the data in the preview pane will change.
Automation and Productivity
- Command-line utility.
A command-line utility is included to automate your test data generation process. You can create a data generation plan (project) with the GUI application and then (optionally) execute this plan with the included command line utility.
- Intelligently chooses appropriate data generator for each column.
By default, the tool chooses an appropriate data generator for a column based on the column's characteristics. The column name, the table name, the constraints, the data type and more characteristics are used to choose a correct data generator for that column.
With Datanamic Data Generator for Azure you can save your test data generation plan to a project file.
- Validation of data generation settings.
Datanamic Data Generator for Azure will check your data generator settings before test data is being generated. It will check for wrongly entered values and it will check if a setting is valid in combination with 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.
- Create your own data generators.
A data generator is a set of data generation settings. You can create your own data generator and give it a name. You can then use that generator in all your projects. You can define for which kind of columns this data generator must be used (matches). This information can be saved and will be used when the tool chooses an appropriate data generator for a column.
Datanamic Data Generator for Azure costs $ 499 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: MS Azure SQL