Connect
AutomatR.MySQLDataBase.Database.Connect
The "Connect" activity in AutomatR facilitates the connection to a MySQL database. This activity is crucial for establishing a connection to the specified database, allowing subsequent activities to interact with the database.
Properties
| Name | Description |
|---|---|
| Input | |
| DataBase Name | Specifies the name of the database you want to connect with. String variables containing the database name. |
| Password | Provide a password for the username with which you would like to connect to the database. SecureString variables containing the password. |
| Port | Specify the port number for the database you want to connect with. Integer variables containing the port number. |
| Source | Specify a source path. String variables containing the source path. |
| User Name | Provide a username for the database. String variables containing the username. |
| 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. |
| 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. |
| Output | |
| Connection | The result will be stored in a MySQLConnection variable, which can be used for further activities. Variables of type MySqlConnection to store the database connection. |
How to use:
- Drag and drop the "Connect" activity onto the workflow.
- Configure the properties by specifying the database name, password, port, source, and username for the database connection.
- Optionally, configure the delay for synchronization purposes.
- Execute the workflow to establish a connection to the specified MySQL database.
Example: Consider an example where the "Connect" activity is used to connect to a MySQL database:
Connect:
Source: "localhost"
Port: 3306
DataBase Name: "sampledb"
User Name: "admin"
Password: SecureStringVariable
Connection: MySqlDbConnection
In this example, the activity connects to the "sampledb" MySQL database on the "localhost" server using the provided credentials. The resulting database connection is stored in the variable "MySqlDbConnection" for further use in the workflow.