Duplicating a database connection

When you want create a similar database connection with different user credentials, to create the similar database connection and restrict or unrestricted it, or to create a similar database connection by encrypting the data exchanged between HCL DevOps Test Hub (Test Hub) and database, you can create a new database connection using an existing database connection.

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.
Added at least one database connection. See Adding a database connection.
Ensured that you have a valid URL and credentials for the database that you want to add or duplicate in a Test Hub project.

About this task

You can duplicate database connection and create a new one in the following scenarios:

Creating the same database connection with or without restricting the access to other members of the project.
Adding the same database connection to a different classification which consists of different datasets, secrets and have access to different group of people.
Adding the same database with different user credentials.

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 Infrastructure > Database Connections.
The Database Connections page is displayed.
Click the Duplicate icon inline with the database connection that you want to duplicate.

The Duplicate connection dialog is displayed.

The value in the URL field, and the selections in the Driver field and the Restrict access using Classifications checkbox are auto-populated with the current values and selections in the database connection that you duplicate.
Perform the following actions in the Details tab:
1. Enter a different name for the database connection in the Name field.
2. Enter the username for the database in the Username field.
3. Enter the password for the database in the Password field.
4. Select the Restrict access using Classifications checkbox if you want to restrict other members of the project from using this database connection.
  
  Later you can grant access to the required members by adding the connection to a classification.
  
  Note: The option, Restrict access using Classifications is not select. This is the default selection.
Perform the following steps to change or add the SSL certificate for encrypting the data exchanged through the database.
1. Click the SSL tab.
2. Click the x icon to remove the existing Java Keystore file.
3. Click Select File and browse to the location on your computer where you have the Java Keystore File.
4. Select the file, and then click Open.
  The selected file name is displayed.
5. Enter the password for the Java Keystore File in the Password field.
Click Test to test the connection with the database.
A message is displayed that confirms the connection with database.
Click Save to save the database connection.

A message is displayed that confirms database connection is added and the new database connection created by using the existing database connection is displayed on the Database Connections page.

Results

You have created a new database connection by using the existing database connection in your project.