Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

Version 1 Next »

Activities

  • Connect to MySQL
  • Disconnect from MySQL
  • Add User Access to Database
  • Backup Database
  • Delete Row(s) from Table
  • Insert Row(s) into Table
  • Remove User Access from Database
  • Restore 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.

Activity Parameters

The Connect to MSSQL activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Authentication (combo box control): the authentication method. For SQL Authentication the Username and Password parameters are mandatory.For Windows authentication they are optional.
  • Database (text box editor type): the database name to connect to.
  • Instance (text box editor type): the instance name to connect to.
  • Password (password editor type): the password for the provided username.
  • Password Binding (text box editor type): bind to a variable containing the encrypted password for the sql server. (This parameter is used only when the user wants to send an encripted password from outside the task, for example Flowster User Portal).
  • Server Name (text box editor type): the name or IP of the SQL Server to connect to.
  • Username (text box editor type): the the username of the SQL Server Administrator.

The Read Only Output variable are the possible output values that the activity will provide:

  • Connection: 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.
 

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 Connect to MSSQL activity:



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:

Parameters:

  • Connection (text box editor type): 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:

Parameters:

  • CSV Roles (text box editor type): the database-level roles for the user access. Overrides the 'Database-level role' parameter. The values must be entered with the format: "Role1,Role2,Role3...".
  • Database - level Role (value selector list): the roles that will be added to the user. The roles will be selected from a list, after clicking the ... button. The list will display all possible roles that can be assigned to a SQL user.
  • Username for Access (text box editor type): the name of the user that will receive permissions.
 

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 Add User Access to Database activity:

 

 

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:

Parameters:

  • Backup Path (text box editor type): the path where the backup file will be created.
  • Media Name (text box editor type): the new media a media name. (E.g. 'C_SQLServerBackups').
  • Name (text box editor type): the name of the backup set. Names can have a maximum of 128 characters. (E.g. 'Full Backup of Database').
 

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 Backup Database activity:

 

 

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:

Parameters:

  • Table (text box editor type): the table name where the row(s) will be deleted.
  • Where Statement (text box editor type): the Where statement to filter the row(s) that will be deleted. For example: Column_name='Test'.

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 Delete Row(s) from Table activity:

 

 

Insert Row(s) into Table

This activity inserts Row(s) on a SQL Server database table.

Activity Parameters

The Insert Row(s) into Table activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Fields (text box editor type): the column headers that you want to be returned with the select command. If you enter more than one you should separate them with ','. For example: Name,Status.
  • Table (text box editor type): the table name where the row(s) will be inserted.
  • Values (text box editor type): the values for specified fields in Fields parameter. If you enter more than one you should separate them with ','. If you have more values each should be placed in the same order as you add the fields.For example: Test,1.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output Last ID: outputs the last row inserted ID.
 

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 Insert Row(s) into Table activity:

 

 

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:

Parameters:

  • CSV Roles (text box editor type): the database-level roles that will be removed from the user. Overrides the 'Database-level role' parameter. The values must be entered with the format: "Role1,Role2,Role3...".
  • Database - level Role (value selector list): the roles that will be deleted from the user. The roles will be selected from a list, after clicking the ... button. The list will display all possible roles that can be assigned to a SQL user.
  • Username for Access (text box editor type): the name of the user that will have the permissions revoked.
 

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 Add User Access to Database activity:

 

 

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:

Parameters:

  • Backup File Path (text box editor type): 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' ).
 

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:

 

 

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:

Parameters:

  • Query (text box editor type): the SQL query string. For example: CREATE Table.

The Read Only Output variable are the possible output values that the activity will provide:

  • Output: outputs a collection 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:

Select Row(s) from Table

This activity selects and returns Row(s) from a SQL Server database table.

Activity Parameters

The Select Row(s) from Table activity parameters can be provided by manual inserted values or via IN arguments or variables:

Parameters:

  • Distinct (combo box control): whether the returned values should be distinct or not.
  • Fields (text box editor type): 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.
  • 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:

  • No labels