What technology to deploy RESTful Server with SQL+COM capability

manpreet Best Answer 3 years ago

We're developing a cloud based web application for customer management. One of the main goals i the capability to connect to different local applications on the customer endpoint.

As example, we don't want to have a customer database in out application, the customer should be able to search within his local ERP system right away.

What we need is not much. Only a client on the customers server with com/tag/access">access to the local SQL server as well as the COM model.

But as webdevelopers and mainly going with PHP the question came up, what technology we should use?

I've got two approaches in mind:

NodeJS Lightweight, Javascript and with the Express and winole32 extension we should have everything we need. But the deployment and com/tag/installation">installation as a service seems to be a bit wacky.

C# .Net Web API Also a good approach I guess since the client servers are allways windows. But is there a way without IIS?

Or do you have something completely different in mind? It should be very fast and compact. So its basically just a RESTservice that can be deployed with ease.

Thanks for your inputs and thoughts.

manpreet 3 years ago

C# .Net Web API Also a good approach I guess since the client servers are allways windows. But is there a way without IIS

It is called OWIN and it is properly documented (web api self host is a good keyword) and works like a charm. Using that on various services to expose an API into the service.