Striim 3.9.7 documentation

CREATE PROPERTYVARIABLE

CREATE PROPERTYVARIABLE <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 applications without sharing the cleartext with users.

The following will create a property variable common.orapass:

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.