Versions Compared

Version Old Version 1 New Version 2
Changes made by

Former user

Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Activities

 

Connect to

...

MySQL

This activity connects to a Microsoft SQL MySQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under Microsoft SQL MySQL category.

Activity Parameters

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

Image RemovedImage Added

Parameters:

...

  • 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 encrypted 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.

...

  • 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 MySQL 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 MSSQLMySQL activity:

Image RemovedImage Added



Disconnect from

...

MySQL

This activity disconnects from a Microsoft SQL MySQL Host.

Activity Parameters

The Disconnect from MSSQL MySQL activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

  • Connection (text box editor type): the output from a Connect to MSSQL MySQL activity.

 

Add User Access to Database

...

The Add User Access to Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

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 (Host Name (value selector list): the roles hostname 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.can connect from.
  • Username for Access (text box editor type): the name of the user that will receive permissions.
 

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

  • Output: outputs True or False if the execution was successful or not.

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:

Image Added

 

Image Removed 

 

 

Backup Database

This activity creates a backup .bak file of a an .sql file backup for the selected database.

Activity Parameters

The Backup Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

  • Backup Path (text box editor type): the path where the backup file will be created.
  • Media File Name (text box editor type): the new media a media name. (E.g. 'C_SQLServerBackups').Name the name of the backup file that will be created. Should be an .sql extension file (E.G. BackupFile.sql).
  • MySQLDump.exe Path (text box editor type): the name of the backup set. Names can have a maximum of 128 characters. (E.g. 'Full Backup of Database') the the path of the mysqldump.exe, or select it with the File Browser.
  • 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 encrypted password from outside the task, for example Flowster User Portal).

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

  • Output: outputs the path of the backup file.
 

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:

Image RemovedImage Added



 

 

Delete Row(s) from Table

This activity deletes Row(s) from a SQL Server database table.

...

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

Image RemovedImage Added

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:

Image RemovedImage Added

 

 

Insert Row(s) into Table

...

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

Image RemovedImage Added

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 Remove User Access from Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

...

  • CSV Roles Username to be Removed (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.

...

  • the name of the user that will have denied permissions.
 

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

  • Output: outputs True or False if the execution was successful or not.

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:

Image RemovedImage Added

 

 

Restore Database

This activity restores a Database from a backup .bak sql file.

Activity Parameters

The Restore Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image RemovedImage Added

Parameters:

...

  • Backup File Path (text box editor type): the path the path of the backup file or select it with the File Browser. Should be a an .bak sql extension file (E.G '. C:\\BackupsFolder\BackupFile.bak' ).

...

  • .sql).
  • MySQl.exe Path (text box editor type): the path of the mysql.exe, or select it with the File Browser.
  • 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 encrypted password from outside the task, for example Flowster User Portal).
 

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

  • Output: outputs True or False if the execution was successful or not.

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:

Image RemovedImage Added

 

 

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:

Image RemovedImage Added

Parameters:

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

...

 

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:

Image RemovedImage Added



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:

Image RemovedImage Added

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.

...

 

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:

 

 

Export from Database

This activity exports data from a Database into an XML or a CSV file.

Activity Parameters

The Export from Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Added

Parameters:

  • Destination Path (combo box control): the path where the file will be created.
  • File Name (text box editor type): the name of the XML file or CSV file that will be created. E.g. 'MyNewFile'.
  • File Type (combo box control): the type of the file that will be created. For each of them a different set of parameters will be displayed.
  • Overwrite (combo box control): whether to overwrite the file if it already exists.
  • Root Name (text box editor type): the name of the root for the .xml file.
  • Table (text box editor type): the table(s) from where the export will be made (accepts multiple values separated by comma).

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

  • Output: outputs True or False if the execution was successful or not.
 

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 Export from Database activity:

Image Added

 

 

Import into Database

This activity imports data into a Database from an XML or a CSV file.

Activity Parameters

The Import into Database activity parameters can be provided by manual inserted values or via IN arguments or variables:

Image Added

Parameters:

  • File Type (combo box control): the type of the file that will be imported from. For each of them a different set of parameters will be displayed.
  • First Row Header (combo box control): whether the CSV file includes the header as a first row or not.
  • Import File Path (text box editor type): the path where the file will be selected from, or choose it with the file browser.
  • Table (text box editor type): the table name where the file will be imported. If left empty it will take the 'Name' of the CSV File or the 'Root Name' from the XML File.

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

  • Output: outputs True or False if the execution was successful or not.
 

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 Import into Database activity:

Image Added