Logging industrial process data to a database such as Microsoft SQL is a common requirement of many projects across industries. One of the key applications for storing industrial process data is providing historical context and reporting of the process so that better decisions can be made.
Software Toolbox Technical Blog
2 min read
5 min read
Standards-based industrial device connectivity such as OPC has become the norm over the last 20 years. What used to be achieved by individual HMI/SCADA vendors with their own native drivers can now be easily accomplished with OPC drivers that are HMI/SCADA vendor agnostic. TOP Server offers connectivity to thousands of device types and protocols while making those devices accessible via a variety of standard interfaces including OPC UA, OPC DA and SuiteLink.
But what you may not be aware of is that TOP Server for Wonderware has an available driver suite called the OPC Client Suite that allows it to also act as an OPC UA client, OPC DA client and OPC XML-DA client. In this post, I'm going to go through the top 3 most common use cases for the OPC Client Suite that we see users take advantage of.
8 min read
If you're unfamiliar with Modular Procedural Automation (MPA), it helps automate start-up, shutdown and other data-driven procedures in a process, increasing efficiency, optimizing production, and reducing wear and tear on equipment. Additionally, MPA helps increase operator productivity and confidence.
Adapted from the case study in Control Magazine, this blog post covers how Air Liquide, a world leader in chemicals manufacturing, is migrating to MPA using OPC UA and OPC bridging to lower startup time by over 60% and increase production to over 500 additional tons of liquid oxygen (LOX) resulting in increased profitability.
4 min read
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.
4 min read
If you're unfamiliar with state based control, it's a process automation design that essentially defines that all process facilities should operate in a recognized, definable state with previously defined normal and abnormal conditions with defined actions for each. State based control is intended to allow company's in virtually any process industry to greatly reduce factors of human error and inconsistency, significantly increasing the efficiency of all processes.
In this blog post, we cover how a large chemicals manufacturer migrated to state based control using OPC UA and increased their efficiency, production levels and profitability as a result.
2 min read
For many industries, where having access to process data is critical, it's common to implement redundancy on many levels to ensure there is no disruption to data collection. While there are different levels of redundancy, the one we see users most interested in is with OPC data source redundancy.
The following short video blog demonstrates step-by-step just how easy it is to configure the Cogent DataHub to handle redundant failover between OPC UA data sources, OPC DA data sources and more.
3 min read
Recently we worked with an aluminum smelter operation that has doubled in size since it first opened and has made a significant positive impact on the local economy by supplying aluminum to local industries which has fueled their growth.
Like any growing business, this user is always seeking ways to improve operations and reduce risk of downtime. In the end they need to deliver returns to their shareholders while continuing to support the local community, all of which requires consistent predictable operational results. In this blog post, we'll cover how they used an off-the-shelf solution for integrating varied systems to reduce life cycle costs.
1 min read
OmniServer's core connectivity and data parsing abilities are only part of the equation when integrating non-standard devices with Wonderware. How does that device data then make it up into Wonderware?
In this video blog, part of a series on connecting Wonderware to OmniServer, I'll show you how to make a basic OPC DA connection from Wonderware System Platform to OmniServer for integrating process data from all of your "other" devices that don't have a standard, off-the-shelf driver - all without having to write custom code.
4 min read
If you’ve been following our blog series on custom error detection, you’ll remember that OmniServer provides a large number of pre-defined Error Detection Codes (EDC) for use in different protocols for non-standard device communication. And, again, it’s not uncommon to find an EDC from a vendor that is not pre-defined due to some specialized handling by the device manufacturer.
As we covered in our previous posts on creating a custom checksum and LRC, OmniServer gives you the ability to build custom EDCs in an OmniServer protocol to handle these situations. This post, the final of three on custom Error Detection Codes, covers the basics steps to creating a custom CRC (Cyclic Redundancy Check) in an OmniServer protocol.
4 min read
You may be aware that OmniServer provides a wide variety of pre-defined Error Detection Codes (EDC, also known as CRC, LRC and Checksums) for use in protocols for non-standard device communication. However, it’s not uncommon to find an EDC that isn’t pre-defined due to some specialized handling by the device manufacturer.
To handle such situations, OmniServer provides the ability to build your own custom EDCs in an OmniServer protocol. This post, the second of three on custom Error Detection Codes, will cover the basics of creating a custom LRC (Longitudinal Redundancy Check) in OmniServer.
1 min read
With DDE (Dynamic Data Exchange) fast becoming obsolete technology (Microsoft superseded DDE with OLE years ago), OPC DA and, more recently, OPC UA data sources have become the primary go-to for process data integration. Recently, Microsoft even disabled certain DDE functionality in MS Office applications due to security concerns and malware exploitation targeting the DDE interface.
But the usefulness of MS Excel for data analysis across many industries even today is still undeniable and the primary mechanism for MS Excel to connect to a data source is via DDE. So what do you do if you're still using MS Excel for process data analysis and reporting via DDE? What's the alternative?
The following short video blog demonstrates step-by-step how to easily read/write data from process data sources (OPC DA and OPC UA Servers) using MS Excel (without DDE) with the Cogent DataHub.
4 min read
If you’ve worked with OmniServer to connect your non-standard devices in the past, you may be aware of the large number of pre-defined Error Detection Codes (EDC, also known as CRC, LRC and Checksums) available. However, as is the nature of custom protocols out there, it’s not uncommon to find an EDC that isn’t pre-defined due to some specialized handling by the device manufacturer.
To that end, OmniServer provides the flexibility to define your own custom EDCs in an OmniServer protocol. This post, the first of three on custom Error Detection Codes, will cover the basics of creating a simple custom checksum in OmniServer.