SQL search automation

Hello lovely people,

if one is to do an automation which manually is run on toad with sql script - what is the best approach? ui automation or …?

Hi @aussta !
If you have a direct access to the DB, I would suggest you to use UiPath Studio to connect to your db and query (and if needed in your automation, fetch the data). To do so, you have:

  • a documentation about UiPath.Database.activities here.
    When you go through the documentation, there are properties that lets you know what are the prerequisite input data:
    image

  • a package from UiPath Studio that you should download to use DB connection:
    image

  • some interesting tutorials to understand how to use the package, from connection to queries, like this one. It connects to SQL server, but the logic is the same with Toad

Let us know if you have more questions !

2 Likes