EMS Data Generator for Oracle

What is EMS Data Generator for Oracle?

EMS Data Generator for Oracle is an impressive tool for generating test data in Oracle database tables, with the ability to save and edit scripts. The utility can help you simulate the database production environment and lets you populate multiple Oracle database tables with test data simultaneously, define tables and fields to generate data, set ranges of values, generate Oracle character fields by mask, set value lists manually, or select them in SQL queries,  define generation parameters for each field type and has many other features to generate Oracle test data simply and directly. Data Generator for Oracle also provides a console application, which allows you to generate Oracle test data in one touch, using generation models.

Core features

• Unicode support.
• Friendly wizard interface.
• Ability to save and edit data generated in sql script without running queries on the server.
• Support of oracle basic data types, including NUMERIC, CHARACTER, DATETIME (DATE, TIMESTAMP), RANGES and BINARY (RAW, LONG RAW, BLOB).
• Ability to select different types of data insertion: through INSERT or MERGE.
• Data generation for multiple tables of different database schemas.
• Different generation types for each field, including list, random and incremental generation, generation in two and more fields simultaneously.
• Ability to use SQL query results as a list of values for data generation.
• Ability to view the generated data.
• Automatic referential integrity control for linked tables.
• Ability to disable triggers of tables generated during the generation process.
• Wide variety of generation parameters for each field type.
• Ability to set NULL values for a given percentage of cases.
• Ability to save all generation parameters defined in the current wizard session in a configuration file.
• Command-line utility for generating data using the template file.

System requirements

Microsoft Windows XP, Microsoft Windows Server 2003, Microsoft Windows Server 2008, Microsoft Windows Server 2008 R2, Microsoft Windows Server 2012, Microsoft Windows Server 2012 R2, Microsoft Windows Server 2016, Microsoft Windows Vista, Microsoft Windows 7, Microsoft Windows 8 / 8.1, Microsoft Windows 10

20 MB of available HD space for program installation

Oracle Client 8.1.7 ou superior

Possibility to connect to any local or remote Oracle server