How can I access a database using a SQL query?

nedenfield · January 15, 2020, 9:51pm

I can not seem to find the recommended UiPath.Database.Activities package in the Manage Packages section.

I am also not seeing the “Connect” activity in my UiPath Studio.How can I install the package?

fernando_zuluaga · January 15, 2020, 9:55pm

you need to connect first UiPath to database using ODBC, here are a tutorial
https://www.rpamantra.com/connect-to-sql-database-using-uipath/

nedenfield · January 15, 2020, 9:57pm

Fernando, the “Connect” activity does not appear on my screen when I search for it, how do I get it to appear?

fernando_zuluaga · January 15, 2020, 9:59pm

are you sure you are searching here?

nedenfield · January 15, 2020, 9:59pm

Yes, I am.

fernando_zuluaga · January 15, 2020, 10:16pm

then i think you have to install it manually, but find again in nuget.org

balupad14 · January 15, 2020, 10:18pm

Enable the below check box like below

Now you can get the package …

Here is the sample for Sql server database

Regards
Balamurugan.S

Topic		Replies	Views
UIPath.Database package Help database , activities , studio	4	5214	February 9, 2017
How to connect to a database? Studio database , activities , question	1	1026	February 26, 2020
How to add Database.Activities package to UiPath studio Help database , activities , studio	4	11825	January 30, 2017
Connect Activity Activities database , activities , question , other	4	1356	February 24, 2021
Using Database Activities Tutorial - Feedback Space Academy Courses	3	1301	February 24, 2020