SQL Sync is a paid bolt-on for integrating data sources and form entries directly with your on-premise or hosted Microsoft SQL or MySQL server. (Please note : This is not the same as our Azure SQL connector which is available from the Connections page).
Often the data captured using our platform needs to be made available to other systems and services, for purposes such as analytics, reporting or inclusion into workflows being run in other software.
We provide a number of “baked-in” integrations to popular cloud services through Connectors (including Azure SQL), and our Integration API is a comprehensive option for software developers.
Ultimately though we found that many companies had a simple requirement – they wanted to work with their data in tables on a local database such as Microsoft SQL or MySQL Server.
So we built our standalone SQL Sync product.
SQL Sync is a web application that automatically synchronises data between our cloud platform and a local SQL Server database on your own server and needs to be installed on your server.
All you need to run SQL Sync is:
– A server running Windows Server 2008 or higher
– A SQL Server 2008 Express or higher
– The installation server must be accessible from the internet.
We provide a full installation guide and our support team is available to help with any questions you may have.
SQL Sync automatically creates tables for each Form screen you hook up to it, with entries inserted into the tables as they happen, providing a simple, no fuss replication solution that ensures all your data is available for your internal needs.
You can also make local data available for use by the app as Data Source rows by creating tables or views within the SQL Sync database; this is then picked up by the app directly.
Having all your data locally means that it’s easy to layer options like Reporting Services or other analytics software on top of these database tables.
Running Azure SQL instead? Use our built-in Azure SQL connector