If you don't get any specific feedback on this, try contacting Matt Petrowsky. I don't have a direct email for him, but one of his sites is:
There is a 'contact the editor' link there that you might be able to get ahold of him through. I suggest this because he has mentioned in his video's and podcasts about using Drupal extensively. I have seen him do a few postings in this forum, so he might see this as well.
Update: If you go to https://fmdev.filemaker.com/people , you can search for members. Matt goes by the name of "Mattman". Looks like there is a link in the profile where you can send a message to the person.
Message was edited by: BowdenData
We've managed to integrate our FM based LMS solution quite nicely with a Drupal/Ubercart. Filemaker is connected to the DrupalMySQL using ODBC, which allows me to manipulate data in Drupal's tables as if they were part of my FM solution.
Drupal to FM integration is done by URL commands triggering FM scripts and returning XML. This is a little shakier as you have to be certain not to mess with the Drupal core, and thus reducing your upgrade expansion capabilities. Drupal holds an integration table where it contains key FM values based on the Drupal user, in one case it has to poll a field value (for not null) and act accordingly
FM is definately the flexible partner in the relationship so we tried to use FM as the master source and disabled Drupal edits to integarated fields to reduce the number of integration points.
Works nicely. Key integration point is when Cart takes a sale and tells FM (via URL) to run a command with a given parameter (the order number). The FM script grabs all the required data from Drupal tables and processes them via a mirror 'orders' table in FM so it can analyze (new client? New Salesperson?) and then effect the changes caused by the sale.
There is a fledgling Drupal module for FileMaker available, see http://drupal.org/project/filemaker
The guy who has built it was at DevCon this year, and it was looking promising - it's not D7 ready yet, and still pretty 'raw' in places, but it might do enough for your needs, or it might be that you could help develop the module as part of your development…
See http://filemakerwebsite.com/ for his website about a hosting service he's offering using the module..
Hope this helps.
Web Services is the way to go. There are lots of Drupal modules for making the data inside drupal web service enabled, or for accessing other web services.
For the FileMaker end you can use our free FileMaker plugin to access the services you setup on drupal : http://www.goya.com.au/baseelements/plugin
And if the drupal developers want to talk to your FMS box using Web Services, then you can use RESTfm to setup your FileMaker Server box as a RESTful web service : http://www.restfm.com/
Let me know if any of this doesn't make sense or you need any other help.
Thanks for all the replies, guys. I'll take a closer look at this info and share it out with others involved with the project to see how we may move forward.