SQL settings: Value from and Connection string

SQL settings

The SQL settings section allows you to configure database connection string and query. The following options are available:

Below, see detailed description for Value from and Connection string options. For details on Query and Rollback query options, please see this page.

Value from #

SQL settings > Value from

This option determines how to resolve placeholder expressions and dynamic parameter values.

Source (default): This option resolves placeholders and dynamic parameter values from the trigger source of the rule.
Vault search: This option resolves placeholders and dynamic parameters using the results from a vault search configured as part of this rule.
Specify: This option resolves placeholders and dynamic parameters from an explicitly specified vault search from the Set properties on configuration.

Connection string #

SQL settings > Connection string

The connection string defines how the application connects to the SQL database. When expanded, the following fields are available by default for configuring the connection string: Database, Single line connection string, Value, and Use secure password. Example:

Data Source=[SERVER_NAME];Initial Catalog=[DATABASE_NAME];Persist Security Info=True;User ID=[USER];Password=[PASS]

Database #

SQL settings > Connection string > Database

Specifies the type of SQL database you wish to connect to. The available options are:

SQL Server (default): Select this option to connect to a Microsoft SQL Server database.
Oracle: Select this option to connect to an Oracle database.
MySQL: Select this option to connect to a MySQL database.
PostgreSQL: Select this option to connect to a PostgreSQL database.

Single line connection string #

SQL settings > Connection string > Database: SqlServer > Single line connection string

Displayed only when Database is SqlServer.

Determines whether the entire database connection string is input as a single line or configured through individual fields for each connection parameter (Data Source, Initial Catalog, etc.).

Yes (default): Select this option to enter the entire connection string in a single line.
No: Select this option if you want to configure each connection parameter separately. When this option is chosen, additional fields become available for separate configuration: Data Source, Initial Catalog, Persist Security Info, User ID, and Password.

Value #

SQL settings > Connection string > Single line connection string: Yes > Value

Displayed only when Single line connection string is Yes.

Use this field to enter database connection string. Example:

Data Source=[SERVER_NAME];Initial Catalog=[DATABASE_NAME];Persist Security Info=True;User ID=[USER];Password=[PASS]

Use secure password #

SQL settings > Connection string > Single line connection string: Yes > Use secure password

Displayed only when Single line connection string is Yes.

This option allows you to set a password to use in the connection string. Any password value specified in connection string above will be overridden, ensuring that sensitive information like passwords are not exposed in plain text. Choose from the following options:

No (default): The password included in the connection string (if any) will be used as-is.
Yes: When this option is selected, the Password field appears. This field allows you to securely input a password, which will override any password value specified in the connection string above.