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.
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.
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.
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.
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.
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.
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.
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.)
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.