MarketplaceStudioActivityUiPath Database Activities

Create your first automation in just a few minutes.Try Studio Web

UiPath Database Activities

UiPath Database Activities

by UiPath

StarStarStarStarStarStarStarStarStarStar

0

Activity

Downloads

161

Summary

Summary

The Database Activities Pack enables the user to connect to a database and perform an entire palette of actions within it, such as executing transactions or queries and non queries.

Overview

Overview

Introduction to the Database Activities Package

The Database Activities package empowers users to establish connections with databases and execute a comprehensive array of actions within them. These actions include executing transactions, queries, and non-queries. The pack supports seamless connectivity to a diverse range of databases, including but not limited to SQL Server, Oracle, and DB2, both directly and through ODBC/OLE DB.

Start Transaction Activity

The Start Transaction activity serves as a dedicated container facilitating database connection, execution of multiple actions, and subsequent disconnection.

Connection Process and DatabaseConnection Variable

The Connect and Disconnect activities provide additional flexibility for connecting to databases, executing specific actions, and disconnecting as needed for individual connections.

The connection process revolves around the utilization of a DatabaseConnection variable. This variable is unique for each connected database and can be employed across the entirety of your automation project for establishing connections to the designated database.

Activities in the Database Activities Package

This package contains the following activities:

  • Bulk Insert - Updates a table using Bulk operations using the specific database driver implementation.
  • Bulk Update - Updates a compatible DataTable in an existing Table.
  • Connect - Connects to a database by using a standard connection string.
  • Disconnect - Closes a connection to a database.
  • Execute Non Query - Executes an non query statement on a database.
  • Execute Query - Executes a query on a database and returns the query result in a DataTable.
  • Insert - Inserts a compatible DataTable variable in an existing Table.
  • Start Transaction - Connects to a database and features a Sequence which can perform multiple transactions with the database.

Features

Features

Features and Applications of the Database Activities Package

The Database Activities package can be employed in various automation scenarios, such as:

  • Data Migration
  • Automated Reporting
  • Database Connection Management

Additional Information

Additional Information

Dependencies

Microsoft.Data.SqlClient, Oracle.ManagedDataAccess, System.Resources.Extensions, Microsoft.Data.SqlClient, Oracle.ManagedDataAccess.Core, System.Data.Odbc, System.Data.OleDb, System.Resources.Extensions

Publisher

UiPath

Visit publisher's page

Trusted Source

License & Privacy

License Agreement

Privacy Terms

Technical

Version

1.9.0

Updated

September 27, 2024

Certification

Gold Certified

Support

Link: https://www.uipath.com/company/contact-us/contact-technical-support

UiPath Standard Support, see your Service Agreement

Similar Listings