Probably time has come when people are fed up of installing SQL clients and setting various environment variables and burning calories in trying to figure out the connect string.
The new OData protocol by microsoft to expose data as a service a initiative to take u out of installing SQL clients and allows to one to do SQL processing via simple HTTP protocol and returns data in JSON or ATOM format.
The description of OData as by Microsoft is
"The Open Data Protocol (OData) is a Web protocol for querying and updating data that provides a way to unlock your data and free it from silos that exist in applications today. OData does this by applying and building upon Web technologies such as HTTP, Atom Publishing Protocol (AtomPub) and JSON to provide access to information from a variety of applications, services, and stores. The protocol emerged from experiences implementing AtomPub clients and servers in a variety of products over the past several years. OData is being used to expose and access information from a variety of sources including, but not limited to, relational databases, file systems, content management systems and traditional Web sites."
So in simple words to develop a web app all u need is a a language supporting HTTP protocol (which is supported in almost all) and identify a proper service. There are various libraries also developed for various languages. The another advantage is not only SQL but others forms of data can also be exposed via ODATA.
This makes using a exposed service as easy as using any RSS feeds.
Chk out more on http://www.odata.org/home
Well i will be back later with more information....
No comments:
Post a Comment