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 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 a schema based on an Excel file
After you establish the connection between HCL® OneTest™ Data and Excel, you can generate a schema that is based on an Excel file in HCL OneTest Data.

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.
    - 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.
      - Importing an Excel file
        When you want to establish a connection between HCL® OneTest™ Data and an Excel file, you must import the Excel file into your HCL OneTest Data project from your computer.
      - Establishing a connection between HCL OneTest Data and Excel
        When you want to generate a schema based on an Excel file, you must establish a connection between HCL® OneTest™ Data and Excel.
      - Generating a schema based on an Excel file
        After you establish the connection between HCL® OneTest™ Data and Excel, you can generate a schema that is based on an Excel file in HCL OneTest Data.
      - Generating test data by using the generated schema
        After you generate the schema in HCL® OneTest™ Data, you can use this schema to generate the test data in 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.

Generating a schema based on an Excel file

After you establish the connection between HCL® OneTest™ Data and Excel, you can generate a schema that is based on an Excel file in HCL® OneTest™ Data.

Procedure

Select your project in Rational® Test Automation Server and navigate to the Data Fabrication page.
Click the Connections tab and select the connection that you created.
Click the menu, and then select New Action.
Select Target as the Action Type in the New Action dialog box, and then click Next.
Enter the following properties of the schema that you want to generate, and then click Next:
- Select the Excel file that you imported into your project from the Excel File drop-down list.
- Click Fetch to upload all the worksheets of the Excel file in the Worksheet drop-down list.
- Select the worksheet from the Worksheet drop-down list.
Note:
You can retain the default property settings for all other fields.
Select New, and then click Generate.

The schema is generated in HCL® OneTest™ Data. HCL® OneTest™ Data generates the schema name as schema_<number>.
Note: You must select this schema name as the schema for HCL® OneTest™ Data to generate the test data.
Select the schema type as Sheet.
Click Next to provide the identification details of the new action, and then click OK.

The new action is created and listed under the connection that is established between HCL® OneTest™ Data and Excel.

Results

You have successfully generated the schema in HCL® OneTest™ Data.

Note:

You can modify the schema name schema_<number> from the Schemas tab.

Tip: If you want to generate schemas for other Excel files, then you must click New Action on the existing Excel connection. You need not create a new connection.

What to do next

You can view the generated schema listed under the Schemas tab. You can generate the test data for the generated schema in HCL® OneTest™ Data. See Generating test data by using the generated schema.