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
45 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 by Anvi
• 10,310 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
• 16,380 points
125 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
• 10,310 points
186 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
• 16,380 points
160 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
• 10,310 points
551 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,740 points
1,110 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
• 10,310 points
600 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
• 10,310 points
75 views