I have been required to both consume and publish web services for a number of clients, most notably Brighton and Hove Council. Consuming web services has largely been enabled through OLE calls within SQL Server and subsequent parsing of the JSON or SOAP responses. Publishing of RESTful web services (usually with some for of SQL backend processing) has been achieved with a PhP wrapper, some conversion as necessary from JSON and then calls to a generic SQL Server database handler that passes off and distributes requests accordingly.
- automatic WSDL generation using SQL information schema
- PhP handler controlling connections and generating SQL execs
- Full audit of calls made
- Running under WAMP and IIS web servers