Welcome
Test Author guide
This guide, which is intended for a tester and test manager, describes how to create test assets in HCL OneTest™ 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.
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.

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
Getting started guide
This guide, which is intended for new users, provides an overview and some task flows to get you started with HCL OneTest™ Server.
Administrator guide
This guide, which is intended for an administrator, describes how to install HCL OneTest™ Server software. After you install the software, you can administer the server. Administration tasks can include License configuration, User management, Security, Memory and disk usage management, Backup and restore user data.
Test Author guide
This guide, which is intended for a tester and test manager, describes how to create test assets in HCL OneTest™ 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.
Test Execution Specialist guide
This guide, which is intended for a tester or a test execution specialist, describes tasks that you must complete before you can configure and run tests on HCL OneTest™ Server. You can find information about other tasks that you can perform on the Resource Monitoring Service, Virtualization, and Integrations with third-party applications.
Test Manager guide
This guide, which is intended for a test manager, explains how to manage and track your overall test effort.
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 HCL OneTest™ Server
While working with HCL OneTest™ Server, you might encounter some problems that you can easily troubleshoot.
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
For HCL OneTest™ Server, you can take actions to ensure that your installation is secure, customize your security settings, and set up user access controls.
Notices

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.

Procedure

Download the JDBC connector jar file to your local file system.
Copy the connector jar file from your local file system to the HIP REST and HIP Server pod by using the following commands from the command prompt.
For example, run the following commands if you are using the MySQL database:

For HIP REST pod

kubectl cp /<source path/mysql-connector-java-8.0.19.jar rockstar-hip-rest-5d4d6b6d66-kbj5l:/opt/runtime/extra/mysql-connector-java-8.0.19.jar

For HIP Server pod

kubectl cp /source path/mysql-connector-java-8.0.19.jar rockstar-hip-server-0:/opt/hcl/hip/extjar/mysql-connector-java-8.0.19.jar
Notes:
- Depending on the database you use, you might have to modify the commands for the database.
- When you install or restore HCL OneTest Data, you must copy the connector jar file again.
Create a schema with a table in the database by using the following commands from the command prompt.
For example, if you want to use the MySQL database, you can use the following command in the MySQL Workbench to create a schema with a table:
```
create schema <schema_name>;
use <schema_name>;
    CREATE TABLE IF NOT EXISTS <table_name> (
    task_id INT PRIMARY KEY,
    title VARCHAR(255) NOT NULL,
    description TEXT
);
```
This command creates a schema in the MySQL database.
Remember: In HCL OneTest Data, you must refer to the schema name and the table name that you created by using this command.

Results

You have successfully created a sample schema in the database.

What to do next

After you create a schema in the database, you must establish the connection between HCL OneTest Data and the JDBC supported database. See Establishing a JDBC connection with HCL OneTest Data

Note: You can view the schema name that you created in the database as the value of the Catalog property in HCL OneTest Data.