At Software Toolbox, we commonly hear from users seeking a solution for connecting and gathering data from this or that type of hardware. Beyond that, though, is what users do with the data once they have it. A common need is reliably logging process to a database such as Microsoft SQL server.
In this blog post, we’ll discuss a specific use case of a German R&D firm needing to collect data from multiple OPC data sources and log that data to a SQL database for further analysis geared towards a pilot project developing a model for optimizing Combined Heat & Power Partnership (CHP) technology for transferability to many enterprises where heat and power generation are essential to the process.