Configuring the project results database

Historical test data is stored in the HCL OneTest™ API project results database. It is difficult to estimate the space that is required as the number and type of tests to be run varies. When you create the project results database, 50GB is probably a good starting point.

The supported databases that can be configured and used as the project results database are:
  • IBM® Db2®
  • Oracle
  • Microsoft™ SQL Server
  • MySQL

For information about the supported versions of the database, see the Supported Software > Database section in the download document https://support.hcltechsw.com/csm?id=kb_article&sysparm_article=KB0078997.

Note: Multiple projects can reside in the same database schema without impacting one another since the projects (and their artifacts) have unique keys.

After you install HCL OneTest™ API, you can create the project results database in an existing, empty, and supported database. The required IBM® Db2® and the Oracle JDBC drivers are installed with HCL OneTest™ API, and connectivity is established later from all clients, including agents.

Note: Some databases require that you configure JAR files in the database (JDBC) section of Library Manager. In addition, if you plan to view the project results database in HCL® Quality Server, copy the JAR files to the lib folder of the HCL® Quality Server installation directory (for example, C:\Program Files\HCL\HCLProducts\QualityServer\usr\servers\defaultServer\apps\RTCP.war\WEB-INF\lib).

The database creation scripts can be found in the scripts folder of the HCL OneTest™ API installation directory (for example, C:\Program Files\HCL\HCLProducts\API\scripts).

A script is provided for some of the supported database providers:

  • IBM® Db2®: ghtester_db2.sql
  • Oracle: ghtester_oracle.sql
  • Microsoft™ SQL Server: ghtester_mssql.sql
  • MySQL: ghtester_mysql.sql

The appropriate script can be run against an empty database by a database administrator.

If you are a user of a project results database that is created by someone else, you must have the following permissions to work with the database:
  • INSERT, UPDATE, DELETE, SELECT on all the HCL OneTest™ API tables
  • EXECUTE PROCEDURE
  • SELECT SEQUENCE on the HCL OneTest™ API sequences for the Oracle databases
Note: To ensure that the HCL OneTest™ API results database handles Unicode characters correctly, it must be configured to use UTF-8. Details on how to do this are included in the instructions on creating the results database for each database provider.

For managing test cycles, you must configure a project results database. For details on test cycles, see Test cycles overview and management.