Creating a dataset by using a database query

When you use variable data that is contained in a database, you can create a database query to import the required data from a database and use the data that is present in the database query to create a dataset in HCL DevOps Test Hub (Test Hub).

Before you begin

You must have completed the following tasks:

Procedure

  1. Log in to Test Hub.

    The team space that contains your project is displayed.

  2. Click Active projects > My projects > project_name to open the project that contains the test assets.

    The Overview page of the project is displayed.

  3. Click Author > Data.

    The Data page and the Data navigator panel are displayed.

  4. Select the branch in the project repository from the Branch list.

    The assets and resources in the selected branch are displayed in the Data navigator panel.

  5. Perform any of the following actions:
    • Click the Open action menu icon in the Data navigator panel, and then click Dataset.
    • Click Add files in the right panel, and then click Dataset.

    The Edit branch dialog is displayed.

  6. Select your action to either select an existing Edit branch or create an Edit branch:
    • Perform the following steps to select an existing Edit branch:
      1. Select Use an existing edit branch.
      2. Select an Edit branch from the Select branch list if Edit branches already exist in the selected branch of the repository.
        Note: A warning message is displayed if the Edit branch, which you selected, is behind the source branch. To update the selected edit branch and maintain synchronization with the source branch, you can select the Update branch option when switching checkbox.
      3. Click Ok.
    • Perform the following steps to create the Edit branch:
      1. Select Create new edit branch.
      2. Enter a name for the Edit branch in the Branch Name field.
      3. Click Save.
  7. Create a folder, if you want to use a new folder to contain the resource by performing the following steps:
    1. Select the project or a logical folder in the Data navigator panel, right-click, and then click Folder.

      Alternatively, select the project or a logical folder in the Data navigator panel, click the Open action menu icon , and then click Folder.

      The Create new folder dialog is displayed.

    2. Enter a name for the folder.

      For example, enter MyFolder as the name of the folder.

    3. Click Create.

      The folder is created under the project and displayed in the Data navigator panel.

  8. Perform the following steps in the Create Dataset dialog:
    1. Enter a name for the Dataset.
    2. Select a folder in the Location field.
    3. Click Next.
    4. Select the Use a Database Query option from the Select source list.
    5. Select the database query to use from the Select Database Query list.
    6. Enter the number of rows in the Number of Rows field.
    7. Click Create.
      A message is displayed that confirms dataset is created.

    The dataset is displayed on the Data page. The dataset created is listed under the logical folder Datasets under the physical folder MyFolder that you created.

Results

You have created the dataset by using a database query in your project.

What to do next

You can perform the following tasks: