Getting Started with the SaveToDB Developer Guide
This guide explains how to configure the SaveToDB add-in, DBEdit, DBGate, and ODataDB.
These products enable you to retrieve data from databases and save changes back to tables and views by default.
They share a common server-side configuration that allows you to customize features such as:
- Saving changes using stored procedures or custom SQL commands
- Controlling changes with cell change handlers
- Retrieving value lists for cells and parameters
- Executing context drill-down queries
- Translating column names, parameters, and data
- And much more
After configuring an application, you can use Microsoft Excel, a Windows app, or a browser as a database client.
The SaveToDB add-in supports OData and REST API, just like other database objects.
You can set up the add-in to create a fully-featured REST API application with Microsoft Excel.
Additionally, you can connect to databases directly through SaveToDB or use ODataDB or DBGate as a proxy.
To get started, check out the following topics: