Skip to main content

CREATE PROPERTYVARIABLE

CREATE PROPERTYVARIABLE [<namespace>.]<name>="<value>";

Property variables allow you to store values for adapter properties in an encrypted form, so they may be used as passwords and tokens in applications without sharing the cleartext with users.

The following will create a property variable common.dbpass:

USE common;
CREATE PROPERTYVARIABLE dbpass="12345678";

You could then use that in an application as follows:

CREATE CACHE ConfiguredRacks USING DatabaseReader (
  Username:'striim',
  Password:'$common.dbpass'...

You may omit the namespace if the property variable is in the same namespace as the application:

CREATE CACHE ConfiguredRacks USING DatabaseReader (
  Username:'striim',
  Password:'$dbpass'...

Note

If a property variable has the same name as an environment variable, Striim will use the value of the property variable.

To change the value of an existing property variable, use CREATE OR REPLACE:

CREATE OR REPLACE PROPERTYVARIABLE dbpass="abcdefgh";

Note

After changing the value of a property variable, any Striim applications that use it must be restarted to update the value.