Software Engineering Stack Exchange is a question and answer site for professionals, academics, and students working within the systems development life cycle. It only takes a minute to sign up.
Sign up to join this community
I work for a company whose point-of-sale service uses IIS servers tied to static IP addresses at each of our stores. My boss wants a better real-time stat tracker than what the point-of-sale service provides.
I would like to connect to these servers from a central location and retrieve the data. If possible, I'd like to be able to do so from Python, PHP, or Ruby. What are some recommended approaches for doing so.
The simplest way to expose a MS SQL Database to a remote client is to use WCF Data Services. Using Visual Studio, you can walk through a wizard that looks at the database and creates the service for you in minutes.
WCF Data Services exposes your data using an open protocol called OData. There is a consumer library for Ruby that will consume an OData service and allow you to do whatever you want with it.
