SQL Connector - Deprecated
This feature has been deprecated. Refer to the following guidance for alternatives.
Last updated
Was this helpful?
This feature has been deprecated. Refer to the following guidance for alternatives.
Last updated
Was this helpful?
Was this helpful?
The Form.io SQL Connector has been deprecated and is no longer supported or maintained by Form.io.
There are several alternatives to accomplish the functionality previously offered through the Form.io SQL Connector:
Webhooks can be used to synchronize data from Form submissions to a SQL database. Webhooks are configurable Form.io Actions that are fired upon form submission and make a call to an external API endpoint. By configuring the payload to contain submission data, it can be shuttled into other applications or databases through the application or middleware behind that API endpoint.
This approach is useful for synchronizing data with an external database that serves as the source-of-truth for the application.
Instead of connecting Form.io directly to a SQL database, a custom backend service (Node.js, Python, etc.) can be used to communicate between Form.io and the SQL DB. Such a service would generally:
Listen for Form submissions (via webhooks or API calls).
Transform the submission data as needed.
Store the data in the SQL database.
Fetch data from the SQL when needed and provide it to the Form.io front end.
This approach keeps the SQL database structure independent from the Form.io schema while also maintaining data synchronization.
A Form.io Resource can be used to pull data from an external SQL database if that DB is exposed via an API (Express.js, Django, etc.).
This allows a form to dynamically present or use existing external data from the DB.
For additional information on pulling external data into a Form.io resource, refer to the Data Source Component documentation.
For greater control when running a deployed Form.io instance, the backend may be modified to support direct SQL database integration.
This may be appropriate when a high degree of customization is required, but involves a significant degree of novel development.