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.
A DAS activity is typically used for direct integration with a third-party database without the need to write any code.
Using a Data access activity within a process, you can get, add, update, or delete database records.
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.