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