Mention the activties from Database Activities Pack which you can use in uipath studio?

0 votes
Can anyone tell which all activities are a part of Database Activities pack and how they can be used?
Apr 9, 2019 in RPA by Dhruv
376 views

1 answer to this question.

0 votes

Hey Dhruv, following are the activities which comes with Database Activities pack:

  1. Connect: Connects to a database by using a standard connection string.
  2. Disconnect: Closes a connection to a database.
  3. Start Transaction: Connects to a database and features a Sequence which can perform multiple transactions with the database. If UseTransaction is set true, the contained operations are executed in a single transaction, and applied at the end if none of the them failed. If UseTransaction is set false, all operations are committed individually. When this activity ends, the connection to the database is closed. This activity returns a DatabaseConnection variable.
  4. Execute Query: Executes a query on a database and returns the query result in a Datatable.
  5. Execute Non Query: Executes a non query statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1.
  6. Insert: Inserts a compatible DataTable variable in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved.
answered Apr 9, 2019 by Anvi
• 14,010 points

Related Questions In RPA

0 votes
1 answer
0 votes
1 answer

What is the use of Cognitive Activities pack in UiPath studio?

Hi @Riya, the Cognitive Activities pack helps ...READ MORE

answered Apr 9, 2019 in RPA by Abha
• 27,800 points
544 views
0 votes
1 answer
0 votes
1 answer

Which activities can be used to automate virtual machine environments in UiPath Studio?

Hey @Sobia, in situations like virtual machine ...READ MORE

answered Mar 28, 2019 in RPA by Anvi
• 14,010 points
887 views
0 votes
1 answer

What is Get Jobs activity used for in UiPath Studio?

Hey @Rakesh, Get Jobs Activity can be ...READ MORE

answered Mar 13, 2019 in RPA by Abha
• 27,800 points
681 views
0 votes
1 answer

How to format text in notepad using UiPath?

Hey @Rashmi, if you want to automate ...READ MORE

answered Mar 18, 2019 in RPA by Anvi
• 14,010 points
1,926 views
+1 vote
1 answer

How can I display current date in "dd-MMM-yy" format in UiPath Studio?

Hi Shilpa, if you want to display ...READ MORE

answered Mar 18, 2019 in RPA by Pratibha
• 3,690 points
6,394 views
0 votes
1 answer

How to check if a string exists in datatable using UiPath?

Hi @Ravi, to check whether a string ...READ MORE

answered Mar 18, 2019 in RPA by Anvi
• 14,010 points
4,229 views
+1 vote
1 answer

What is the Database Activities pack in UiPath Studio?

Hey Anurag, the Database Activities Pack enables ...READ MORE

answered Apr 9, 2019 in RPA by Anvi
• 14,010 points
670 views