Is it possible to export data automatically?

Hi.

Can you tell me how I can schedule an export of the data into a csv and save the file somewhere, or can I obtain access to the data from our local SQL server and query the data into our database?

Thanks.

It is not possible to export form data to csv file automatically, however, there is an option to integrate a form with Google Spreadsheets: How-to-Integrate-Form-with-Google-Spreadsheet.

Also, you could send submissions to your MySQL Database: How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP

Let us know if you need any further assistance.

Is it possible to send submissions to our Microsoft SQL Database?

You can use automate.io to integrate Jotform and your MS SQL server https://automate.io/integration/jotform/sql-server.

Thanks Jed - I've had a look at that link and it says that the integration between JotForm and MS SQL is still in development???

Any ideas?

You can check out the earlier guide shared by my colleague where in you can send submissions to your DB using PHP: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

So you can use PHP to send submissions into MS SQL as well as MySQL?

Yes, you'll need to write your own PHP script that connects to your MSSQL or MySQL server. You can try the PHP script written by the user who tried to connect it with MSSQL using PHP.

Here's the link https://www.jotform.com/answers/1184132.

Hi there.  Before I go ahead and pay for someone to write a php script to connect the MS SQL server with Jotform, can you tell me if this solution is possible if I do not use a thank you page.  Currently, upon form submission, I have it set to go back to a custom menu page which has a button for each of the forms in use.

Thanks.

 Also, is it possible to query the submission database from external, or only by use of webhooks?

can you tell me if this solution is possible if I do not use a thank you page. — No, it's not possible without sending a POST to your server. You'll need POST method to send Jotform submission to your server and store it to your own database using PHP script.

is it possible to query the submission database from external, or only by use of webhooks? — Once data is stored in your own server, it will now be accessible to you for query.

If you are asking about submission query via Jotform, you can pull data via API, there a lots of ways to do it.

Guide: https://api.jotform.com/docs/#submission-id

ex. https://api.jotform.com/submission/{submissionID}?apiKey={apiKey}