ODATA is a data protocol that relies on REST, which relies on HTTP/S. It supports XML or the more compact/popular JSON. It works across proxies/routers/firewalls. One can use OAUTH2 or other authentication methods. There is a query language built in. The query language is not SQL, but ODATA’s own language.
ODATA supports INSERT, UPDATE, DELETE, SELECT… and many functions, including things like string functions, geo functions, math functions, etc. Note, the functions are not database functions, they are ODATA functions.
If you’re looking to use REST services to access/use your data in a database, ODATA is definitely worth a look!
While considering an API for your data application, you may want to also consider GraphQL (video).
Keywords: rest, data as a service, database as a service, daas, Open Data Access Protocol, rest, restful, http, https, ipas, ipaas
Troy Frericks.
blog 31-Mar-2020
troyf<at>CyberSecurityRecap.com
=
Copyright 2015-2020 by Troy Frericks, https://CyberSecurityRecap.com/, https://DBArecap.com/.
#