Selecting schemas

After you import schemas into Schema Canvas, you must select schemas to view the relationships among them, generate the Data Definition Language (DDL) statements, or generate the test data for multiple schemas simultaneously.

Before you begin

You must have completed the following tasks:
  1. Created a project.
  2. Fabricated the JDBC-supported or non-JDBC schemas in HCL® OneTest™ Data:
  3. Defined properties for the generated schemas. See Defining properties of schemas.
  4. Imported schemas into the Schema Canvas page. See Importing schemas into the Schema Canvas page.

About this task

You can view all the imported schemas on the Schema Canvas page. When you select a schema on the Schema Canvas page, the other schemas are also selected if they are related to each other based on referential integrity. Otherwise, you can select Select All to select all the schemas that are imported on the Schema Canvas.

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. Click Schema Canvas.
    The Schema Canvas page is displayed.

    You can view the structural view of all the imported schemas with their relationships with each other.

    Notes:
    • You can use the scroll wheel or pinch-to-zoom option on the Schema Canvas page to view the structural view of all schemas and relationships.
    • When you rename or delete any schema or item types that are imported to the Schema Canvas page, the relationships are altered and this alteration results in the failure of a generation of test data.
  5. Verify the relationships among the selected schemas.
  6. Select schemas based on the following criteria:
    • If a schema does not have a relationship with any other schema on the Schema Canvas page, then you must select that schema manually. Otherwise, select Select All to select all schemas to generate the test data.
    • If a schema has a relationship with other schemas and if it is selected, then all the related schemas are selected automatically.
    Notes:
    • You cannot select schemas that belong to different JDBC connections.
    • You can use Modify canvas to add or remove the selected schemas.
    • You must not select schemas with nested group types for the generation of DDL statements.
    • If any of the selected schemas is deleted from the workspace, then the view of the Schema Canvas page changes because the deleted schema is removed from the Schema Canvas page.

Results

You have selected multiple schemas.

What to do next

You can perform any one of the following tasks: