Hello, I have a background in software, but I'm a newbie at HVAC control systems. My current mission at work is to select/purchase/install a set of temperature sensors, collect the data in (near) real-time, and insert it into a SQL database. The data will later be displayed as a new object on the company's Business Intelligence portal, and have alerts that go off based on temp thresholds (..but that is a different beast).
What I'd like to ask is if anyone could please recommend a good starter system that could be deployed to a relatively small department area (8 room sensors) at first, but then be scaled out to around 100 sensors if/when this project gets deployed to the whole company? The most important factor for me is that the data comes into the server in some kind of 'open' format that I can pick up and read using custom code. If there were some kind of widows ODBC connector to SQL Server '08, then that would be ideal, but I'd be happy even if the device could output plain text delimited files.
If anyone has done a project similar to this, I'd love to talk with you and get some feedback on the approach I'm taking. Also I'd be willing to trade some help getting your data to display nicely on a BI dashboard in exchange for some help getting the raw data in on my end.