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

The sample shows how to load data using stored procedures and save changes to databases via SaveToDB

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

The sample shows how to create amazing reports using stored procedures with the DBGate app

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

The sample shows how to create amazing reports using stored procedures with the ODataDB app