# Connection from FileMaker to PrestaShop MySQL Database **URL:** \ **Category:** Questions\ **Created:** [February 17, 2020, 1:35pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772 "2020-02-17T13:35:37Z")\ **Posts on this page:** 17\ **Page:** 1
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [February 17, 2020, 1:35pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/1 "2020-02-17T13:35:38Z")
I'm trying for 2 weeks to connect a FM solution to a PrestaShop MySQL db. Locally, I use MAMP Pro and I can connect to my local database with PHPAdmin. I'm not able to connect this same database with ODBC Manager to define a DSN for using inside FileMaker external resource. Has somebody some experience for this kind of job. Help w'll be appreciated. Bertrand ---
**Author:** ![WimDecorte](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@WimDecorte](https://the.fmsoup.org/u/WimDecorte)\ **Post date:** [February 17, 2020, 2:29pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/2 "2020-02-17T14:29:27Z")
Use their API instead: [http://doc.prestashop.com/display/PS14/Using+the+REST+webservice](http://doc.prestashop.com/display/PS14/Using+the+REST+webservice) It is not a good idea to try and connect to their underlying table structure because they can and will change that at will for their own development purpose. Using their API is the best way to integrate. ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [February 20, 2020, 2:12pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/3 "2020-02-20T14:12:39Z")
Thanks WimDecote I'll read what is this purpose. I never use API with FM, but perhaps the beginning of a long complicity 🙂 ---
**Author:** ![WimDecorte](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@WimDecorte](https://the.fmsoup.org/u/WimDecorte)\ **Post date:** [February 20, 2020, 4:11pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/4 "2020-02-20T16:11:45Z")
It's actually easier than you think so do dive in and ask any and all questions. I'm about to release a series of blog articles of journey into the Office 365 APIs. Different APIs but the journey is similar. ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [May 12, 2020, 9:32pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/5 "2020-05-12T21:32:06Z")
After some holidays and 16 days in hospital due to COVID-19, I'm back, so excuse my silence. With help of Editomac, Prestashop help and using API I found the good way to do what I want. I success with connection, get a plain text field with datas and was able to write a script to retreive each field from this text. If somebody wants to have explanation I'll write a little document to explain how to do. ---
**Author:** ![Bobino](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bobino/32/194_2.png) [@Bobino](https://the.fmsoup.org/u/Bobino)\ **Post date:** [May 12, 2020, 10:02pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/6 "2020-05-12T22:02:44Z")
I don't have an immediate need, but if you feel like sharing while it is fresh for you, I'll know where to go if I have something that involves prestashop. It's always great when people share about what they have been working on. ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [May 13, 2020, 11:22am UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/7 "2020-05-13T11:22:11Z")
Hello Bobino and all guys here. I've written a little document in French and English (google translation). [ModeAccèsPrestashop.pdf](https://the.fmsoup.org/uploads/short-url/qgyaE9VOsD9KixWk1dGu3tS6DJk.pdf) (164,3 Ko) ---
**Author:** ![WimDecorte](https://avatars.discourse-cdn.com/v4/letter/w/b19c9b/32.png) [@WimDecorte](https://the.fmsoup.org/u/WimDecorte)\ **Post date:** [May 13, 2020, 11:27am UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/8 "2020-05-13T11:27:42Z")
Thanks! And glad to have you back. ---
**Author:** ![Mark](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/mark/32/762_2.png) [@Mark](https://the.fmsoup.org/u/Mark)\ **Post date:** [May 13, 2020, 2:52pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/9 "2020-05-13T14:52:05Z")
16 days in hospital - this virus is terrible. Take it slowly and don't do too much - the recovery can be long. ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [May 13, 2020, 9:29pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/10 "2020-05-13T21:29:33Z")
Thank yo Mark. Oh yes, this virus is very nasty. I came close to the red line with 9 days of coma and 7 days of intensive care. No more strength and no more muscle despite the care performed with great professionalism by the nursing staff. Now it's a thing of the past, I've taken over a few activities, developing FileMaker solutions is good training. Be careful, wash your hands regularly and above all wear a mask. If possible stay at home as much as possible. Now, I am retired from the private and salaried sector. I'm going to work a bit with FileMaker and play even more with my hobby: the genealogy of my family. ---
**Author:** ![Mark](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/mark/32/762_2.png) [@Mark](https://the.fmsoup.org/u/Mark)\ **Post date:** [May 13, 2020, 10:43pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/11 "2020-05-13T22:43:11Z")
Jeez that sounds awful. Our Government appear to be pushing for the second wave - so bad. I can work from home and we are as isolated as possible. Spending time with FileMaker sounds like a great way to occupy your mind. Take care. ---
**Author:** ![Cecile](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/cecile/32/98_2.png) [@Cecile](https://the.fmsoup.org/u/Cecile)\ **Post date:** [May 14, 2020, 2:23am UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/12 "2020-05-14T02:23:18Z")
Wow! Coma! Happy you won that battle! I am sick since March 23 nothing near the severity of your ordeal but it just won’t leave. 3 relapses so far. When I am spending a couple days up and about (very light activity and lots of breaks), the fever and cough come back and knock me out. Talking is exhausting. ---
**Author:** ![anon45965781](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anon45965781](https://the.fmsoup.org/u/anon45965781)\ **Post date:** [May 15, 2020, 11:59am UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/13 "2020-05-15T11:59:19Z")
If you use a JDBC driver (JDBC is a **standard** supported by ALL RDBMS vendors), you can easily connect to any MySQL database. FileMaker also has a free JDBC driver so you could get data from MySQL (via SELECT) and then copy it into your FileMaker database (via INSERT or UPDATE SQL). Very straightforward and....FREE. As @WimDecorte said, however, if there is an API you can use like the REST link he included, I would definitely use that over trying to understand, reverse-engineer, their MySQL table structure. (Note there are tools that will read a MySQL (or other) database and give you a full ERD.) ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [May 15, 2020, 7:01pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/14 "2020-05-15T19:01:33Z")
I tried to use JDBC but never have a connection to my database. Using API is free and I success. ---
**Author:** ![anon45965781](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anon45965781](https://the.fmsoup.org/u/anon45965781)\ **Post date:** [May 15, 2020, 8:33pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/15 "2020-05-15T20:33:37Z")
Both are free, but as long as you got the API working, that would be the way to go. (If you search for "Java JDBC Example", you'll find tens if not hundreds of online examples.) Here's one example: **[Java - JDBC Connection Example (MySQL) - HowToDoInJava](https://howtodoinjava.com/java/jdbc/jdbc-mysql-database-connection-example/)** Happy Coding! 🙂 ---
**Author:** ![Bertrand](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bertrand/32/185_2.png) [@Bertrand](https://the.fmsoup.org/u/Bertrand)\ **Post date:** [May 15, 2020, 9:10pm UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/16 "2020-05-15T21:10:53Z")
fmpdude, I'm old generation (age 67) and have never work with C language and followings. I don't know Java and SQL language also. API works perfectly and permits to do what I need to do and that's good. ---
**Author:** ![anon45965781](https://avatars.discourse-cdn.com/v4/letter/a/13edae/32.png) [@anon45965781](https://the.fmsoup.org/u/anon45965781)\ **Post date:** [May 16, 2020, 9:58am UTC](https://the.fmsoup.org/t/connection-from-filemaker-to-prestashop-mysql-database/772/17 "2020-05-16T09:58:19Z")
It's all good. I wasn't suggesting you switch to Java; rather, just showing how easy it is to find examples where you really don't have to know the language. Happy Coding! 🙂