Generating the test data by using multiple schemas

You can generate the test data either by using multiple JDBC-supported or non-JDBC schemas.

Before you begin

You must have completed the following tasks:
  • Logged into HCL OneTest™ Server.
  • Installed any JDBC-supported database, such as Oracle, MySQL, and so on, for generating the test data from JDBC-supported schemas.

About this task

You can generate the test data for multiple schemas simultaneously. To generate the test data you can either use only JDBC-supported schemas or non-JDBC schemas.

To generate the test data by using multiple JDBC-supported schemas, you must create tables in a database that are supported by the JDBC connection. After you establish the JDBC connection between the database and HCL® OneTest™ Data, you must generate multiple schemas. You can then import the selected schemas into the Schema Canvas page. After you import the schemas into the Schema Canvas page, you can view an existing parent-child relationship. You must select a single schema or multiple schemas for which you want to generate the test data, and then generate the test data.

To generate the test data by using multiple non-JDBC schemas, you must create a schema in HCL® OneTest™ Data. You must then define the properties and structural view of the schemas. When the schemas are created, you can import the selected schemas into the Schema Canvas page. After you import the schemas into the Schema Canvas page, you can view an existing parent-child relationship or establish a relationship among the schemas. You must select the schemas, and then generate the test data.

Notes:
  • When you generate the test data by using multiple schemas, you must select either JDBC-supported or non-JDBC schemas.
  • When you select a child schema on the Schema Canvas page, the parent schema is automatically selected. Similarly, if you select a parent schema, then all the child schemas are selected on the Schema Canvas page.
The output formats that are supported in HCL® OneTest™ Data for the generation of test data for multiple schemas by using referential integrity are CSV, Excel, Native, JSON, and XML. You can also insert the generated test data into the database by using the JDBC connection.
Note: You can generate the test data among the common output formats that are supported by all selected schemas.

Procedure

  1. Log in to HCL OneTest™ Server and open the team space that contains your project.
  2. Open your project.
    The Overview page is displayed.
  3. Click Author > Data Fabrication.
    The Data Fabrication page is displayed.
  4. Choose any one of the following types of schemas that you want to use to generate the test data:

Results

You have generated the test data by using multiple schemas simultaneously.