Need some guidance here. We are taking orders over the internet and storing the data in a MS SQL Server database server. We need to get the data into our FileMaker database.

The SQL Server is a remote server connected via a VPN. What is the best way to do this? I have tried ODBC with no luck over the VPN. Should we put the data into a local FileMaker database on the web server and then transfer it over?

How about exporting to plain text from sql and then importing that file into file maker?

Any suggestions would be helpfull.

Thanks

If you can export data as tab or comma-delimited from the tables of interest, filemaker will be able to import it no problem.... this will probably be more tedious than using ODBC though. I've used OBDC data sources over VPN from home over a cable modem w/o a problem. Are you able to connect from FM to the SQL server using ODBC locally?

Can I do complex SQL Queries through FIleMaker's ODBC?

For example, I want to pull all unprocessed orders and then update the table showing that those orders have been processed.

How can you automate this to happen every day?