Create your first automation in just a few minutes.Try Studio Web →
by UiPath
0
Activity
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
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.
The Start Transaction activity serves as a dedicated container facilitating database connection, execution of multiple actions, and subsequent disconnection.
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.
This package contains the following activities:
Features
Features
The Database Activities package can be employed in various automation scenarios, such as:
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
Technical
Version
1.9.0Updated
September 27, 2024Certification
Gold Certified
Tags
Support
Link: https://www.uipath.com/company/contact-us/contact-technical-supportUiPath Standard Support, see your Service Agreement