SQL Database Activities only work with SQL-Authentication.
SQL specific parameters that are identical in every SQL activity:
- Server -> SQL Server (possibly with a path)
- Database -> the used database
- Table -> table in the previously selected database
- User -> login name of a user who has access to the table in the database
- Password -> password of the user
The SQL Database Activities are:
- Delete Row from Database
- Insert Row into Database
- Select Value from Database
- Update Item in Database
Delete Row from Database
With this activity, you can delete a row from a table in a database. In the Condition tab, a condition specifies which entries will be deleted. Be careful to enclose string values on the right side with simple quotation marks, but not the column name.
Insert Row into Database
With this activity, you can insert a row into a database. In the Values tab, column and value pairs can be added. The values can either be static or dynamic through workflow variables or business entity links. Be careful to enclose string values on the right side with simple quotation marks, but not the column name.
Select Value from Database
This activity is used to select a value from a database. The column containing the value which should be selected has to be specified in the wizard. The condition tab can be used to filter the results. The first selected value will be returned as output. Be careful to enclose string values on the right side with simple quotation marks, but not the column name.
Update Item in Database
This activity is used to update an entry in a database. In the Condition tab, a condition specifies which entries will be updated. The columns which will be updated are defined in the values tab. Be careful to enclose string values on the right side with simple quotation marks, but not the column name.
