The steps would be similar , only the provider details would change … you can directly create the connections string and pass it to connect activity as shown in first video
2 Ways to Do it : In Dispatcher : Before you add data to queue , add that data to DataTable and then pass DT to DB. In Perfomer : Read the Data from Queue, add that data to DT and then pass DT to DB.
With Insert Query we get Privileges' to write our own set of query , The Data we intended to insert should not be necessarily same as the table structure . You can specify Joins among table while inserting put condition etc ... Bulk insert is straight Inserting the datatable to the SQL INSERT : ruclips.net/video/_M4MJDqz_b4/видео.html BULK INSERT : ruclips.net/video/CP0DJD-Lv10/видео.html
But I will try bulk insert activity in UiPath to insert the data table into the database, but it can't then I will try insert activity.... it works I don't know why, maybe the Joins concept?
Hi Mukesh, the syntax @ParameterName doesn't work with a PostgreSQL datatable in an Execute Command or Execute Query activity, could you help us about that ? I found something like : "PREPARE my_query (text, text) AS UPDATE myTable SET Country=$1 WHERE FirstName=$2; EXECUTE my_query('"+strVar1+"','"+strVar2+"');" But still need to use variable and not parameters, so I don't know if this is secured
Can you try something like below , I haven't tried wth postgres so not very sure UPDATE myTable SET Country = @CountryParam WHERE FirstName = @FirstNameParam;
Hello sir, aik bot banana ha sql connect kar k fir query dekar execute karne k bad wo data export karna ha aur fir jo file export ha usko email karna ha...
Yes , Ye RPA ka use case hai , Roz chalane k liye Bot ko schedule karna padega ... SQL Connect or Query Execution k videos already uplaoded hai ... Email k liye bas hume - Send Mail Message activity use karni hai and we are Done
Thank you for this Video, I need to know how can we connect Oracle SQL Developer database in Uipath
The steps would be similar , only the provider details would change … you can directly create the connections string and pass it to connect activity as shown in first video
@@MukeshKala Thank you its working
In interviews what are challenges faced in projects how to explain rpa uipath interviews please upload one video
Noted
Hi Mukesh, what if I want to get the updated table printed and tell me the number of records affected also printed?
You can again re Query the DB with select query and get all the records.
Hi Mukesh,
How can we move data from queue to the data base can u please me with this
Thanks in advance....!
2 Ways to Do it :
In Dispatcher : Before you add data to queue , add that data to DataTable and then pass DT to DB.
In Perfomer : Read the Data from Queue, add that data to DT and then pass DT to DB.
Hi mukesh... I m struggling with batch script... Can you do one video on that
Sorry Bro , Not an Expert in Batch Script
U can get them in Automate with Rakesh channel
thank u
🙏🙏🙏
Hi Mukesh, what is the difference between INSERT And BULK INSERT in database package.....
Thanks in Advance
With Insert Query we get Privileges' to write our own set of query , The Data we intended to insert should not be necessarily same as the table structure . You can specify Joins among table while inserting put condition etc ...
Bulk insert is straight Inserting the datatable to the SQL
INSERT : ruclips.net/video/_M4MJDqz_b4/видео.html
BULK INSERT : ruclips.net/video/CP0DJD-Lv10/видео.html
But I will try bulk insert activity in UiPath to insert the data table into the database, but it can't then I will try insert activity.... it works
I don't know why, maybe the Joins concept?
Yes , the schema and the join concert might cause issue
Hi Mukesh, the syntax @ParameterName doesn't work with a PostgreSQL datatable in an Execute Command or Execute Query activity, could you help us about that ?
I found something like :
"PREPARE my_query (text, text) AS
UPDATE myTable SET Country=$1 WHERE FirstName=$2;
EXECUTE my_query('"+strVar1+"','"+strVar2+"');"
But still need to use variable and not parameters, so I don't know if this is secured
Can you try something like below , I haven't tried wth postgres so not very sure
UPDATE myTable SET Country = @CountryParam WHERE FirstName = @FirstNameParam;
@@MukeshKala Hi, it does't work, the postgresql doesn't understand the @
Hello sir, aik bot banana ha sql connect kar k fir query dekar execute karne k bad wo data export karna ha aur fir jo file export ha usko email karna ha...
Par ye na roz karna ha daily file save ho fir send ho email
Yes , Ye RPA ka use case hai , Roz chalane k liye Bot ko schedule karna padega ... SQL Connect or Query Execution k videos already uplaoded hai ...
Email k liye bas hume - Send Mail Message activity use karni hai and we are Done
Aur execute k bad file download kar k email.karne.ha ?
Ok sir mai try karta hon.then apko inform karta hon thx
Thx Sir mane bana liya....