Open Connection Activity
The Open Connection activity enables the establishment of a secure connection to a target database server. It initializes a connection variable that allows subsequent database activities to interact with the specified data source.
| Field | Description | Requirement |
|---|---|---|
| Connection name | Defines the unique identifier used as the variable name for the database connection. | Required |
| Database name | Specifies the name of the database as previously configured in the RPA-Admin module DB Definitions. | Required |
| Database user | The username credential required to access the database server. | Required |
| Database url | The JDBC URL string required to locate and connect to the database. | Required |
| Database password | The password credential associated with the specified database user. | Required |
| Driver name | The specific JDBC driver class name compatible with the target database. | Required |
Action Types & Examples
Database Connection Initialization
- Format: string
- Example Result: "robustaConnection"
Implementation Examples
Field Setup - Connection name: "robustaConnection" - Database name: "MYSQL" - Database user: "root" - Database password: "1234"
Execution Parameters - Database url (MySQL): "jdbc:mysql://localhost:3306/robusta" - Database url (Oracle): "jdbc:oracle:thin:@localhost:8080:robusta" - Database url (SQL Server): "jdbc:sqlserver://localhost:1433;databaseName=robusta" - Driver name (MySQL): "com.mysql.jdbc.Driver" - Driver name (Oracle): "oracle.jdbc.driver.OracleDriver" - Driver name (SQL Server): "com.microsoft.sqlserver.jdbc.SQLServerDriver"
Technical Notes
The Database name must correspond exactly to the definition provided in the RPA-Admin module. Users must ensure that the JDBC driver associated with the "Driver name" is correctly installed and accessible within the environment path to prevent connection failures.