My Website

Coming soon ...

Publish FileMaker data via MySQL

Add your FileMaker Table to fmSQLdata
Add a layout with the fields you want to have in your MySQL table
Add your MySQL Database to the n8n Sync MySQL Workflow
Set up your Sync Method(s)
Choose your Sync Scenario
Run the create MySQL table script, which automatically gets the FileMaker’s table structure, creates the MySQL table and exports the FileMaker records to MySQL

Text Logo

Sync Methods

Sync takes place in FM (Server)
new and modified in FileMaker via Request script that calls Push Changed Records function in fmSQLdata. This script can be triggered via OnRecordCommit in the layout in your database (for example).
new and modified in SQL via status_sql field in sql table

Sync Scenarios

1-way to MySQL / push data from FileMaker to MySQL
1-way to FileMaker / pull data from MySQL to FileMaker *
2-way FileMaker <> MySQL
partly 1-way to sql (web portals) ... create, update and delete via SyncData table, etc.

* for example for public web form

Internal Tools ... Appsmith, BudiBase, Tooljet

The reason why we build fmSQL, is that we wanted to be able to build scalable and respronsive web portals for our customers’ customers and suppliers. For this, we’re using BudiBase. For more info, read our blog.

Techniques and Tools used

FileMaker JSON
n8n Workflow with MySQL node
BudiBase Internal Tools
elest.io managed DevOps

Text Logo

Open Source

For our web portals, we’re using open source tools, such as n8n, MySQL and BudiBase, and therefore fmSQL is also open source.

Paid Services

consultancy ... FileMaker, MySQL, n8n, BudiBase, elest.io ...
sponsored development ... new features