Manage Variables

Variables are placeholders used to hold and maintain certain values. If you may not know some of the values that you might want to use within an XMPro Object, such as credentials or passwords, you can use Variables where the real value can be substituted later.

It is recommended that you read the article listed below to improve your understanding of Variables.

• Variable

Adding a new Variable

Variables can be added via the Variables page before being used in any of the Data Streams or Applications.

1. Click on the Variables page from the left-hand menu.

2. Click on Add.

3. Enter the details of the new Variable.

4. Choose if the value is encrypted. This determines whether or not the value can be seen by the user.

5. Click on Save and Close.

Using Variables

Variables can be used in Data Streams or Applications to authenticate users or to access certain data sources. Consider having the following agents in a stream:

• Azure SQL Listener

When the Azure SQL Listener is configured the user needs to enter the server details and password in order to access the available tables and columns. In this case, variables that already store the passwords and credentials can be used in the input fields. For example:

1. Add an SQL Listener from the list of Agents.

2. Click on Configure.

3. Select the Server and user details from the list of variables (ensure that the 'Use Connection Variables' option is selected).

4. Select the correct encrypted password variable for the server.

5. If selected correctly, tables and columns can now be accessed.

Removing Variables

Single Variable

To remove a single variable, follow the steps below:

1. Open the Variables page from the left-hand menu.

2. Select the variable from the list.

3. Click Delete.

4. Confirm that you would like to delete the variable.

Multiple Variables

To remove multiple variables, follow the steps below:

1. Open the Variables page from the left-hand menu.

2. Click Select.

3. Select the variables from the list.

4. Click Delete.

5. Confirm that you would like to delete the selected variables.

Overriding Variables

In addition to creating Local Variables, you can override the variable value with one stored in System Environment Variables.

This applies to Stream Hosts only. See How to Override Variables for more information.