Content Comparison

• 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

NOTE: for the activities, ORACLE Database 11g Express Edition is used. By default, it creates a database called XE when installing, which will be used for all of the examples below.

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.

...

• Data Source (text box editor type) (type: string): the database name to connect to. In the screenshot above the default XE database is used. 
  
• 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 Oracle server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster Portal).
• Server Name (text box editor type) (type: string): the name or IP of the SQL Oracle Server to connect to. If Oracle is installed on the same server where the activity is executed, then the field can remain blank. This field is recommended to be used when accessing an Oracle database created on a different server. 
• Username (text box editor type) (type: string): the the username of the SQL Oracle Server Administrator. It can be used any user created for the database (for example, the user(s) used when creating a Workspace in Oracle Application Express).

...

• Connection (type: object): outputs a SQL an OracleL connection. The Output of this activity should be used as input for all Connection parameters used for activities placed under OracleSQL category.

...

• Backup Path (text box editor type) (type: string): the path where the backup file will be created. The path can be manually written or selected by clicking the  button.
• BackupName (text box editor type) (type: string): the name of the backup file that will be created. Should be a .dmp extension file (E.G. XE.dmp, where XE is the name of the current database).
• exp.exe Path (text box editor type) (type: string): the the path of exp.exe (the Oracle export utility), or select it with the File Browser. By default, exp.exe is located in C:\oraclexe\app\oracle\product\11.2.0\server\bin\ folder, where C:\oraclexe\app\oracle\product\11.2.0\server\ is also the value for the ORACLE_HOME environment variable.
• Password (password editor type) (type: string): the password for the provided username. The password should be the same as the one given for the Connect to OracleSQL activity. The Backup Database activity creates a connection string based on the user provided at the connection activity and the password provided in the backup activity.
• Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql Oracle server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster Portal).
• SID (text box editor type) (type: string): the Oracle SID (Oracle System Identifier, which is used to distinguish Oracle database instances). By default it will be set to XE, which is also the Oracle's default database name. 

...

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

Activity Parameters

...

This activity removes privileges for an user to a database table.

Activity Parameters

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

...

• .

...

...

• Backup File Path (text box editor type) (type: string): the path of the backup file or select it with the File Browser. The .sql dmp file path can be manually written or selected by clicking the  button. In this example the backup file has the same name as the database's.
• imp.exe Path (text box editor type) (type: string): the the path of imp.exe (the Oracle import utility), or select it with the File Browser. By default, imp.exe is located in C:\oraclexe\app\oracle\product\11.2.0\server\bin\ folder, where C:\oraclexe\app\oracle\product\11.2.0\server\ is also the value for the ORACLE_HOME environment variable.
• Password (password editor type) (type: string): the password for the provided username. The password should be the same as the one given for the Connect to OracleSQL activity. The Restore Database activity creates a connection string based on the user provided at the connection activity and the password provided in the restore activity.
• Password Binding (text box editor type) (type: string): bind to a variable containing the encrypted password for the sql Oracle server. (This parameter is used only when the user wants to send an encrypted password from outside the task, for example Flowster Portal).

...