Microsoft SQL

Activities

Connect To SQL

This activity connects to a SQL server.

Insert Row(s) Into Table

This activity inserts rows into a specified table. The user must have rights to insert rows in the desired table.

Delete Row(s) From Table

This activity deletes rows from a specified table. The user must have rights to delete rows from the desired table.

Run Query

This activity runs a SQL query on a SQL database. For example: Create table query or Alter table query.

Select Row(s) From Table

This activity selects row(s) from a specified table based on a specified condition(WHERE statement). It returns a collection of rows together with their fields(table columns) and values.

Disconnect From SQL

This activity disconnects from the SQL server. 

Activities Parameters

Connect To SQL

The Database, Instance, ServerName and Username parameters may be given by the user via IN arguments.
The Password Binding parameter has no default value because its value must be given encrypted when run outside the Design Studio (for example Admin Portal).
The Password parameter is a Password editor type. When clicked, the Password editor opens and the user may specifiy the desired password. 
 
 
The output returned by this activity is stored in variable Connection:

Select Row(s) From Table

The input parameter Connection takes the value stored in the variable Connection, which contains the result of Connection To SQL activity.
The Fields, Limit, OrderBy, Table and Where parameters may be given by the user via IN arguments. 
 
 
 
 
The output returned by this activity is stored in defined variables:

Insert Row(s) Into Table

The input parameter Connection takes the value stored in the variable Connection, which contains the result of Connection To SQL activity.
The rest of the parameters are given by the user via IN arguments:

 
 
 
The output returned by this activity is stored in the defined variable Insert_output.

Delete Row From Table

The input parameter Connection takes the value stored in the variable Connection, which contains the result of Connection To SQL activity.
The rest of the parameters are given by the user via IN arguments:

 
 

Run Query

The input parameter Connection takes the value stored in the variable Connection, which contains the result of Connection To SQL activity.
The rest of the parameters are given by the user via IN arguments: 
 
 
The output returned by this activity is stored in the defined variables:

Disconnect From SQL

The input parameter Connection takes the value stored in the variable Connection, which contains the result of Connection To SQL activity. 

On Execution Workflow

Execution Result: