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.
In case you're not familiar with Combined Heat and Power Partnership (CHP), let me briefly break it down. CHP is a blanket term for technology systems that are designed to capture wasted heat produced during electricity generation. That reclaimed heat is then used to provide thermal energy (commonly in the form of steam and/or hot water) for use in other parts of the process or for facilities infrastructure such as space heating/cooling and consumable hot water. As such, CHP's applicability and usefulness is not limited to any one industry.
CHP can technically be applied on any project where there is significant waste heat being generated on a regular basis. It has been successfully applied across the gamut of commercial and residential buildings, at institutions such as universities and hospitals, for municipal facilities such as power generation and wastewater treatment and in manufacturing process such as chemicals, refining, pulp & paper, food & beverage and more.
The Use Case - Reliable Collection and Storage of Existing Process Data
So, for our use case, a research and development firm in Germany was tasked by the government to develop a model for economic and technological optimization of CHP heating in conjunction with large heat storage systems. At the pilot project site, a local heating network was equipped with a Flex-CHP plant, large heat storage systems and electric water heating (Power2Heat).
Dimensioning and operation of the CHP system will be optimized via modelling, which requires large amounts of historical data from the current process. One of the goals is developing an acceptable concept for heat storage that permits production of electricity independently from heating demand.
Important factors for such a heat storage system are type and size of the heat storage as well as hydraulic connections. The concept will be implemented at the pilot project site and relevant operating modes will be tested during trial operations.
Once complete, a comparative assessment including a transfer concept will be developed in order to achieve transferability to other enterprises and application.
The Data Collection Concept for CHP
The CHP-related systems referenced earlier at the pilot project site were equipped with Programmable Logic Controllers (PLCs) from Siemens, Hitachi and Honeywell for control of the system, each with their own existing OPC Server for data collection from the PLCs.
The R&D firm had already specified that the data would be pushed to a SQL database for storage until the end of the 6 month data collection period, after which, they would analyze the data for development of patterns that could used for the optimization model. Having previously used the OPC Data Logger successfully on an unrelated project for logging process data to SQL, the firm was confident in the reliability and performance of OPC Data Logger for this project as well.
OPC Data Logger Provided a Robust Data Logging Engine
The OPC Data Logger is typically chosen for effective event-driven logging, as it was in this use case. It's wizard-based user interface provides easy-to-use flexibility for users with any skill level. OPC Data Logger stores data to standard SQL/ODBC database, including Microsoft Azure SQL, or text/CSV files. Here are several of the key reasons OPC Data Logger is typically chosen for projects like this CHP pilot:
Suitable for virtually any project where you simply need to log OPC process data to a text file or database, the OPC Data Logger is a reliable, cost-effective option. Interested in trying for yourself? Download the free OPC Data Logger trial to try conditional logging with your own OPC data sources. (For how-to video resources on using the OPC Data Logger, click here.)