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.
See also: