MySQL

The MySQL connector Service used to define a connection required for associated actions and start events. Examples include Salesforce and Box. Method of integration to cloud services, business applications and content stores. is used to create connections for MySQL actions. Use the MySQL actions to execute queries in your database.

Create a MySQL connection

You can create connections from the Automate or Designer page.

Note: Your browser-stored credentials are accessed to create connections. Either clear credentials from browser memory or make sure the stored credentials are for the intended environment.

To run workflows that connect to SQL databases or related systems, first configure its firewall rules to allow traffic from potential source IP addresses for these workflows. If firewall rules are in place but not configured to allow these IP addresses, then contact does not occur and the workflow fails.

For instructions on SQL Server firewall configuration, see the Configure the Windows Firewall to Allow SQL Server Access Microsoft article or, for SQL Server on Windows Azure, see the Creating Microsoft SQL Server Connection to SQL Azure from Nintex Workflow Cloud Nintex Community article.

Potential source IP addresses for workflows:

US region EU region AU region

  • 40.112.243.0

  • 13.91.46.203

  • 40.112.255.35

  • 13.91.41.7

  • 13.91.40.30
  • 40.115.98.85

  • 40.87.138.71

  • 40.113.68.216

  • 104.41.226.28

  • 40.87.134.251

  • 23.101.230.162

  • 23.101.238.134

  • 23.101.238.167

  • 23.101.238.27

  • 23.101.235.11

  1. On the top navigation bar, click Automate, and then select Connections from the left navigation.

  2. On the Connections page, click Add new.

  3. In the Add a new connection section, fill in the fields as follows.

    In this field

    Select or enter the following
    Connector MySQL
    Connection A user-friendly name for your new connection
    Database Host SQL server on which the database resides
    Database Name

    Name of the database

    Username

    Username with access to the SQL server

    Password

    Password for above username

  4. Click Connect.

  5. Follow the prompts to grant access to Nintex Workflow Cloud.

    Your new connection appears on the Connections page.

    • On the top navigation bar, click Automate > Workflows, and then select the required workflow.

      • (Or)

    • On the top navigation bar, click Automate > Create workflow.
  2. Click the action you want to add the connection to.

  3. In the drop-down list for Connection, select Add new connection.

  4. In the Connection window, fill in the fields as follows.

    In this field

    Select or enter the following
    Connection name A user-friendly name for your new connection
    Database Host SQL server on which the database resides.
    Database Name

    Name of the database.

    Username

    Username with access to the SQL server.

    Password

    Password for above username.

  5. Click Connect.

  6. Follow the prompts to grant access to Nintex Workflow Cloud.

    Your new connection appears in the Connection field of your action or start event.