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

Release Notes
This document includes information about What’s new, installation and upgrade instructions, known issues, and contact information of HCL Customer Support.
System Requirements
This document includes information about hardware and software requirements for HCL OneTest™ Server.
Getting Started Guide
This guide provides an overview of HCL OneTest™ Server. You can find the task flows to get you started with HCL OneTest Server. This guide is intended for new users.
Administrator Guide
This guide describes how to install the HCL OneTest™ Server software.
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.
- Edit branch overview
  When you want to create or modify any test assets in HCL OneTest™ Server, you must use an Edit branch.
- 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.
      - 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 into 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.
    - Generating the test data by using multiple schemas
      You can generate the test data either by using multiple JDBC-supported or non-JDBC schemas.
    - 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.
Test Execution Specialist Guide
This guide describes tasks that you must complete before you can configure and run tests in HCL OneTest™ Server. You can find information about configuring runs for the different test types that are supported. You can also find information about other tasks that you can perform on the Resource Monitoring Service, Virtualization, and Integrations with third-party applications. This guide is intended for testers or test execution specialists.
Test Manager Guide
This guide describes how to manage and track your overall test effort. This guide is intended for test managers.
Reference Guide
This guide describes conceptual information about data design environment components when you want to use the data fabrication feature in HCL OneTest™ Server.
Troubleshooting
This guide describes how to analyze and resolve some of the common problems that you might encounter while you work with HCL OneTest™ Server.
All Guides (PDF)
You can find the link to view or download the content of the release notes, system requirements, and persona guides of HCL OneTest™ Server as a PDF file.
Security Considerations
This document describes the actions that you can take to ensure that your installation is secure, customize your security settings, and set up user access controls.
Notices
This document provides information about copyright, trademarks, terms and conditions for the product documentation.

HCL OneTest Data support to write the 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.

To enable HCL® OneTest™ Data to write the generated test data in the database, you must create a sample schema with tables 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 following JDBC-supported databases:

IBM DB2
MySQL Server
Microsoft SQL Server
Oracle database

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

INTEGER
VARCHAR
CHAR
DATETIME
DATE
TIME
BOOLEAN
Note: You must add the restriction values for BOOLEAN data type as 0 and 1.

Prerequisites

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

You must have access to HCL OneTest™ Server.
You must have installed a JDBC-supported database.

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