Activities
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666
- 15120237666Connect to SQL
- Disconnect from SQL
- Add Role Access to Database
- Backup Database
- Delete Row(s) from Table
- Insert Row(s) into Table
- Remove Role Access from Database
- Import into Database
- Run Query
- Select Row(s) from Table
Connect to MSSQL
This activity connects to a Microsoft SQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under Microsoft SQL category.
...
NOTE: If during the execution of the workflow, the connection expires, the activity will attempt three times to automatically reconnect to Microsoft SQL host using the input credentials.
Activity Parameters
The Connect to MSSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
- Connection (type: object): outputs a SQL connection. The Output of this activity should be used as input for all Connection parameters used for activities placed under Microsoft SQL category.
Disconnect from MSSQL
This activity disconnects from a Microsoft SQL Host.
Activity Parameters
The Disconnect from MSSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
- Connection (text box editor type) (type: object): the output from a Connect to MSSQL activity.
Add User Access to Database
This activity adds privileges for an user to a database.
Activity Parameters
The Add User Access to Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
Execution: the activity will check if the user exists as a login on the SQL server and if found, will grant access on the connected database, for the given roles:
Backup Database
This activity creates a backup .bak file of a selected database.
Activity Parameters
The Backup Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
The backup file can be seen in the given location:
Delete Row(s) from Table
This activity deletes Row(s) from a SQL Server database table.
Activity Parameters
The Delete Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
Execution: the activity will delete all the rows from a table according to the given Where statement:
- the initial table content:
- the table content after deletion:
Insert Row into Table
This activity inserts Row on a SQL Server database table.
Activity Parameters
The Insert Row into Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
In the database, the row can be seen at the last position:
Remove User Access from Database
This activity removes privileges for an user to a database.
Activity Parameters
The Remove User Access from Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
Execution: the activity will check if the user exists as a login on the SQL server and if found and if it already have assigned rights to the database where the activity is connected to. If the user is found and has rights over the database, the activity will revoke access on the connected database, for the given roles:
Restore Database
This activity restores a Database from a backup .bak file.
Activity Parameters
The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
- Backup File Path (text box editor type) (type: string): the path of the backup file or select it with the File Browser. The .bak file path can be manually written or selected by clicking the
button. In this example the backup file has the same name as the database's. - Check File Exists (text box editor type) (type: combobox): select True if the backup file should be checked for existence, otherwise select False. By default the True value will be selected. The False option can be selected for situations where the user doesn't have rights for checking the folder, but it can create the restore.
- Timeout (text box editor) (type: Int32): the time in seconds to wait for the backup operation to execute. The default value in 30 seconds.
Run query
This activity runs a query on a SQL Server database.
Activity Parameters
The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:
...
Execution: In the Tracking Data there can be seen the returned results:
The same result can be seen when executing the same SQL Select query from SQL Management Studio:
Select Row(s) from Table
This activity selects and returns Row(s) from a SQL Server database table. The example below displays a classic select query: select all data from a given table.
Activity Parameters
The Select Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
...