|
|
|
DTM Data Generator, features list
Environment
| Operating systems support |
Windows XP, Vista, 7, Server 2003, 2008. |
| Can the software work with text files without database connection? |
Yes. |
| Does the product support data creation in command line mode? |
Yes, with predefined project file. |
Connectivity
| Additional client side software requirements |
ODBC, OLE DB or Oracle Call Interface. |
| Can the software work with text files without database connection? |
Yes, the product can create file(s) containing set of insert SQL statements. This file can be used to load data to remote database. |
| Does the product support file DSNs? |
Yes. |
Data Creation Process
| How many data rows can the software create? |
In most cases maximum rows per rule is about 4,200,000,000 for Enterprise edition.
However the user can create a few identical rules for the same table. |
| Does the product support selective update existing data mode? |
Yes, as well as Append, Replace and Data Scramble Modes. |
| What kind of value sources for data generation are supported? |
User defined lists
Text data files (one value per line), spreadsheet or Values Library
Another database table (from the same or another data source)
SQL statement
|
| Does the product support data library for realistic data generation? |
Yes, the following data sets are included in the software distribution package:
the list of countries,
two lists of country codes,
the list of female first names,
the list of male first names,
the list of random names, etc. |
| Does the product support custom data library? |
Yes, Library Builder is included in the installation package. |
| Can the product run SQL script before or after test data creation process? |
Yes, project-level and rue-level prologue and epilogue scripts are supported. |
| Should I order full license to run a project created by colleague? |
No, runtime license helps you save money in this case. |
Data Generator, output
| What kind of database objects are supported for creation? |
Data rows, Tables and Objects (views, procedures, etc). |
| Does the product support generation test tables, views and other database objects by template? |
Yes. |
| Can the product create a text file with generated data? |
Yes: tab-delimited file, CSV file or text file with custom field separator. |
| Can the product create a XML file with generated data? |
Yes. |
| Does the product support custom formatting for generated values? |
Yes, C/C++-like format strings can be used for most rules. |
Data Generator, database support
| Does the product support any DBMS-specific features? |
Yes, for MS SQL Server, Oracle, DB2, MySQL, PostgreSQL, Sybase and Interbase/Firebird. |
| Does the product support test data generation for BLOBs (large database objects)? |
Yes, basic support for BLOBs is available. Random BLOB loader is also included into the installation package. |
| Does the product support database referential integrity? |
Yes, the product uses foreign keys automatically. |
| Does the product recognize NULL properties automatically? |
Yes. |
| Does the product support check constraints? |
Yes, for MS SQL Server data generation only. |
| Can the product clear tables before data for testing generation? |
Yes, the Clear Rule can remove data rows from the selected tables. |
| Does the product support database schema changes verification? |
Yes. |
| Does the product allow user to customize transaction size? |
Yes. |
Assistance/Help
| Is help for the tool built into the product? |
Yes. |
| Is help for the tool available online? |
Yes, see online help |
|
|
|
•