Content Comparison

...

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:

• Host Name (value selector list) Connection (text box editor type) (type: object): the connection object that was obtained as output from a Connect To OracleSQL activity.
• Table Name (text box editor type) (type: string): the hostname the database table that the user can connect fromrights will be granted on.
• Username for Access UserNameForAccess (text box editor type) (type: string): 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:

Image RemovedImage Added

Image RemovedImage Added

Backup Database

...

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) (type: string): the path where the backup file will be created.
• File Name BackupName (text box editor type) (type: string): the name of the backup file that will be created. Should be an .sql extension file (E.G. BackupFile.sql).
• OracleSQLDumpexp.exe Path (text box editor type) (type: string): the the path of the OracleSQLdumpexp.exe (the Oracle export utility), or select it with the File Browser.
• Password (password editor type) (type: string): the password for the provided username.
• Password Binding (text box editor type) (type: string): 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 Portal).

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

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

• Output (type: string): outputs the path of the backup file.

Delete Row(s) from 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) (type: string): the table name where the row(s) will be deleted.
• Where Statement (text box editor type) (type: string): the Where statement to filter the row(s) that will be deleted. For example: Column_name='Test'.
  
  

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) (type: string): 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) (type: string): the table name where the row(s) will be inserted.
• Values (text box editor type) (type: string): 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.

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:

Image RemovedImage Added

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

• Output Last ID (type: string): outputs the last row inserted ID.

Remove User Access from Database

...

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:

• Table Name (text box editor type) (type: string): the database table that the rights will be removed on.
• Username to be Removed (text box editor type) (type: string): the name of the user that will have denied 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:

Image RemovedImage Added

Restore Database

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

...

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) (type: string): the path of the backup file or select it with the File Browser. Should be an .sql extension file (E.G. C:\\BackupsFolder\BackupFile.sql).
• OracleSQLimp.exe Path (text box editor type) (type: string): the path of the OracleSQLimp.exe (the Oracle import tool), or select it with the File Browser.
• Password (password editor type) (type: string): the password for the provided username.
• Password Binding (text box editor type) (type: string): 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 Portal).
  

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.

...