Connecting & Inserting Data Into SQL Database Using UiPath

#uipath #rpa #sql
In this video, the following topics have been explained:
1) How to install SQL Server Management Studio?
2) Setting up your database
3) Creating Tables in SQL Database
4) Database activities in UiPath
5) Connecting Database in UiPath
6) Dynamically Inserting Data
SQL Server: aka.ms/ssmsful...
LinkedIn: / parth-doshi-2616b6127
Phone: [phone]
Email: [e-mail]

[@sumitrasahoo4307]

nyc explanation..

[@briankeller5267]

Perfect. Exactly what I needed.

[@BargainBarons]

You should have started from scratch, as I do NOT have the SQL server package installed, and do not know which one to install.

[@fabmix2367]

Hi, how can we insert datatable in which column name contains spaces in SQL server using Uipath.??

[@yashobantadash6670]

if we can directly execute in sql why do we need to use uipath to execute? in which scenario it is required?

[@gattuakhil2319]

clean and clear explanation

[@ParthDoshiLearningByDoing]

Thank you Akhil.

[@suryanampelly5205]

Can you explain the steps for connecting to Oracle 12 c database and execute a sql query?

[@miguelromanminaya1065]

Do you have a example with Activity Bulk Insert? Please, Do you share with me, the example.?

[@Antishkr]

Hey Parth! I have one query can you please help me with this?
Can we fetch data from website HTML table and import it directly into SQL server?

[@ParthDoshiLearningByDoing]

Yes we can

[@MTSightseeing]

Hi sir, can we do this on schedule time for e.g i have one excel sheet with thousands of records and i need to insert into database daily 8 pm automatically just need to place file on path? possible

[@ParthDoshiLearningByDoing]

Yes you can do it, it can be scheduled in UiPath Orchestrator.

[@khooshbujani4949]

Hi, I have a question. I have >100000 pdf files. will it read it and insert the records to DB?

[@ParthDoshiLearningByDoing]

Yes it can

[@sreejithnair100]

How to provide this to an end user totally non technical? Can a UI be given to them to enter the details to be inserted?

[@ParthDoshiLearningByDoing]

It is attended automation end user can run it through their UiPath Assistant.

[@jonaskarlsson477]

Have you done a video where you just insert uniqe values?

[@ParthDoshiLearningByDoing]

No Jonas, but what exactly are you looking for if any specific error you need help with let me know.

[@jonaskarlsson477]

@@ParthDoshiLearningByDoing I used a excel as a sourse and then did a insert but the insert dont works with removing duplicated. I want it to see id the same row alredy exist in the database. I think the source is irrelecantbecouse the data is converted as a datatable before.

[@sathyamoorthin8887]

How to connect external machine sql database in our machine uipath

[@renukachhabdiya6176]

What will be the server name ? I am facing lot of issues for the server name and i am unable to connect. Can you please help me with this ?

[@ParthDoshiLearningByDoing]

It should come automatically if not it is your machine name try using that.

[@surajkamath5564]

I'm getting invalid object name Details for my query. I have given same table name

[@ParthDoshiLearningByDoing]

Which activity is giving that error?

[@joekhater2167]

why ma i getting this error :Execute Non Query: ORA-00936: missing expression

[@ParthDoshiLearningByDoing]

Can you send the query you’re trying to run?

[@varshithavuyyuru1343]

i am getting error "MUst declare the static variable @"when i am using @

[@varshithavuyyuru1343]

Could you pls reply

[@ParthDoshiLearningByDoing]

Have you declared the parameters and given them the value that you want to pass?
If not then declare them.
If yes then check if you're them properly in query.

[@gattuakhil2319]

I am not getting server name brother

[@ParthDoshiLearningByDoing]

Open SQL management studio click on connect and you will see there if not then it is the machine name you're using if you want to connect using windows credentials.

[@surajkamath5564]

Hi, I am also facing same issue. Its not connecting with my laptop name