Disclaimer While doing a research for a SCADA integration project, I found this document on Google cache as the main site was unavailable. It has some good points and may be useful for anyone looking for this comparison.
Many people question the concept of using SOAP or REST based services to deliver data from a database when they could potentially use SQL/ODBC. In general terms, if your requirement is for complex SQL/ODBC queries, SQL/ODBC is the way to go. However, when the requirement is less about complex queries and more about accessing and/or updating the data, SOAP and REST provides many advantages in today’s' networks.
Feature | SQL/ODBC | SOAP/REST |
---|---|---|
Standards | While an SQL standard exists, there are different flavors implemented by different databases. | Fully standards based using WSDL, SOAP, REST, XML, HTTP and TCP/IP |
C |