SQL Activities category contains categories executing operations directly on a database.

Create Row Adapter

The activity is used for creating SqlRecordAdapter object from IDataReader object, which allows for an easier analysis of an SQL query results.

Suppress Transaction Scope

After using this activity, all operations within it are executed beyond a transaction, which means that in case an execution error occurs, a current object status will be saved in a database and no changes will be undone.

Execute SQL

The activity allows for executing an SQL query on a company database from which a process is started. Input parameters can be transferred to such query and data can be retrieved to variables with the use of output parameters.

Execute in Transaction

Using of this activity opens an internal transaction in an already existing transaction of a BPM process. Changes introduced by means of the activity to a database will be canceled in case and error (exception) occurs during its execution.

Execute SQL Query

This activity allows for executing an SQL query analogic to the Execute SQL. Additionally, for each returned row, with the use of a query, it is possible to define specific transactions.

Besides the activities described for Execute SQL Query, it allows for creating a list of objects of a given type and adding to it objects on the basis of rows which are results of an SQL query.