Setting Up Data Generator

This topic describes how to set up Data Generator for Oracle to generate test data.

It is recommended to back up the database that you are going to populate before you generate the data. You can adjust the settings and repeat the data generation if you are not satisfied with the results.

To begin with, select an Oracle instance and a database you want to populate. For more information, see Connecting to a Database.

To generate data, do the following:

  1. On the Standard toolbar, click New Data Generation.

  2. In the Data Generator Project Properties > Connection section, specify the connection, select a required schema, and then click Next.

    Data Generator Project Properties

  3. In the Data Generator Project Properties > Options section, set the required options and then click Open.

    You can specify the tables that you want to populate by selecting the check box that is located next to the table name. Further, you can define how you want the data to be generated: click the table name in the tree view and specify the details in the settings pane. All the changes are displayed in real-time.

    Note

    There may be errors during data generation. For example, a column may be a foreign key of a table that is not included into generation. To resolve such issues, navigate to the Related Tables section of the Table generation settings, and include/exclude parent and child tables from data generation.

    To learn how to populate a database with test data, see Populating a Database.