Defining properties of schemas

After you generate the schema from the configured database in HCL® OneTest Data, you must define the required properties for all schemas.

Before you begin

You must have completed the following tasks:
  1. Created a project.
  2. Generated schemas in HCL® OneTest Data by using a JDBC connection. See Generating a schema in HCL OneTest Data.

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. Select the generated schema from the Schemas tab.

    For example, schema_<number>

  5. Click the Menu icon of the group type of the schema and select Structure.

    You can view the list of all item types associated with the selected group type in the structural view of the schema.

  6. Click the Menu icon of all item types in the Structure dialog box to set the following properties:
    1. Click Set Required to get at least one occurrence of the item type in the generated test data, and then click Save.
    2. Select item types with the values of Item Subclass as Number and Presentation as Integer.
    3. Click Properties for the selected item types and perform the following steps for Item Properties:
      1. Set the value of Min size (digits) and Max size (digits) between 1-9, where the value for Min size (digits) should be less than or equal to Max size (digits).

        For example, you can set the Min size (digits) as 1 and the Max size (digits) as 9.

    Note: The values of both the Min size (digits) and Max size (digits) properties for item types that act as a primary key and foreign key must be the same.
  7. Save the changes.
    You must repeat steps 2 through step 5 to set the properties for all schemas.

Results

You have defined the properties for all schemas.

What to do next

You can click Schema Integrity to select the defined and structured schemas that you want to use to generate the test data. See Selecting multiple schemas.