Password Manager

Overview

In order to prevent storing passwords in open form, VX Suite comes with a built-in Password Manager. The Password Manager allows users to store combination of user name and password in encrypted form. The stored records can be used in any of the plugins that support fields of type “Password”.

List of plugins that support Password Manager:

  • SQL Client
  • SQL Procedures
  • SAP Routing
  • Any python-based plugins

There are two steps to use Password Manager:

  1. Add a new record to the password manager.
  2. Use the record in any of the supported plugins.

 

As an example, we will use password manager in the SQL Client plugin.

Step 1 - Add a new password record:

1. Open main menu and navigate to Tools -> Password Manager.

2. In the appeared Password Manager window, enter this information:

  • System – any name that can help you identify this record later. Only name will be visible at the plugin level. In our example we will name it SQL_DB1_SA.
  • User – username of a DB user that we will use to connect to the SQL DB. In our example the username is SA
  • Password – password for user SA.

3. Click Add.

4. The record should appear in the list.

Step 2: Use the newly created password record in the SQL Client plugin:

  1. Add SQL Client plugin to the canvas.
  2. Navigate to Settings.
  3. In the SQL Credentials dropdown select a record with system name that you created in step 1.
  4. Populate Connection string.
  5. Enter name of the Table that you want to work with.
  6. Select operation mode.
  7. Click Connect.

Note: The connection string supports both open (when username and password are entered in open form) and encrypted (when Password Manager is used and users can’t access or see password) form of credentials.

Example

Example of open form of the connection string:

Server=localhost\SQLEXPRESS;Database=velox_test_db;User ID=SA;Password=12345678;

Example of use of password manager:

Server=localhost\SQLEXPRESS;Database=velox_test_db;User ID={user};Password={password};

Variables {user} and {password} are used by the plugin to retrieve username and password in runtime from the password manager vault.

In this article