Selecting multiple schemas

After you define the properties of schemas, you must select schemas and view the relationships among them to generate the test data for multiple schemas simultaneously.

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.
  3. Defined properties for the generated schemas. See Defining properties of schemas.

Procedure

  1. Select your project in Rational® Test Automation Server and navigate to the Data Fabrication page.
  2. Click Schema Integrity to select schemas.
    The Select Schemas dialog box is displayed.
  3. Click the field to view the list of schemas that are generated by using the JDBC connection.
  4. Select multiple schemas.
    Note: You can select a maximum of 10 schemas.
  5. Click Import to import the selected schemas into the Schema Integrity page.

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

    Note: You can use the scroll wheel or pinch-to-zoom option on the Schema Integrity page to view the structural view of all schemas and relationships.
  6. Verify the relationships among the selected schemas.
  7. Select schemas based on the following criteria:
    • If a schema does not have a relationship with any other schema on the Schema Integrity page, then you must select that schema manually. Otherwise, click Select All to select all schemas to generate the test data.
    • If a schema has a relationship with other schemas and is selected, then all the related schemas get 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.
    • If any of the selected schema is deleted from the workspace, then the view of the Schema Integrity page changes as the deleted schema is removed from the Schema Integrity page.

Results

You have successfully selected multiple schemas for the generation of test data.

What to do next

You can generate the test data for the selected schemas. See Generating test data for selected schemas.