Connect
AutomatR.OracleDB.Database.Connect
The "Connect" activity in AutomatR facilitates the connection to a specified Oracle database. Establishing a connection is a crucial step before executing any database-related operations. This activity provides options to configure the connection string and other parameters for secure and efficient database communication.
Properties
| Name | Description |
|---|---|
| Input | |
| Connection String | Specifies the connection string for connecting to the Oracle database. String variables containing the connection string. |
| Password | Provides a secure password required to connect to the Oracle database. String variables containing the secure password. |
| Optional | |
| Delay | Specifies the amount of time (in seconds) to wait before executing the "Connect" activity. This can be useful for handling synchronization issues. Integer variables containing the delay duration. Ex.: If the amount of time is 1000 milliseconds or 1 sec, i.e., 1. |
| Misc | |
| Display Name | Provides a customizable name for the activity displayed in the workflow. The display name enhances clarity and organization within the automation project. String variables containing the desired display name. |
| Output | |
| Connection | Outputs the result of the "Connect" activity, storing the OracleConnection variable. This variable can be used in further activities that require database communication. |
How to use:
- Drag and drop the "Connect" activity onto the workflow.
- Configure the properties by specifying the connection string, and optionally, the delay and password.
- Execute the workflow to establish a connection to the specified Oracle database.
- Use the resulting OracleConnection variable in subsequent database-related activities.
Note:
- Ensure that the "Connect" activity is used before performing any database operations to establish a connection.
- The connection string is a critical parameter, and it should be configured correctly to connect to the desired Oracle database.
Example: Consider an example where the "Connect" activity is used to establish a connection to an Oracle database:
Connect:
Connection String: "Data Source=OracleDB;User Id=myUser;Password=myPassword;"
Password: "securePassword"
Connection: oracleConnectionVariable
In this example, the "Connect" activity is configured with the necessary connection string, password, and outputs an OracleConnection variable named "oracleConnectionVariable" for further database operations.