DBGate allows viewing and editing database data in a browser.
It automatically creates REST services for defined connection strings reading database metadata.
For example, here is a URL to select and update the s02.cashbook table through the mssql-023 connection:
DBGate supports UI and data translation on-the-fly. For example, select a language below and try this example.
You may download these samples for SQL Server, Oracle, MySQL, PostgreSQL, and other platforms with the SaveToDB SDK.
This sample shows advanced features like data translation and value lists from primary key tables.
This sample shows advanced features of the SaveToDB Planning Application for Microsoft Excel and SQL Server.
The application contains typical tables like dimensions, members, and facts, a form builder, and the required infrastructure.
This sample shows basic features. It contains a simple plain table and several views and stored procedures based on the table.
It has only auto-configured features based on the database metadata.
This sample shows how to create multi-dimensional forms with calculated totals and conditional formatting.
It also uses a trick to return the required number of rows.
This sample shows typical solutions in application develepment.
This sample shows how to create calculated columns selecting formulas like =[@amount]*[@price].
The samples above use constant logins and passwords for demo purposes.
You may 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.