Home
Test Author Guide
This guide describes how to create test assets in Rational® Test Automation Server and publish test assets to the Git repository that you have configured. This guide is intended for testers and test managers.
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.
Test data generation from structured schemas
When you want to test your application by using randomly generated test data, then you must generate the test data from the structured schemas.
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.
Inserting the generated test data in a database
After you generate the schema from the configured database in HCL® OneTest™ Data, you can directly insert the generated test data in the database.

Test Author Guide
This guide describes how to create test assets in Rational® Test Automation Server and publish test assets to the Git repository that you have configured. This guide is intended for testers and test managers.
- 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.
  - Test data generation from structured schemas
    When you want to test your application by using randomly generated test data, then you must generate the test data from the structured schemas.
    - 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.
      - Creating a sample schema in a database
        To generate a schema in HCL® OneTest™ Data, you must create a schema with a table in the database.
      - Establishing a JDBC connection
        You must establish a connection between HCL® OneTest™ Data and the JDBC supported database to generate the schema and to write the generated test data in the database.
      - Generating a schema in HCL OneTest Data
        After you establish the connection between HCL® OneTest™ Data and the JDBC supported database, you can generate a schema in HCL OneTest Data from the configured database.
      - Inserting the generated test data in a database
        After you generate the schema from the configured database in HCL® OneTest™ Data, you can directly insert the generated test data in the database.
    - 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.
    - 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 in MongoDB
      When you use MongoDB as a database in your application testing environment and you want the generated test data in MongoDB, then you can generate the test data by using HCL® OneTest™ Data. Subsequently, HCL OneTest Data inserts the generated test data directly in MongoDB.
    - Generated test data for an Excel file
      When you use Microsoft Excel as a database in your application testing environment and you want to use the structure of an Excel file to generate test data, then you can generate the test data for the selected Excel file by using HCL® OneTest™ Data.
    - Generating test data
      When you have a defined and structured schema for the entire data, you can generate test data to perform application testing.
  - 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.

Inserting the generated test data in a database

After you generate the schema from the configured database in HCL® OneTest™ Data, you can directly insert the generated test data in the database.

Before you begin

You must have generated the schema by using the database. See Generating a schema in the database.

Procedure

Select the schema that you generated with the following name from the Schema tab:

anonymous_schema_<number>
Click the menu of the group type of the schema and select Structure.

You can view the list of all item types associated with the selected group type in the structure view.
Click the menu for all the item types to set the property as Set Required, and then click Save.

Note: If you have a numeric item type, you must set Min size (digits) and Max size (digits) properties.

For example, when you select Integer as Presentation then you can set the Min size (digits) as 1 and the Max size (digits) as 9.
Select the group type in the Dictionary dialog box and click Generate Data from the menu.

The Generate Data dialog box is displayed.
Select the Connection option and provide values for the Number of records and Numeric Seed Value.
Select the connection type from the list, and then click OK.

Results

You have successfully inserted the generated test data from HCL® OneTest™ Data in the JDBC supported database.

What to do next

You can click the Jobs tab to view the status of the job. The tooltip of the job displays the following details:

URL of the connection.
Name of the table.
Schema name from which the test data is generated.

Important:

You cannot download the generated test data from the Jobs page because the test data is written to the configured database and is not available in HCL® OneTest™ Data.

You can log in to the configured database to view the generated test data.