The SaveToDB add-in for creating corporate applications with Microsoft 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 cross-platform REST service and JavaScript client for creating corporate 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 cross-platform OData service and JavaScript client for creating corporate 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://samples.odatadb.com/en-us/budgeting-app.htm
https://samples.odatadb.com/en-us/planning-app.htm
Learn more about ODataDB Download
Gartle Budgeting as a ready-made application for budgeting in Microsoft Excel and online
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:
- It stores data in a database but not in Excel workbooks
- It uses unified server-side rules for calculations
- It allows getting source data for each report cell
- Calculations and reports are fast
- It allows storing reports in a database
- Users can create consolidated reports based on stored reports
- It allows managing data access
- It allows tracking data changes
- Users can work in Microsoft Excel and a browser
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 as a ready-made application for planning in Microsoft Excel and online
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:
- Planning for multiple companies in a single database
- Planning in multiple currencies with different tax rates
- Customizing dimensions, members, and aggregation methods
- Customizing input forms and output reports
- Customizing reports in Excel based on data from a database
- Managing user permissions and item relationships
- Importing and exporting data
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
