Skip to main content
Learn how to seamlessly connect MySQL to Engini, enabling efficient database integration for your workflows. With the MySQL connector, you can manage data, run queries, and automate database interactions directly in Engini. Enhance productivity by integrating MySQL’s powerful capabilities into your business processes.

​
Getting Started with MySQL

​
Prerequisites

  • A MySQL account: This includes the username and password to access the database.

​
Connecting Engini to MySQL

  1. Enter your Engini account at https://app.engini.io.
  2. Navigate to Connections page by clicking on the Connections on the left side bar or by clicking here.
  3. Click on the “New Integration” option located at the top bar.
  4. Choose MySQL option from available applications
  5. Enter the following details in the “New Integration” form and press Save:
    1. Connection Name - Choose a name for easy reference to this connection.
    2. Server Address - The IP address or domain where the MySQL server is hosted.
    3. Database Name - The name of the specific MySQL database you want to connect to.
    4. Username - The MySQL username with sufficient access rights.
    5. Password - The corresponding password for the MySQL username.
    6. Communication Channel - Ensure the communication channel (likely Cloud) is accessible for remote connection.
    7. Save Settings - Click on the Save button located at the bottom of the form.

​
Actions

Specific tasks you want to perform in your MySQL database through Engini. These actions can automate data management, such as inserting records, running queries, or interacting with specific tables and databases in MySQL.

​
Create Record

  1. Table - Choose the table where the new record will be inserted. Make sure to select the correct table from your database.
  2. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Get Records

  1. Table/View - Choose the table or view from which you want to retrieve records.
  2. Top - Specify the total number of rows to retrieve (default is 100).
  3. Offset - Define the number of rows to skip before retrieving records (default is 0).
  4. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  5. Add Sort - Click Add Sort to organize the data list by a selected field in ascending or descending order. To learn more about sorting data, click here.

​
Update Record

  1. Table - Choose the table where the record to be updated is located.
  2. AccountId (PK) - Input the primary key (AccountId) for identifying the specific record to be updated.
  3. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Update Records

  1. Table - Choose the table where the records to be updated are located.
  2. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  3. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Delete Records

  1. Table - Choose the table from which records will be deleted.
  2. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.

​
Create Batch of Records

  1. Data List - Specifies the list of records you want to insert. The batch can handle up to 1000 items.
  2. Table - The name of the table where the records will be inserted.
  3. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Get Records Batch

  1. Data List - Provide the data list for the batch operation (maximum batch size is 1000 items).
  2. Table - Choose the table from which to retrieve the batch of records.
  3. Top - Specify the number of rows to retrieve (default is 100).
  4. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  5. Add Sort - Click Add Sort to organize the data list by a selected field in ascending or descending order. To learn more about sorting data, click here.

​
Update Batch of Records

  1. Data List - Provide the list of records to be updated in the batch (maximum size is 1000 items).
  2. Table - Choose the table where the records will be updated.
  3. Add Filter - Click Add Filter to define conditions that narrow down the data list and return only the relevant items. To learn more about using filters, click here.
  4. Add Field - Click Add Field to add and populate additional fields for the selected activity. To learn more about managing activity data, click here.

​
Execute Customized SQL

  • SQL - Input your custom SQL query to be executed on the connected MySQL database. You can use this action to run any valid SQL command (e.g., SELECT, UPDATE, DELETE).

​
Execute Procedure

  • Procedure Name - Input the name of the stored procedure you want to execute on the MySQL database. This action allows you to run predefined procedures that handle specific tasks or logic within your database.