Database(Power Automate Desktop Action)
This function is for using (mainly in-house) databases such as MySQL and Oracle.
This may affect other parts of the company, Therefore, please consult with your system administrator before using this function.
Contents
Actions
| Name | Importance | Description |
|---|---|---|
| Open SQL connection | High | Used first when performing an operation on a database. |
| Execute SQL Statement | High | Execute SQL to perform an operation. If there is only one SQL to execute, this action is all that is needed. (No "Open SQL connection" and "Close SQL connection" actions are required) |
| Close SQL connection | High | Used last when performing operations on databases. |