MySQL

×

REQUEST FREE TRIAL

Share A Little Information To Request Free Trial

Created with Sketch.
REQUEST FREE TRIAL

Overview

The MySQL connector allows you to query your MySQL database directly within tray.io, without having to worry about data pipelines or servers. The variety of use-cases here is wide, but common use-cases of the MySQL connector are:

  • Querying for additional data to enrich accounts in SaaS tools you're using - usually for enrichment purposes
  • Saving data from other software services into MySQL

Configuration

Operation Description
Find rows Find rows in your database based on criteria of your choosing. 
Insert new rows Insert one or more rows into your MySQL database.
Count rows Counts the number of rows that meet a given set of conditions.
Update rows Updates rows in your database based on criteria of your choosing.
Delete rows Deletes rows in your database based on criteria of your choosing.
Run SQL query Runs any raw SQL query of your choosing.

Connecting to your MySQL instance

To allow tray.io to connect to your MySQL database, you'll need to either make your database publicly accessible or you can white list the following static IP addresses for access:

  • 52.40.200.248
  • 52.39.10.61
  • 52.26.59.155

Note: it is extremely important that your MySQL database is only accessible with a strong username and password combination when white listing these IP addresses, as they will be used by anyone using the connector in a Tray workflow. If you wish to have a more secure connection, please contact Sales about our private static IP or private cluster options.

Last updated 11th April 2017

REQUEST FREE TRIAL

Share A Little Information To Request Free Trial

Created with Sketch.