UiPath Database Activities

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.

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 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