Saving Data via DBGate

DBGate reads the xls.objects table and the QueryList views to configure REST API.

It supports all the methods described in the following topics:

• Saving Data to Tables
• Saving Data to Views
• Saving Data Using Procedures
• Saving Data Using SQL

The built-in DBGate JavaScript client calls POST, PUT, and DELETE commands to update the changed data.

The SaveToDB add-in can connect to DBGate endpoints and use REST API commands to update the data.

It does not require additional configuration steps.

For the SaveToDB add-in, DBGate acts as a proxy that converts POST, PUT, and DELETE HTTP commands to INSERT, UPDATE, and DELETE SQL commands for tables and views and exec commands for the specified stored procedures and SQL commands.