Data from Database

Help Studio
,
1

if i use uipath.database.activities to get data from database, is it required SSMS or SQL developer software to be installed in that machine?

2

No, you should be able to use these activities without having to download any external tools like that.

1 Like
3

Hello @jaydeepbhunia you don’t need either installed in the machine. You might need an ODBC driver for SQL though to connect.

4

@jaydeepbhunia No, SSMS (SQL Server Management Studio)or SQL Developer is not requiredto be installed on the machine to use UiPath.Database.Activities for fetching data from a database.

What is Required?

  1. Database Connection Details(Server Name, Database Name, Username, Password).
  2. Database Driver (if needed):
    For SQL Server→ Install Microsoft ODBC Driver or SQL Server Native Client.
    For Oracle Database → Install Oracle Instant Client (for ODBC or OLEDB connection).
    For MySQL, PostgreSQL, etc. → Install the respective ODBC or ADO.NET driver.
  3. Correct Connection String:Ensure the connection string used in the “Connect” activity is properly formatted.

While SSMS or SQL Developer helps in testing queries separately, they are not mandatory for running UiPath database activities. Let me know if you need help with setting up the connection!
Hope it helps