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 in RPA by Dhruv
13 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
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 by Anvi
• 5,960 points

Related Questions In RPA

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 in RPA by Abha
• 6,480 points
51 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 in RPA by Anvi
• 5,960 points
85 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 in RPA by Abha
• 6,480 points
67 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 in RPA by Anvi
• 5,960 points
251 views
0 votes
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 in RPA by Pratibha
• 2,520 points
364 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 in RPA by Anvi
• 5,960 points
219 views
0 votes
1 answer

What is the Database Activities pack in UiPath Studio?

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

answered Apr 9 in RPA by Anvi
• 5,960 points
35 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.