API vs. ODBC: FM <-> Wordpress/WooCommerce

Discussion created by user26871 on Mar 27, 2018
Latest reply on Mar 28, 2018 by DonCollier

I have managed to connect a FM database to an online Wordpress website database via ODBC. This way I can access all SQL tables directly from my FM database. I even found a free ODBC driver (MySQL ODBC 5.3 ANSI Driver) which worked (on my Mac)! There is also a paid version from Actual, which is recommended by FileMaker.


I did not setup a WooCommerce webshop yet but I assume all tables can be read out directly just as the Wordpress tables and can be imported into FM for further processing (products, prices, transactions, registrations, etc.).


But I wonder if there are any downsides compared to using an API. I have very little experience with API's and seems not the easiest thing to learn so I thought this was a good and less complicated approach.


What are the benefits using the API if you can access the SQL-DB directly?


Any advice is welcome.