Exposing a database as an OData service eliminates the need to define queries, operation etc. to access the information in the database. OData (Open Data Protocol) is an OASIS standard that defines the best practice for building and consuming RESTful APIs. You can easily expose databases as an OData service using WSO2 Data Services ServerEI.
Table of Contents maxLevel 3 minLevel 3
...
This OData sample was generated to work with the default h2 database (DATA_SERV_SAMP.h2.db), which used for samples in the DSS EI product. This database is stored in the <DSS<EI_HOME>/samples/database directory. The details of this database are as follows:
...
You can find the DDL of these sql tables in <DSS<EI_HOME>/samples/sql/h2 folder.
...
The sample data service named ODataSampleService should be deployed and the server should be started using the instructions in Samples Setup.
Executing the sample
You can easily invoke the service using HTTP requests. See the following examples.
...