Creating a Data definition by importing fields from a database query

You can create Data definition to generate a random test data that is required to run a test in HCL DevOps Test Hub (Test Hub) using the specific database fields.

Before you begin

You must have completed the following tasks:

Ensured that you are assigned a role as a Project Owner or Tester in the project. See Managing access to the server projects.
Read information about using Data definitions to fabricate test data. See Overview of data fabrication.
Created a project in your team space in Test Hub. See Adding a project.
Added the remote Git repository that contains the test resources to the project. See Adding repositories to a server project.
Created at least one database query. See Creating a database query.

About this task

You must first create a database query and then create a Data definition using the database query to import the specific fields from the database query. After you import fields to the Data definition, you can edit the Data definition and add generators for the specific fields before you generate the test data.

Procedure

Log in to Test Hub.

The team space that contains your project is displayed.
Click Active projects > My projects > project_name to open the project that contains the test assets.

The Overview page of the project is displayed.
Click Author > Data.

The Data page and the Data navigator panel are displayed.
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.
Perform any of the following actions:
- Click the Open action menu icon in the Data navigator, and then click Data definition.
- Click Add files in the right panel, and then click Data definition.
The Edit branch dialog is displayed.
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 an Edit branch from the Select branch list if Edit branches already exist in the selected branch of the repository.
  2. Click Ok.
- Perform the following steps to create the Edit branch:
  1. Select Create new branch.
  2. Enter a name for the Edit branch.
  3. Click Save.
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.
Perform the following actions in the Create Data Definition dialog:
1. Enter a name for the Data definition.
2. Add a description of the Data definition in the Description field.
3. Select the folder in the Location field to store the Data definition.
4. Click Next.
5. Select the Import fields from a database query option from the Select source list.
6. Select the required database query file in your project, and then click Create.
  A message is displayed that confirms Data definition is created.
The new Data definition opens in the Data page in the editing mode. The columns in the database query are added as the fields of the new Data definition but no generators are added. The Data definition created is listed under the logical folder Data definitions under the physical folder MyFolder that you created.

Results

You have created a Data definition in your project by importing fields from a database query.

What to do next

You can perform the following tasks:

Add basic generators with their default settings to the Data definition. You can then save and publish the Data definition. See Saving a Data definition by adding basic generators with their default settings.
Add basic generators to the Data definition, and then modify the configuration of the generators. You can then save and publish the Data definition. See Saving a Data definition by adding basic generators with their modified settings.