Generating test data for selected schemas

After you select multiple schemas on the Schema Integrity page, you can generate the test data of all the selected schemas simultaneously.

Before you begin

You must have completed the following tasks:

Created a project.
Generated schemas in HCL® OneTest™ Data by using a JDBC connection. See Generating a schema in HCL® OneTest™ Data.
Defined properties for the generated schemas. See Defining properties of schemas.
Selected all schemas that are generated by using the same JDBC connection. See Selecting multiple schemas.

Select your project in Rational® Test Automation Server and navigate to the Data Fabrication page.
Click Generate Data to generate the test data for the selected schemas on the Schema Integrity page.
The Generate Data dialog box is displayed.
Select the output location from the following options:
- File: You must select the File option to generate the output in CSV, Excel, or Native format.
- Connections: You must select the Connections option to insert the generated test data into the database by using the JDBC connection.
Enter the number of records that you want to generate in the Number of records field.

Enter a seed value in the Numeric Seed Value field.

The seed value acts as an instance of random data that can generate the same set of data multiple times. The default seed value is blank.

Note: The following table lists the maximum values for numeric seed value and number of records:

Description	Maximum values
Numeric seed value	8 digits (99,999,999)
Number of records	9 digits (999,999,999)

Choose the output file format of the test data that you want to generate from the Output File Format list.
Click Analyze to validate the selected schemas.

If the selected schemas are validated successfully, then you can view the order of schemas execution for generating the test data. All the parent schemas are executed first followed by the child schemas.
Note: If the validation fails, it might be because of one of the following reasons:
- The parent schemas of all the selected schemas are missing.
- The connection and actions of selected schemas do not exist in the project.
- Any one of the following properties of all item types of the selected schemas are not set:
  - Min size (digits) and Max size (digits) properties for each integer item type.
  - Set Required property.
You must resolve the cause of failure for the successful validation of the schemas.
Click OK.

You have generated the test data by using multiple schemas simultaneously.

HCL® OneTest™ Data first generates the test data of the parent schema followed by the child schemas.

You can view and download the generated test data of all the selected jobs on the Jobs page. See Status of generated test data.