Saving Data via DBGate

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

It supports all the methods outlined 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 uses POST, PUT, and DELETE commands to update modified data.

The SaveToDB add-in connects to DBGate endpoints and utilizes REST API commands to update the data without requiring additional configuration steps.

In this context, DBGate acts as a proxy, converting POST, PUT, and DELETE HTTP commands into INSERT, UPDATE, and DELETE SQL commands for tables and views, as well as EXEC commands for specified stored procedures and SQL commands.