View Navigation
Product Overview
Account Overview
Integrations
Transforms
Security
Integrations   ->

Pull from MySQL

The Pull from MySQL step connects to and pulls data from a remote MySQL server. MySQL is an open-source relational database management system developed by Oracle.

Connect your MySQL server

Double-click on the Pull from MySQL step and click Authorize. These are the following fields required to connect:

  • Hostname
  • Username
  • Password
  • Database
  • Port (Optional)

You should be able to find these fields by viewing your MySQL profile.

If no port is specified during authorization, this step will default to port 3306.

You can leave fields blank (like "Password") if they are not needed for the database to authorize connection.

Custom settings

Once you are successfully connected to your server, you'll first see a dropdown option to select a table from your server. By default, Parabola pulls the whole table using the query: select *.

If you'd like to be able to pull in more specific, relevant data, or reduce the size of your default import, you can do so by writing your own SQL statement to filter your table's data.

To do so, click into the step's Advanced Settings and input your query into the Query (optional) field.

Recipes

Integrations   ->

Send to MySQL

The Send to MySQL step can insert and update rows in a remote MySQL database. MySQL is an open-source relational database management system developed by Oracle.

Connect your MySQL server

Double-click on the Send to MySQL step and click on the blue button to Authorize. These are the following fields required to connect. You should be able to find these fields by viewing your MySQL profile.

If no port is specified during authorization, this step will default to port 3306.

You can leave fields blank (like password) if they are not needed for the database to authorize connection.

Custom settings

Once you are successfully connected to your server, you'll first see a dropdown option to select the table you'd like to send data to.

Next, you'll select an Operation. The available Operation options are:

  • Insert: Inserts new rows in the database
  • Upsert: Updates rows if possible, and inserts new rows if not
  • Update: Only updates rows

Insert

The Insert option will insert new rows in the database. Once you select the "Insert" operation, you'll be asked to map your columns in Parabola to columns from your selected MySQL table. You can leave some column mappings blank. If you're using the Insert operation, make sure that it's okay that Parabola create these new rows in your table. For example, you may want to check for possible duplicates.

Upsert

The Upsert option will updates rows if possible, and inserts new rows if not. The Upsert operation requires you to specify the primary key of the database table ("Unique Identifier Column in Database"), or the column that contains unique values in Parabola ("Unique Identifier Column in Results"). Mapping these columns is important so Parabola can use to figure out which rows to update versus insert new rows.

Then, you need to map your columns in Parabola to columns from your selected MySQL table.

Update

The Update option will only update rows. It will not insert any new rows. The Update operation requires you to specify the primary key of the database table ("Unique Identifier Column in Database"), or the column that contains unique values in Parabola ("Unique Identifier Column in Results"). Mapping these columns is important so Parabola can use to figure out which rows to update.

Then, you need to map your columns in Parabola to columns from your selected MySQL table.

Helpful tips

  • The Send to MySQL step can only send strings. All values will be sent as a string. If you encounter an error when running the Send to MySQL step, please double-check that the field in MySQL is set to accept string values.
  • The names of your columns in Parabola must match the names of the fields in your database. Use a Rename columns step to accomplish this before sending.
Try Parabola for free