FM hosting and Remote Access
I need you advice.
We are rebuilding our website. and this time we want to add Online Ordering function for our retailer customers. Our office is using FileMaker DB to manage orders, customers and products, etc. And we don't want to host FM from our office.
We have two options:
1. using free shopping cart software (which supports MYSQL). Then manually download orders from MySQL, and import into our office FM DB. And also, manually export customers / products from FM and upload onto the MySQL.
But this way we don't prefer the manual operation, it is too tedious. So I am looking for a way to automate this. If from FM in the office I can remotely access to the MySQL Database, that will be perfect. I know FM supports odbc or jdbc, but I don't know if this would work.
Please let me know if there is a way to get around for this.
2. to find some company who can host FM. So that I can remotely access to the website FM from our office FM. that way it is perfect integration to me. But after I contact some hosting companies, which will give just 10 IWP connections for hosting FM. That worries me as we have about 2000 retailer customers. I don't know how many customers will go online ordering at the same time, but obviously we are expecting more than 10. As you know FM DB can support IWP maximum 100 connections, I found out if I ask for 100 connections, the hosting company is going to charge me $150 / month as this will be virtual server package price.
Can someone let me know if my concern for 10 connections being not enough is right ot wrong?
I also heard IWP will be very slow, and difficult for developer customing.
It is decision time, but I am not sure which would be the best choice. Please help.
Or if you have any other idea, please let me know.
thank you very much