Difference between revisions of "Category:OData Functions"
Barrymavin (Talk | contribs) |
Barrymavin (Talk | contribs) |
||
(7 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
{{DISPLAYTITLE:Working with OData}} | {{DISPLAYTITLE:Working with OData}} | ||
+ | ==Overview== | ||
Lianja Cloud Server supports OData-compatible data access. The Server handles ODBC connections as well as HTTP requests using OData URIs. You can use the Lianja Cloud Server with OData URIs that will allow you to perform CRUD (Create, Read, Update and Delete) operations on native Lianja data or any third party SQL databases using [[Virtual Tables]]. | Lianja Cloud Server supports OData-compatible data access. The Server handles ODBC connections as well as HTTP requests using OData URIs. You can use the Lianja Cloud Server with OData URIs that will allow you to perform CRUD (Create, Read, Update and Delete) operations on native Lianja data or any third party SQL databases using [[Virtual Tables]]. | ||
Line 13: | Line 14: | ||
</div> | </div> | ||
==See Also== | ==See Also== | ||
− | [ | + | [[:Category:Lianja_Cloud_Server|Lianja Cloud Server]], [[Working_with_JSON_and_JQL|Working with JSON and JQL]] |
− | [[ | + | ==Lianja Cloud Server Settings== |
+ | ===Linux and macOS=== | ||
+ | The following environment variables should be set to true for Lianja Cloud Server to enable the HTTP service and OData-compatible data read/update access: | ||
+ | |||
+ | <pre># HTTP Service | ||
+ | DB_HTTP_ENABLED="true" ;export DB_HTTP_ENABLED | ||
+ | # | ||
+ | # OData Service | ||
+ | DB_ODATA_READ_ENABLED="true" ;export DB_ODATA_READ_ENABLED | ||
+ | DB_ODATA_UPDATE_ENABLED="true" ;export DB_ODATA_UPDATE_ENABLED</pre> | ||
+ | |||
+ | These are set in the files: | ||
+ | |||
+ | {| class="wikitable" width=100% | ||
+ | |- | ||
+ | |valign="top"|[[Lianja_Server_Manager_on_Linux|Linux]] | ||
+ | |valign="top"|/etc/lianja.d/lianja.conf | ||
+ | |- | ||
+ | |valign="top"|[[Lianja_Server_Manager_on_Mac|macOS]] | ||
+ | |valign="top"|/usr/local/lianja/server/conf/lianja.conf | ||
+ | |- | ||
+ | |} | ||
+ | |||
+ | The Lianja Cloud Server can also optionally listen on port 80, this is false by default: | ||
+ | |||
+ | <pre># Used to determine if the HTTP Server will also listen on port 80 | ||
+ | DB_PORT80_ENABLED="false" ;export DB_PORT80_ENABLED</pre> | ||
+ | |||
+ | To integrate Lianja Cloud Server on Linux in with Apache, see [[Apache Module for Linux]]. | ||
+ | |||
+ | ===Windows=== | ||
+ | On Windows, use the [[Lianja_Server_Manager_on_Windows|Lianja Server Manager]] to '''Enable HTTP server''' and optionally '''Enable HTTP port 80''': | ||
+ | |||
+ | [[{{ns:file}}:l5_wserveman4.png|link={{filepath:l5_wserveman4.png}}|HTTP Settings tab]] | ||
+ | <br clear=all> | ||
+ | |||
+ | and to '''Enable OData Read service''' and '''Enable OData Update service''': | ||
+ | |||
+ | [[{{ns:file}}:l8_wserveman5.png|link={{filepath:l8_wserveman5.png}}|Security tab]] | ||
+ | <br clear=all> | ||
+ | |||
+ | To integrate Lianja Cloud Server in with IIS, see [[ISAPI Extension for IIS]]. | ||
+ | |||
+ | ==Testing OData URIs== | ||
+ | You can test OData URIs from the address bar of your browser: | ||
+ | |||
+ | [[{{ns:file}}:odata_in_addressbar.png|800px|left|border|link={{filepath:odata_in_addressbar.png}}|OData in Browser Address Bar]] | ||
+ | <br clear=all> | ||
+ | |||
+ | Above showing in each case a read of an entire table from the southwind database on the default port 8001 of localhost in a range of browsers: | ||
+ | <pre>http://localhost:8001/odata/southwind/orders</pre> | ||
+ | <pre>http://localhost:8001/odata/southwind/products</pre> | ||
+ | <pre>http://localhost:8001/odata/southwind/shippers</pre> | ||
+ | |||
+ | For the full supported URI syntax see [[OData URIs]] and for a list of operators see [[OData Operators]]. | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Lianja Server]] | [[Category:Lianja Server]] | ||
− | [[Category:Lianja_Cloud_Server]] | + | [[Category:Lianja_Cloud_Server]] [[Category:Functions]] |
Latest revision as of 03:04, 18 May 2024
Contents
Overview
Lianja Cloud Server supports OData-compatible data access. The Server handles ODBC connections as well as HTTP requests using OData URIs. You can use the Lianja Cloud Server with OData URIs that will allow you to perform CRUD (Create, Read, Update and Delete) operations on native Lianja data or any third party SQL databases using Virtual Tables.
Making OData requests from jQuery and/or the Lianja HTML5 Client in a Web App is extremely straightforward and simple.
Unlike other OData implementations, Lianja Cloud Server OData services does not require any server-side configuration of web services.
You can use OData with disparate SQL databases using Virtual Tables
See Also
Lianja Cloud Server, Working with JSON and JQL
Lianja Cloud Server Settings
Linux and macOS
The following environment variables should be set to true for Lianja Cloud Server to enable the HTTP service and OData-compatible data read/update access:
# HTTP Service DB_HTTP_ENABLED="true" ;export DB_HTTP_ENABLED # # OData Service DB_ODATA_READ_ENABLED="true" ;export DB_ODATA_READ_ENABLED DB_ODATA_UPDATE_ENABLED="true" ;export DB_ODATA_UPDATE_ENABLED
These are set in the files:
Linux | /etc/lianja.d/lianja.conf |
macOS | /usr/local/lianja/server/conf/lianja.conf |
The Lianja Cloud Server can also optionally listen on port 80, this is false by default:
# Used to determine if the HTTP Server will also listen on port 80 DB_PORT80_ENABLED="false" ;export DB_PORT80_ENABLED
To integrate Lianja Cloud Server on Linux in with Apache, see Apache Module for Linux.
Windows
On Windows, use the Lianja Server Manager to Enable HTTP server and optionally Enable HTTP port 80:
and to Enable OData Read service and Enable OData Update service:
To integrate Lianja Cloud Server in with IIS, see ISAPI Extension for IIS.
Testing OData URIs
You can test OData URIs from the address bar of your browser:
Above showing in each case a read of an entire table from the southwind database on the default port 8001 of localhost in a range of browsers:
http://localhost:8001/odata/southwind/orders
http://localhost:8001/odata/southwind/products
http://localhost:8001/odata/southwind/shippers
For the full supported URI syntax see OData URIs and for a list of operators see OData Operators.
Pages in category "OData Functions"
The following 8 pages are in this category, out of 8 total.