Filemaker SQL Interoperability
Hi, we currently run our entire database infrastructure on Filemaker Pro and this is an extremely efficient system. However I am finding that having the data available within SQL would be a great benefit when it comes to off the shelf products such as dashboards and custom web apps etc.
Rather than rebuilding all our Filemaker forms and queries to operate with the SQL server as a backend I would, in the first instance like to set up an exact copy of the data on the SQL server and simply allow the non filemaker compatible apps to interface with the live data via SQL. could anyone tell me if this is feasible or maybe sugggest a better way of accomplishing my goal ?