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 HCL OneTest 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