for SQL Server, Oracle, DB2, MySQL, MariaDB, PostgreSQL, and Snowflake
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 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 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
Gartle Budgeting allows budgeting in Microsoft Excel and online,
saving data in a Microsoft SQL Server database.
The app takes full advantages of budgeting in Excel and adds new ones:
The app targets companies that already keep records in Microsoft Excel or are about to start budgeting in Excel.
The application includes an accounting module that can be configured to meet the requirements of IFRS and US GAAP.
The screenshot shows an example of an interactive budget report.
You can try the application online:
https://dbgate.savetodb.com/en-us/budgeting-app.htm
Learn more about Gartle Budgeting Download
Gartle Planning is a planning application based on a relational cube in Microsoft SQL Server and clients as Microsoft Excel and DBGate or ODataDB.
The application allows:
The screenshot shows an example of budget reports.
Users can obtain data from any slice.
Users can get the cell source data from the context menu.
You can try the application online:
https://dbgate.savetodb.com/en-us/planning-app.htm
Learn more about Gartle Planning Download