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.

Procedure

  1. Click the Connections tab and select the connection that you created.
  2. Click the context menu and select New Action.
  3. Select Target as the Action Type in the New Action dialog box and click Next.
  4. Enter the following properties of the schema that you want to generate, and then click Next.
    Properties Actions Required/Optional
    Target

    Select the target as Table that you created in the database from the list.

    Required
    Write Mode

    Select Insert to insert the data in the database.

    Required
    Catalog

    Select the schema name that you created in the database from the list.

    Required
    Schema

    Select the schema name that you created in the database from the list.

    The schema name is displayed either in the Catalog or in the Schema field for the selected database.

    Optional
    Table

    Select the name of the table that you created in the database from the list.

    Required
    Logging

    Select logging as ON, if you want the actions performed in the database to be logged in the log files.

    Optional
    Failure Action

    Select the action to be performed when any failure occurs while generating the schema.

    The default failure action is Rollback.

    Optional
    REST Output Select to override the action after deploying in HIP REST. Optional
  5. Click Generate.
    The schema is generated in HCL OneTest Data by using the schema you created in the database. HCL OneTest Data generates the schema name as schema_<number>.
    Note: You must select this schema name as the schema for HCL OneTest Data to generate the test data.
  6. Select the schema type as Row and click Next.
  7. Provide the identification details of the new action, and then click OK.

    The new action is created and is listed under the JDBC connection.

Results

You have successfully generated the schema in HCL OneTest Data.

Important: If you want to generate schemas for other tables in the same database, then instead of creating a new connection, you must click New Action on the existing JDBC connection.

What to do next

You can provide the action name under the Identification dialog box, and then generate the test data in the database. See Inserting the generated test data in the database.