Creating a schema by using a database connection

Edit online

When your tests require data that reflects existing database models, you can create a schema by connecting to an existing database. You can retrieve and manage live data structures that help your test data reflect production schema complexity and relationships more accurately.

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 the schema. See Management of schemas.
Created a project in your team space in Test Hub. See Creating a project.
Added the remote Git repository that contains the test resources to the project. See Adding repositories to a server project.

Created an application in your project. See Creating an application.
Added a database connection in your project. See Adding a database connection.

Procedure

Log in to Test Hub.
The Projects page of the initial team space is displayed.
Click 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 Add files and select Schema on the Test Editor page.
- Click the Action Menu icon and select Schema.
- Right-click the application in the data navigator panel, select New > Schema.
The Edit Branch dialog is displayed.

If the Edit branch dialog is not displayed, then go to step 7.
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 for your 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.
The Create a Schema dialog is displayed.
In Step 1 of the Create a Schema dialog, perform the following tasks:
1. Select the Application for which you want to create a schema.
2. Select Location from the drop-down list to store the schema.
3. Type a unique Name for the schema.
4. Type a brief description of the schema in the Description field.
5. Click Next to proceed to Step 2.
In Step 2 of the Create a Schema dialog, perform the following tasks:
1. Select Source as Select a Database Connection.
2. Select a database from the Select a Database Connection list.
3. Click Create.

Results

You have created a schema by using an existing database connection.