ODataDB Samples

Preface

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.

Also, ODataDB includes a JavaScript client-side part that allows getting and updating data via OData.

ODataDB supports UI and data translation. For example, try

Try these examples first: s02_usp_cashbook2, s02_usp_cash_by_months

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.

Sample 02 - Advanced Features

This sample shows advanced features like data translation and value lists from primary key tables.

ODataDB configures features reading the database metadata and configuration tables like xls.handlers and xls.translations.

Planning Application

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.

Sample 01 - Basic Features

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.

Sample 17 - Budget Request

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.

Sample 16 - Symbol Lists

This sample shows typical solutions in application develepment.

Sample 04 - Order Form

This sample shows how to create calculated columns selecting formulas like =[@amount]*[@price].

TripPin Sample

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.

Authentication

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.