› 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 Process 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.

  • The Data access activity only supports the "Transparent Data Encryption (TDE)" encryption option in SQL Server.
  • When configuring a Data access activity, you can select which database schema to use for retrieving database objects (tables, views, and stored procedures). This provides greater flexibility when working with databases that contain multiple schemas. Previously, the system would always use the default schema for the database user (typically dbo for SQL Server).

How to: Configure a Data access activity