Home
Test Author Guide
This guide describes how to create test assets in HCL OneTest™ Server and publish test assets to the Git repository that you have configured. You can also edit existing test assets that are in the repository added to your project. 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.
Generating the test data by using multiple schemas
You can generate the test data either by using multiple JDBC-supported or non-JDBC schemas.
Parent-child association among schemas
When you want to apply the referential integrity rules among multiple non-JDBC schemas, you must associate a parent-child relationship among schemas on the Schema Canvas page.
Establishing a parent-child relationship within different schema groups
When you want the same data field to be included in the different schema groups simultaneously, you can establish a parent-child relationship between a single parent schema group with multiple child schema groups.

Test Author Guide
This guide describes how to create test assets in HCL OneTest™ Server and publish test assets to the Git repository that you have configured. You can also edit existing test assets that are in the repository added to your project. This guide is intended for testers and test managers.
- Test authoring
  You can use HCL OneTest™ Server to author tests instead of creating the tests by using the desktop products.
- 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-supported 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.
    - 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.
    - Generating the test data by using multiple schemas
      You can generate the test data either by using multiple JDBC-supported or non-JDBC schemas.
      - Selecting multiple schemas
        After you define the properties of schemas, you must select schemas and view the relationships among them to generate the test data for multiple schemas simultaneously.
      - Defining properties of schemas
        After you generate the schema from the configured database in HCL® OneTest™ Data, you must define the required properties for all schemas.
      - Importing schemas into the Schema Canvas page
        When you want to generate the test data or the Data Definition Language (DDL) statements by using single or multiple schemas, you must import schemas into the Schema Canvas page. You can import multiple schemas simultaneously.
      - Parent-child association among schemas
        When you want to apply the referential integrity rules among multiple non-JDBC schemas, you must associate a parent-child relationship among schemas on the Schema Canvas page.
        Establishing a parent-child relationship within different schema groups
        When you want the same data field to be included in the different schema groups simultaneously, you can establish a parent-child relationship between a single parent schema group with multiple child schema groups.
      - Modifying a relationship among schemas
        When you want to alter the existing relationship between schemas, then you can modify the established relationship on the Schema Canvas page.
      - Deleting a relationship among schemas
        When any established relationship among the item types of non-JDBC schemas is no longer required, you can delete that relationship on the Schema Canvas page.
      - Selecting schemas
        After you import schemas into Schema Canvas, you must select schemas to view the relationships among them, generate the Data Definition Language (DDL) statements, or generate the test data for multiple schemas simultaneously.
      - Modifying the selection of imported schemas
        After you import schemas into the Schema Canvas page, if you want to modify or remove the selected schemas, then you can modify the Schema Canvas page.
      - Generating test data for selected schemas
        After you select multiple schemas on the Schema Canvas page, you can generate the test data of all the selected schemas simultaneously.
    - Generating DDL statements for schemas
      When you want to know the Structured Query Language (SQL) statements to create a table from non-JDBC schemas that you created in HCL® OneTest™ Data, you can generate the Data Definition Language (DDL) statements for those selected schemas.
  - Status of generated test data
    You can view the status of all the test data generated jobs and Data Definition Language (DDL) statements generated jobs performed in your project, on the Jobs page.

Establishing a parent-child relationship within different schema groups

When you want the same data field to be included in the different schema groups simultaneously, you can establish a parent-child relationship between a single parent schema group with multiple child schema groups.

Before you begin

You must have completed the following tasks:

Created a project on HCL OneTest™ Server.
Fabricated the schemas in HCL® OneTest™ Data. See Schema fabrication.
Defined the properties of schemas. See Schema design overview.
Imported the schemas. See Importing schemas into the Schema Canvas page.

About this task

You can identify the schemas for which you want to establish a parent-child relationship in the referential integrity, and connect the item type of the parent schema to the same item type of child schemas within different schema groups.

Procedure

Log in to HCL OneTest™ Server and open the team space that contains your project.
Open your project.
The Overview page is displayed.
Click Author > Data Fabrication.
The Data Fabrication page is displayed.
Click Schema Canvas.
The Schema Canvas page is displayed.
You can view the structural view of all the imported schemas and their relationships with each other.
Note: You can use the scroll wheel or pinch-to-zoom option on the Schema Canvas page to view the structural view of all schemas and relationships.
Identify the schemas for which you want to establish a parent-child relationship.
Click the item type of the parent schema that you want to use as a Primary key.
Hover the mouse from the item type of the parent schema to the item type of the child schema.
A line is drawn between the parent schema and the child schema to represent the relationship among both the schemas.
Identify the child schemas and connect the parent schema to multiple child schemas.

Results

You have established a parent-child relationship between a single parent schema with multiple child schemas within different schema groups.

What to do next

You must select schemas on the Schema Canvas page to generate the test data. See Selecting schemas.

You can click the Modify canvas button to modify or remove the selection of schemas that you imported into the Schema Canvas. See Modifying the selection of imported schemas.