Database

Introduction

This document provides detailed instructions for integrating the Database Library with Automate, a powerful workflow automation platform. The Database Library action enables users to connect to various databases such as SQL Server, Oracle, MySQL, and PostgreSQL, and perform a range of actions within them. These actions include executing transactions, queries, inserts, updates, deletes, and selections. Integrating the Database Library with Automate allows users to efficiently manage database operations directly from their workflows.

What is the Database Library?

The Database Library in Automate offers a set of actions to interact with databases seamlessly. Users can connect to databases like SQL Server, Oracle, MySQL, and PostgreSQL, and execute transactions and queries with ease. This integration empowers users to perform database operations within their Automate workflows, enhancing efficiency and productivity.

Automate Integration with Database Library

Automate provides a set of pre-built actions within the Database Library to facilitate seamless integration with various databases. These actions include "Connect," "Disconnect," "Insert/Update/Delete," and "Select," enabling users to perform essential database operations directly within their automation workflows.

Using the Integration

To utilize the integration with the Database Library in Automate, follow the steps outlined below:

How To Use Actions

Connect

Description: Establishes a connection to the selected database.

Purpose: This action enables the system to connect to various types of databases for data retrieval and manipulation.

Usage:

Select the Database Type: Choose from Microsoft SQL Server, MySQL, PostgreSQL, or Oracle.
For Microsoft SQL Server:
- Server Name: The name of the SQL Server.
- Database Name: The name of the database.
- Username: The username for the database connection.
- Password: The password for the database connection.
- Port: The port number for the SQL Server.
- Instance: The instance name of the SQL Server (if applicable).

For MySQL Server:
- Server Name: The name of the SQL Server.
- Database Name: The name of the database.
- Username: The username for the database connection.
- Password: The password for the database connection.
- Port: The port number for the SQL Server.

For PostgreSQL Server:
- Server Name: The name of the SQL Server.
- Database Name: The name of the database.
- Username: The username for the database connection.
- Password: The password for the database connection.

For Oracle Server:
- Server Name: The name of the SQL Server.
- Username: The username for the database connection.
- Password: The password for the database connection.
- Port: The port number for the SQL Server.
- Instance: The instance name of the SQL Server (if applicable).

Input Fields:

Database Type: Select the type of database.
Database Connection Details:
- Server Name: The name of the database server.
- Database Name: The name of the database.
- Username: The username for the database connection.
- Password: The password for the database connection.
- Port: The port number for the database server.
- (Optional) Instance: The instance name for SQL Server or Oracle.

Output Fields:

None

Disconnect

Description: Closes the connection to the database.

Purpose: This action terminates the active connection to the database, freeing up resources.

Usage:

No additional input required.

Input Fields:

None required.

Output Fields:

None

Insert/Update/Delete

Description: Executes an insert, update, or delete query in the database.

Purpose: This action allows for the modification of data within the connected database.

Usage:

Enter the SQL Query: The SQL query to be executed.
Specify the Timeout: Duration to stop the query if it exceeds the specified time.

Input Fields:

SQL Query: The SQL query to be executed.
Timeout: Timeout duration to stop the query if it exceeds the specified time.

Output Fields:

None

Select

Description: Executes a select query in the database.

Purpose: This action retrieves data from the connected database based on the provided query.

Usage:

Enter the SQL Query: The SQL query to be executed.
Specify the Timeout: Duration to stop the query if it exceeds the specified time.
Assign to Variable: Variable to assign the output of the select query.

Input Fields:

SQL Query: The SQL query to be executed.
Timeout: Timeout duration to stop the query if it exceeds the specified time.
Assign to Variable: Variable to store the output of the select query.

Output Fields:

None

These actions facilitate the interaction with databases by establishing connections, executing queries, and managing data retrieval and manipulation tasks within the specified database environment.