External Database Integration Event

The External Database Integration Event enables seamless connection to external databases and retrieval of query results.

Steps

1. Title & Description

   • Enter a meaningful title and description for the event.

2. Database Configuration

   • Database Type: Choose from PostgreSQL, Oracle, or MySQL.
   • Host: Enter the database host address.
   • Database: Specify the database name.
   • Username: Provide the database username.
   • Port: Define the database port.
   • Password: Enter the secure password.

3. Connection Test

   • Validate the credentials by testing the database connection.

4. Execute Query

   • Enter a raw SQL query and execute it.
   • The output will be returned in JSON format for use in subsequent events.

Actions

• Test Connection: Verify if the database credentials are correct.
• Run Query: Execute the query and fetch results in JSON format.
• Cancel: Discard changes.

This event facilitates integration with external databases and enables efficient data retrieval for workflow automation.