SQL Server as a web service

[James Bott]

Is anyone using a web service for your SQL database? If so, which one? Pros and cons?

Currently, I am hoping to find a free or inexpensive one for some prototype development. I am looking for a web service so it is accessible from anywhere.

Thanks,
James

[reinaldocrespo]

Hi, James;

ADS 11 offers web services. You may access your own dbfs from any browser using php/java/ruby either with the native client for each of these languages or simply use web-service calls. They have implemented the xml structure with the oData standards. SAP will provide you with a free 2 user server version good for development. There is a also a free training "Summit" every October in Boise. At deployment time, SAP-ADS offers the least expensive SQL engine on the market (other than free and no support).

Hope that helps,


Reinaldo.

[modicr]

As already mentioned, you can use OData ...

http://scn.sap.com/community/developer- ... nywhere-16

OData is quickly becoming the Lingua Franca for data exchange over the web. The OData standard defines a protocol and a language structure for issuing queries and updates to remote data sources, including (but not limited to) relational databases, file systems, content management systems, and traditional web sites. It builds upon existing Web technologies, like HTTP and RESTful web services, the Atom Publishing Protocol (AtomPub), XML, and Javascript Object Notation (JSON).
---
It can speed the development and prototyping phase, by allowing quick creation and modeling of OData services, without requiring heavy backend or EIS development.
It can enhance the security of a production web services environment by eliminating the need for HTTP access directly to the database server.
It can reduce the overall complexity of an n-tier application by eliminating the need to write middle-tier components that do nothing by transform data into JSON or XML.

http://www.odata.org/ecosystem

http://www.nsoftware.com/kb/help/IPA9-A/OData.rst
.