DBGate allows creating corporate web applications.
It includes an ASP.NET Core server-side part that creates REST services reading database metadata.
Database developers can customize services using special configuration tables like xls.handlers and xls.translations.
Also, DBGate includes a JavaScript client-side part that allows getting and updating data via REST API.
So, database developers can create corporate web applications for existing databases in a couple of hours.
All the samples below use the database-side configurations except for CSS styles in several samples.
You can download these samples for SQL Server, Oracle Database, MySQL, and PostgreSQL with the SaveToDB SDK.
This sample shows basic features available with zero configuration.
You can load data from tables, views, and stored procedures and save data changes back to a database.
Full Article | cashbook | view_cashbook | usp_cashbook | usp_cash_by_months
This sample shows the advanced features used to build corporate applications.
For example, try dynamic parameter values and filtered drop-down lists, conditional formatting, and UI and data translation.
Full Article | usp_cashbook2 | usp_cashbook3 | usp_cash_by_months
This sample shows how to embed DBGate forms and use formulas like =[@amount]*[@price].
This sample allows testing supported data types via different .NET, ODBC, and OLEDB data providers.
This sample shows how to create forms to work with many-to-many relations.
This sample shows how to create multi-dimensional input forms with calculated totals and conditional formatting.
This sample shows how to create forms using the PIVOT operator or JSON output.
This sample shows DBGate API usage examples.
This sample shows how business-users can create applications with the Tab Framework.
Gartle Budgeting is a commercial ready-to-use budgeting application with the accounting module.
The primary client is Microsoft Excel. However, it works in DBGate as well.
Full Article | Request 101 | Request 201 | Request 301 | Request 401 | Totals | Budget Reports | Actual Reports | Trial Balance
Gartle Planning is a commercial ready-to-use planning application.
The primary client is Microsoft Excel. However, it works in DBGate as well.
Full Article | Request 101 | Request 201 | Request 301 | Request 401 | Accounts*Times | Accounts*Entities
The examples above use logins with given passwords for demo purposes.
You can try any sample using the following logins with a common password: Usr_2011#_Xls4168
To reset the login, close the browser and open the page once again.
AzureDemo100 | sample01_user1, sample02_user3, sample04_user1, sample16_user1, sample17_user1, sample20_user1 |
gBudgetingApp | ba_analyst_01, ba_accountant_01, ba_admin_01, ba_user_101, ba_user_201, ba_user_301, ba_user_401 |
gPlanningApp | pa_analyst_01, pa_admin_01, pa_user_01 |
© 2020-2024 Gartle LLC | www.savetodb.com | DBGate Guide | Developer Guide | Privacy Policy | Cookie Policy