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 add, display, update, or delete database records. See Configure a Data Access activity.
Important Before using the Data Access activity, create a process variable to
hold the database connection string. 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.
For example, create a process variable, with the following settings:
ID = DBConnectionString
Type = String
Value = DSN=TotalAgility