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 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
    Catalog

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

    Required
    Schema

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

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

    Optional
    Table

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

    Required
    Note: You can click the Advanced Properties icon to set the additional properties of the schema.
  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, and then generate the test data in the database. See Inserting the generated test data in the database.