Data access activity
Use a Data access (DAS) activity to permit the process to interact with a database.
You can access tables, views and stored procedures, construct queries within the Designer, and map data from the process onto the query. You can also get, add, update, or delete database records from the process.
A DAS activity is typically used for direct integration with a third-party database without the need to write any code.
Always encryptedcolumns in SQL Server 2016 and above.
For example, create a process variable, with the following settings:
ID = DBConnectionString
Type = String
Value = DSN=TotalAgility
The connection string is case sensitive.
You can whitelist a database connection string. If you clear, Allow all in the System settings, you can only use the whitelisted database connection strings. See Configure the server URLs and database connection strings.