for SQL Server, Oracle, DB2, MySQL, and PostgreSQL
Just specify a connection string
and view and edit your database data online
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:
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:
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
You can use it from-the-box.
Moreover, it supports:
Play with it at samples.odatadb.com
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.
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.
We recommend starting with a learning resource for developers:
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.
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.
If you have any questions or concerns, please feel free to contact us.
|Office Hours:||8:00 AM - 4:00 PM EST|