...
The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Host Backup File Path (text box editor type): the FTP host.
- Password combo box control): the password for the provided username.
- Password Binding (text box editor type): bind to a variable containing the encrypted password. (This parameter is used only when the user wants to send an encripted password from outside the task, for example Flowster User Portal).
- Username (text box editor type): the username for authentication; if left empty, windows session credentials are used.
The Read Only Output variable are the possible output values that the activity will provide:
- Connection: outputs a FTP connection. The output of this activity should be used as Input for all Connection parameters used for all activities placed under FTP categorythe path of the backup file or select it with the File Browser. Should be a .bak extension file (E.G 'C:\BackupsFolder\BackupFile.bak' ).
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Restore Database activity:
Input Parameters
| Name | Description | Type | Category |
|---|---|---|---|
| session | SQL Host connection. The Output from Connect to SQL activity should be used as Input here | System.Object | Parameters |
| FilePath | Enter the path of the backup file or select it with the File Browser. Should be a .bak extension file (E.G 'C:\BackupsFolder\BackupFile.bak' ) | System.String | Parameters |
Run query
This activity runs a query on a SQL Server database.
...
The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Host Query (text box editor type): the FTP host.
- Password combo box control): the password for the provided username.
- Password Binding (text box editor type): bind to a variable containing the encrypted password. (This parameter is used only when the user wants to send an encripted password from outside the task, for example Flowster User Portal).
- Username (text box editor type): the username for authentication; if left empty, windows session credentials are usedthe SQL query string. For example: CREATE Table.
The Read Only Output variable are the possible output values that the activity will provide:
- ConnectionOutput: outputs a FTP connection. The output of this activity should be used as Input for all Connection parameters used for all activities placed under FTP categorycollection of returned rows.To use the elements of the collection, use ForEachFactory activity.
- Output Columns: outputs the number of columns returned.
- Output Rows: outputs the number of rows returned.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Run Query activity:
Input Parameters
| Name | Description | Type | Category |
|---|---|---|---|
| session | SQL Host connection. The Output from Connect to SQL activity should be used as Input here | System.Object | Parameters |
| query | Enter the SQL query string. For example: CREATE Table | System.String | Parameters |
Output Parameters
| Name | Description | Type | Category |
|---|---|---|---|
| Output | Outputs a collection of returned rows.To use the elements of the collection, use ForEachFactory activity | System.Collections.ObjectModel.Collection`1 [System.Collections.ObjectModel.Collection`1 [System.String]] | Read-Only Output |
| OutputRows | Outputs the number of rows returned | System.Int32 | Read-Only Output |
| OutputColumns | Outputs the number of columns returned | System.Int32 | Read-Only Output |
Select Row(s) from Table
...
The Select Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Host (text box editor type): the FTP host.
- Password Distinct (combo box control): the password for the provided username.Password Binding whether the returned values should be distinct or not.
- Fields (text box editor type): bind to a variable containing the encrypted password. (This parameter is used only when the user wants to send an encripted password from outside the task, for example Flowster User Portal).
- Username (text box editor type): the username for authentication; if left empty, windows session credentials are used.
The Read Only Output variable are the possible output values that the activity will provide:
- Connection: outputs a FTP connection. The output of this activity should be used as Input for all Connection parameters used for all activities placed under FTP category.
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Select Row(s) from Table activity:
Input Parameters
...
- the column headers that you want to be returned with the select command. If you enter more than one you should separate them with ','.
- Limit (text box editor type): limit the number of results.
- Order By (text box editor type): the column header that you want to result to be ordered by
...
- .
...
- Order by Direction (combo box control): choose to order the resulted rows in ASC or DESC direction. It will be ignored if Order By is not set
...
- .
...
Output Parameters
...
- Table (text box editor type): the table name on which to run the select.
- WHERE (text box editor type): the Where statement. For example: ID>2 where ID is a column header.
The Read Only Output variable are the possible output values that the activity will provide:
- Output: outputs a collection of collections of strings containing the selected rows.To use the elements of the collection, use Get Element From Collection activity
...
- .
...
...
- Output Columns: outputs the number of columns returned
...
- .
...
...
- Output Rows: outputs the number of rows returned
...
- .
As mentioned above, the values for all the required parameters can be provided by IN arguments or variables. Below is an example of predefined arguments, ready to be used by the Select Row(s) from Table activity:
