OData services from‑the‑box
with a built‑in JavaScript client

for SQL Server, Oracle, DB2, MySQL, and PostgreSQL

Just specify a connection string
and view and edit your database data online

Creating OData Services with ODataDB

To create an OData service, install ODataDB on Windows with IIS or on Linux with Apache or Nginx.

Then add a connection string to your database on SQL Server, Oracle, MySQL, or another supported platform like this:

ODataDB Connection String Sample

That's all. You can consume your service using the service root like /v4/<connection string name>/.

In this sample, the metadata URL is https://samples.odatadb.com/v4/mssql-023/$metadata

ODataDB reads the database metadata and creates a model like this:

ODataDB Metadata Sample

You can get and update data using standard OData protocol conventions via GET, POST, PUT, PATCH, and DELETE.

For example, you can get data from a stored procedure using a URL like
https://samples.odatadb.com/v4/mssql-023/s02_usp_cashbook2(account_id=1)

ODataDB OData Feed Sample

Built-in OData Client

ODataDB includes a built-in JavaScript client.

You can use it from-the-box.

Moreover, it supports:

  • Saving changes using the Save button
  • Saving data on cell changes
  • Copy and Paste
  • Undo and Redo
  • Column formatting
  • Conditional formatting
  • Excel-like formulas and running totals
  • Value lists for columns and parameters
  • Translating headers and parameters
  • Multiple languages and locales

Play with it at samples.odatadb.com

Cashbook Sample - en-us

ODataDB and SaveToDB

The SaveToDB add-in is another universal OData client that you can use.

Moreover, ODataDB and SaveToDB use the same application configuration framework.

So, your users can switch across the web application and Microsoft Excel.

Cashbook Sample - SaveToDB

ODataDB Benefits

Think, creating a well-designed database is quite enough to create an OData service and deliver a ready-to-use web application.

You can save a lot of time and deliver in-house applications faster.

You can use the same product on Windows and Linux, for SQL Server, Oracle, DB2, MySQL, PostgreSQL, and other platforms.

Download

We recommend starting with a learning resource for developers:

https://samples.odatadb.com

This course will allow you to understand all the ideas interactively.

Then download and unzip the installation package to a separate folder and launch the console application.

You will get a working service on port 5002 with the same examples.

See details at https://www.savetodb.com/odatadb/quick-start.htm.

You will find details on deploying ODataDB on Windows and Linux in various ways.

Download ODataDB 3.8

Prices

A single license costs $3600 and allows using ODataDB on up to five servers.

You can download the ROI Calculator to estimate your benefits.

We also recommend purchasing the warranty to upgrade to the next major versions at no additional cost.

Buy ODataDB

Contacts

If you have any questions or concerns, please feel free to contact us.

Sales:
Support:
Phone:1-415-230-0560
Office Hours:8:00 AM - 4:00 PM EST
This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.OK