Database SQL

We currently support the following database management systems: MySQL, MSSQL, PostgreSQL, and Oracle. Please take note that only 64-bit versions are supported; 32-bit versions could be unstable.

  1. How to connect to a Database

In the Settings/Credential Management for the Database, enter credentials (login and password). Then choose the “Connect to Database” activity. This activity allows you to establish a connection to any of the following DBMS types: MySQL, PostgreSQL, MSSQL, and Oracle. Once the connection has been made, you can execute a query.

  1. Execute query

When the connection to the database is established, define the query to the database by using the “Execute query” activity.

Parameters

Query text:

  1. Set a value: enables you to directly provide a query in the text form, for example, SELECT * from developers or INSERT INTO ‘managers’ (name, birth date, salary) VALUES (‘Jane Doe’, ‘1988/05/13’, ‘3000’)
  2. Save the previous step result: choose the previous function result as a query.
  3. Calculate a value: enables you to use available properties and methods to form a query in the text form.

1 Like

hello guys, do you have any example for mysql connectivity

1 Like

@SVI-RPA_02 You can find the article with an example here : Databases

Also, find this bot in bot library and you can refer to this to know how can we work with MySQL : ElectroNeek RPA | Automation Platform