ODataDB allows creating corporate web applications.
ODataDB includes an ASP.NET Core 3.0 server-side part that creates an OData service reading database metadata.
Database developers may customize the service using special configuration tables like xls.handlers and xls.translations.
ODataDB supports UI and data translation. For example, try
Please note that all samples use database-side configurations only except for CSS styles for several sample reports.
You may download samples for the required database platform 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].
This sample shows how to use external OData services. It uses the TripPin sample at odata.org.
The trick is in the using of a separate edit page with the absolute API URL in the data-api-root value.
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.