Importing schemas into the Schema Canvas page

When you want to generate the test data or the Data Definition Language (DDL) statements by using single or multiple schemas, you must import schemas into the Schema Canvas page. You can import multiple schemas simultaneously.

Before you begin

You must have fabricated schemas in HCL® OneTest™ Data.

About this task

To import the schemas, you must select the type of schemas that you want to import. You can import either the JDBC-supported schemas or non-JDBC schemas into the Schema Canvas page. You can view the list of schemas under the Schemas tab of the Canvas Settings dialog. Under the Groups tab, you can view the list of all the group types of the schemas. You can also enter the text in the Search field to find the schemas or the group types that match with the characters of the search text.

The schemas or the group types that you select to import are listed under the Selected Schemas panel.

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 to select the schemas.
    The Canvas Settings dialog is displayed.
  5. Select any one of the following options in the Canvas Settings dialog to display the list of schemas:
    • JDBC: When you select JDBC, you can view only the list of JDBC-supported schemas. To import the JDBC schemas, go to Step 4.
    • Non-JDBC: When you select Non-JDBC, you can view only the list of non-JDBC schemas. To import the non-JDBC schemas, go to Step 5.
  6. For JDBC schemas: Select a schema by using any one of the following methods:
    • Use the Database tab:
      1. Click the Database tab.
      2. Select a schema.

        The group types within the selected schemas are selected.

        Notes:
        • You can also search for the schema by entering the name of the schema in the Search field.
        • Each JDBC schema includes only one group type.
        • The group types are selected automatically with the selection of schemas.
    • Use the Table tab:
      1. Click the Table tab.
      2. Select the group type.

        The group types along with their schemas are selected.

        Note: You can find only one group type in JDBC schemas.
    The selected schemas are displayed in the Selected Schemas panel.
    Notes:
    • If you select a child schema, then the parent schema is selected automatically.
    • If you select a child group, then the parent group of parent schema is selected automatically.
    • If you clear the selection of any group type of schema, then you can view the updated list of the selected schemas in the Selected Schemas panel.
  7. For Non-JDBC schemas: Select a schema by using any one of the following methods:
    • Use the Schema tab:
      1. Click the Schema tab.
      2. Select a schema.

        The group types within the selected schema are displayed.

        Note: You can also search for the schema by entering the name of the schema in the Search field.
      3. Select the group types of the selected schema that you want to import.
        Note: You can select multiple group types from a single schema.
    • Use the Group tab:
      1. Click the Group tab.
      2. Select the group types that you want to import.

        The group types along with their schemas are selected.

    The selected schemas are displayed in the Selected Schemas panel.
    Notes:
    • If you select a child schema, then the parent schema is selected automatically.
    • If you select a child group, then the parent group of the parent schema is selected automatically.
    • If you clear the selection of any group type of schema, then you can view the updated list of the selected schemas in the Selected Schemas panel.
  8. Click Set Canvas.
    The selected schemas are imported into the Schema Canvas page.
    Note: If you select multiple group types from the same schema and import that schema into the Schema Canvas page, then the structure of each group is represented separately on the Schema Canvas page.

Results

You have imported the non-JDBC schemas into the Schema Canvas page.

What to do next

You must select schemas from the Schema Canvas page before generating the DDL statements or the test data. See Selecting schemas.

You can also establish a new parent-child relationship among non-JDBC schemas. See Establishing a parent-child relationship within different schema groups.

After you import schemas into the Schema Canvas page, if you want to modify or remove the selection of schemas, then you must click the Modify canvas button on the Schema Canvas page. See Modifying the selection of imported schemas.