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:
  • MySQL Server
  • Microsoft SQL Server
  • IBM DB2
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 any JDBC-supported database, such as MySQL, Microsoft SQL Server, 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