Home
Test Author guide
This guide, which is intended for a tester and test manager, describes how to create test assets in Rational® Test Automation Server and publish test assets to the Git repository that you have configured.
Generation of test data
To test an application, you use data that is passed to get real-time results. Since creating test data manually is time-consuming, you can use HCL® OneTest™ Data, an automated tool to generate random test data. You can generate the test data in various file formats.
Generating test data
When you have a defined and structured schema for the entire data, you can generate test data to perform application testing.

Test Author guide
This guide, which is intended for a tester and test manager, describes how to create test assets in Rational® Test Automation Server and publish test assets to the Git repository that you have configured.
- Datasets overview
  A dataset provides tests with variable data during a run. The test that uses a dataset at run time replaces a value in the recorded test with variable test data that is stored in the dataset.
- Generation of test data
  To test an application, you use data that is passed to get real-time results. Since creating test data manually is time-consuming, you can use HCL® OneTest™ Data, an automated tool to generate random test data. You can generate the test data in various file formats.
  - Schema fabrication
    A schema is a graphical structure to represent different types of data. You can fabricate a schema for the generation of test data.
  - Schema design overview
    When you compose a schema by using HCL® OneTest™ Data you must define the types of the schema. You can also modify the types of the schema when you import any schema from local file system or use the schema generated by using any external resource.
  - Generated test data in JDBC database
    When you want the generated test data in any Java Database Connectivity (JDBC) supported database, you can generate the test data by using HCL® OneTest™ Data. Subsequently, HCL OneTest Data inserts the generated test data directly in the configured JDBC supported database.
  - Generating test data
    When you have a defined and structured schema for the entire data, you can generate test data to perform application testing.
  - Generated test data for SAP BAPI
    When you want to generate test data for SAP Business Application Programming Interface (BAPI), you can generate a schema in HCL® OneTest™ Data based on structured schema of SAP BAPI function modules. You can then generate the test data by using the generated schema in HCL OneTest Data.
  - Generated test data for SAP IDoc or DXOB
    When you want to generate the test data for an SAP Intermediate Document (IDoc) or Data Transfer Object (DXOB) file, you can generate a schema in HCL® OneTest™ Data by using the structured schema of the SAP IDoc or DXOB file. You can then generate the test data by using the generated schema in HCL OneTest Data.
  - Status of generated test data
    You can view the status of all the test data generated jobs performed in your project, on the Jobs page.

Generating test data

When you have a defined and structured schema for the entire data, you can generate test data to perform application testing.

Before you begin

The following prerequisites must be met to generate the test data:

You must have created a project.
The schema must have a Group type.
You must have a structured view of your defined schema.

About this task

You can generate the sample test data from the Group type of a schema. When you import the XSD format schema, then HCL® OneTest™ Data generates only XML test data. If you import JSON format as input, the application generates only JSON test data.

Procedure

Select your project in Rational® Test Automation Server and navigate to the Data Fabrication page.
Click Schemas tab and select the schema for which you want to generate the test data.
Select a Group type and click the context menu.
Click Generate Data.
The Generate data dialog box appears.
Enter the number of records that you want to generate and the seed value for reference.

The seed value acts as an instance of random data that can produce the same set of data multiple times. By default, the 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. HCL® OneTest™ Data supports the following formats:
- CSV
- Native
- JSON
- XML
- Excel
Notes:
- If you create a schema by using the schema designer, by default, the output file format is CSV.
- If you import a schema into your project or have a schema with nested groups, you can select only the Plain text file as the output file format.
- You can generate line numbers in the output by creating an auto-increment rule by using functions and expressions.
Click OK.

Results

The test data is generated successfully.

Note: The column headings for the generated test data are available only for the CSV and Excel file output formats.

What to do next

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