Excel and Web Clients
for SQL Server, MySQL, and PostgreSQL
SaveToDB as a platform for creating enterprise applications with Excel
The SaveToDB add-in adds two tabs to Excel: Database and Reports.
In a simple case, the add-in allows using Excel as an editor for data from tables, views, and stored procedures.
At the same time, the add-in allows you to conveniently connect to databases, switch queries, change values of parameters and WHERE fields on the ribbon, use names from primary key tables instead of identifiers in parameters and cells.
Through server-side customization, database developers can implement enterprise applications with any capabilities, including any method of saving data, server-side event handling, extending context menus, translating user interface elements and data.
Using the add-in, database developers get a ready-made, customizable client with the full set of Microsoft Excel features.
Companies can save significant amounts on developing client-side and get additional benefits by increasing employee productivity.
You can use the SaveToDB add-in for free as a reporting tool, without the ability to save data to databases.
The screenshot shows an example of an interactive report.
Learn more about SaveToDB Download
DBGate as a platform for creating enterprise web applications
DBGate is a server-side ASP.NET Core application and a JavaScript client.
The server app receives HTTP GET, POST, PUT, and DELETE commands
and executes SQL commands SELECT, INSERT, UPDATE, DELETE, or EXEC.
The client app uses the service and allows displaying and editing data.
It supports conditional formatting, formulas, copy/paste, and undo/redo.
In a simple case, you can use DBGate as an online editor for data from tables, views, and stored procedures.
All you need to do is add a connection string.
DBGate will create the REST service by reading the database metadata.
However, DBGate uses the proven SaveToDB add-in configuration model. Database developers can configure ways to save data, server-side event processing, lists of values, UI and data translation, and more.
That is, by implementing an app in Excel, you get the web app too.
You can try DBGate online:
https://dbgate.savetodb.com/en-us/budgeting-app.htm
https://dbgate.savetodb.com/en-us/planning-app.htm
Learn more about DBGate Download
ODataDB as a platform for creating enterprise web applications
ODataDB is a server-side ASP.NET Core application and a JavaScript client.
The server app implements an OData 4.0 service based on database metadata and configuration tables.
The service is configured in the database only.
The client app uses the service and allows displaying and editing data.
It supports conditional formatting, formulas, copy/paste, and undo/redo.
ODataDB uses the proven SaveToDB add-in configuration model.
Database developers can configure ways to save data, server-side event processing, lists of values, UI and data translation, and more.
Also, ODataDB implements a full-fledged model based on the OData standard and supports most of the standard features, such as using the batch update mode and the $filter function.
Because of this, you can use ODataDB with other OData clients, such as Microsoft Excel or Microsoft Power Query.
You can try ODataDB online:
https://odatadb.savetodb.com/en-us/budgeting-app.htm
https://odatadb.savetodb.com/en-us/planning-app.htm
Learn more about ODataDB Download