Getting Data via DBGate
DBGate reads database metadata and the following configurations under the user credentials:
- Getting Data from Tables
- Getting Data from Views
- Getting Data from Stored Procedures
- Getting Data from SQL Queries
DBGate creates API methods for each user, publishing only available objects.
The built-in DBGate JavaScript client and the SaveToDB add-in completely support configured features.
In short, DBGate for the SaveToDB add-in is a proxy that converts API requests to SQL commands.
Use the connection wizard to connect and specify a service document URL like