SQL Connector - Deprecated

This feature has been deprecated. Refer to the following guidance for alternatives.

Deprecated Feature

The Form.io SQL Connector has been deprecated and is no longer supported or maintained by Form.io.

Alternatives

There are several alternatives to accomplish the functionality previously offered through the Form.io SQL Connector:

Webhooks

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.

Custom API Layer

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:

1. Listen for Form submissions (via webhooks or API calls).

2. Transform the submission data as needed.

3. Store the data in the SQL database.

4. 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.

Use Form.io Data Sources

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.

The Form.io Server SDK

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.