Getting Data via DBGate
DBGate retrieves database metadata and configurations based on user credentials:
- Getting Data from Tables
- Getting Data from Views
- Getting Data from Stored Procedures
- Getting Data from SQL Queries
DBGate generates API methods for each user, exposing only the objects they have access to.
The built-in DBGate JavaScript client and the SaveToDB add-in fully support these configured features.
In essence, DBGate for the SaveToDB add-in acts as a proxy that translates API requests into SQL commands.
To connect, use the connection wizard and specify a service document URL like: