› Workflow › Business processes › Design a basic process › Add an activity › Activity types › Common activities › Data access activity

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.

Data access activity does not support "Always encrypted" columns in SQL Server 2016 and above.

Prerequisites: Before using the Data access activity, create a process variable to hold the database connection string (see Create process variables.) For example, create a process variable, with the following settings:

  • ID = DBConnectionString

  • Type = String

  • Value = DSN=TotalAgility

A database connection string helps you connect with the required relational database. The string contains details about how to connect to the selected database, such as a data source, the user ID, and the login password.

The connection string is case-sensitive.

You can whitelist a database connection string. If you clear the Allow all in the System settings, you can only use the whitelisted database connection strings. See Configure the server URLs and database connection strings.

How to: Configure a Data access activity