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.
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.

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.
    - 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.
  - 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.

HCL OneTest Data support to write the generated test data in JDBC databases

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.

To enable HCL OneTest Data to write the generated test data in the database, you must create a sample schema in the installed JDBC supported database, establish a connection with the installed database, select the generated schema in HCL OneTest Data, and then generate the test data of the selected schema.

HCL OneTest Data supports the test data generation for the following data types:

INTEGER
VARCHAR
TEXT
DATETIME

Prerequisites

The following prerequisites must be met to enable HCL OneTest Data to write the generated test data:

You must have access to Rational® Test Automation Server.
You must have installed any JDBC supported database, such as Oracle, MySQL, and so on.

Task flow

You must perform the following tasks in sequence to enable HCL OneTest Data to write the generated test data directly in the JDBC supported database. The table also provides you the links to the information about the tasks.

Task	More Information
Create a sample schema in a database	Creating a sample schema in a database
Establish a JDBC connection with HCL OneTest Data	Establishing a JDBC connection with HCL OneTest Data
Generate a schema in HCL OneTest Data	Generating a schema in HCL OneTest Data
Insert the generated test data in the database	Inserting the generated test data in a database