Decrypting a dataset column

To view the content of an encrypted dataset, you can decrypt the dataset column. Removing encryption from a dataset revokes the protection offered to the test data.

Before you begin

You must have created at least one dataset and encrypted the dataset with an encryption key. See Creating a dataset and Encrypting a dataset column.

Procedure

  1. Log in to Rational® Test Automation Server if you are not already logged in.
  2. Open a project from the team space.
  3. Go to Author > Datasets, and then select the Branch from the list to find the dataset that you want to decrypt.
  4. Click the Edit icon edit_icon from the Actions column of the dataset.

    Based on the Branch that you selected, the following events occur:

    • The Edit Branch window is displayed if you selected other than the edit branch.

    • The dataset opens in the CSV Editor in a web browser if you selected the edit branch.

  5. Perform one of the steps described in the following table to select or create the edit branch:

    Step description

    Step no

    To select the edit branch

    Perform 5.a

    To create the edit branch

    Perform 5.b
    1. Perform the following steps to select the edit branch:
      1. Choose the edit branch from the Select branch drop-down list if the edit branches are already existing.

      2. Click Ok.

    2. Perform the following steps to create the edit branch:
      1. Select Create new branch.

      2. Provide a name for the edit branch.

      3. Click Save.

  6. Right-click encrypted cells that display the contents with asterisks, and then select Decrypt column data.
    The Decrypt Column window is displayed.
  7. Enter the encryption key that you used to encrypt the data in the column in the Encryption Key field.
  8. Click Decrypt Column.
    Asterisks are replaced with the actual data in the decrypted column.

Results

The encryption is removed from the selected column in the dataset. When you run a test that uses a dataset that contains decrypted data, the variable data is substituted for the original data in the recorded test without prompting for the encryption.

What to do next

You can publish the dataset to the Git repository so that other members of the project can use the dataset. See Publishing a dataset.