...
- Connect to OracleSQL
- Disconnect from OracleSQL
- 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
- Export from Database
- Import into Database
Connect to OracleSQL
This activity connects to a OracleSQL Host. The Output of this activity should be used as input for all Connection parameters used for activities placed under OracleSQL category.
...
The Run Query activity parameters can be provided by manual inserted values or via IN arguments or variables:
Parameters:
- Query (text box editor type) (type: string): 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:
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: collection<collection<string>>): outputs a collection of returned rows.To use the elements of the collection, use ForEachFactory activity.
- Output Columns (type: int32): outputs the number of columns returned.
- Output Rows (type: int32): outputs the number of rows returned.
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:
- Distinct (combo box control) (type: string): whether the returned values should be distinct or not.
- 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 ','.Limit (text box editor type) (type: string): limit the number of results.
- Order By (text box editor type) (type: string): the column header that you want to result to be ordered by.
- Order by Direction (combo box control) (type: string): 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) (type: string): the table name on which to run the select.
- WHERE (text box editor type) (type: string): 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:
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: collection<collection<string>>): 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 (type: int32): outputs the number of columns returned.
- Output Rows (type: int32): outputs the number of rows returned.
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:
Parameters:
- Destination Path (combo box control) (type: string): the path where the file will be created.
- File Name (text box editor type) (type: string): the name of the XML file or CSV file that will be created. E.g. 'MyNewFile'.
- File Type (combo box control) (type: string): 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) (type: string): whether to overwrite the file if it already exists.
- Root Name (text box editor type) (type: string): the name of the root for the .xml file.
- Table Table Name (text box editor type) (type: string): the table(s) from where the export will be made (accepts multiple values separated by comma).
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:
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
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:
Parameters:
- File Type (combo box control) (type: string): 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) (type: string): whether the CSV file includes the header as a first row or not.
- Import File Path (text box editor type) (type: string): the path where the file will be selected from, or choose it with the file browser.
- Table (text box editor type) (type: string): 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.
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:
The Read Only Output variable are the possible output values that the activity will provide:
- Output (type: boolean): outputs True or False if the execution was successful or not.
