Software Toolbox Technical Blog

Video Tutorial: Easy Integration of Your OPC DA/UA Data with MS Excel

1 min read

By Win Worrall on Apr 5, 2018 2:00:00 PM

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.

Continue Reading

Building Error Detection Codes for Custom Protocols

4 min read

By Kevin Rutherford on Mar 15, 2018 2:00:00 PM


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.

Continue Reading

Video Tutorial: Tracking the Health of Your Servers

1 min read

By Win Worrall on Mar 8, 2018 2:00:00 PM

Knowledge is power and knowing the current state of your underlying server hardware for your process can be very powerful indeed.  Keeping a pulse on information like CPU usage, available memory, memory consumption by a process and whether or not critical process are still running can be the difference between hours of downtime with thousands of dollars in lost production and being able to proactively avoid any downtime.

The following short video blog demonstrates step-by-step how easy it is to use the Cogent DataHub to monitor vital system statistics on your servers that can be shared in real-time via supported client interfaces such as OPC DA and OPC UA or even send email/SMS notifications.

Continue Reading

Integration of Vibration Monitoring Hardware into HMI, SCADA, MES, & Historians

1 min read

By John Weber on Feb 21, 2018 2:00:00 PM


Software Toolbox has worked with integrators, users, OEMS and distributors of Wonderware Software products since 1997.  At a Schneider Electric Software conference in 2017, they met a hardware supplier new to the Wonderware user community, Test Products International, also known as TPI.  It turns out TPI is not new to the vibration monitoring space, though, and has a long history of providing handheld test and measurement equipment. In this video blog...

Continue Reading

3 Reasons to Be Excited about OPC Data Client 2018.1 Release

4 min read

By John Weber on Feb 14, 2018 2:00:00 PM


Our latest release of the OPC Data Client development toolkit provides some exciting new features for leveraging powerful OPC UA technology features including OPC UA complex data support.

In this post, we will cover some of the key reasons the OPC Data Client 2018.1 is an easy, effective method for bringing the power of OPC UA to your custom client applications.

Continue Reading

Your Data Logger Wouldn’t Just Throw Away Data. Or Would It?

5 min read

By Marc Holbach on Feb 1, 2018 2:00:00 PM


What is the most important feature for any data logger to have? At the end of the day, we are trusting a data logger to take our data and store it.  Now whether that is for reporting, optimization, legal reasons, or simply to retain process data over some period of time in case it might be needed later, we expect the data to be logged without any losses.

This is particularly true in the industrial automation space, where the amount of data that is being logged is growing almost as exponentially as the speed at which the data is needed in order to have a business impact. As such, the prospect of losing data can very quickly result in lost jobs, thousands of dollars in lost production, and legal or financial penalties in case of an audit.

So how much do you trust your data logger to really be logging 100% of the data that it should be? In this blog post, I will address these concerns and highlight the ways OPC UA provides capabilities that software applications can leverage to provide peace of mind.

Continue Reading

Video Tutorial: Sending Email & SMS Alerts Triggered by Process Values

1 min read

By Win Worrall on Jan 25, 2018 2:00:00 PM

Timely notifications about abnormal conditions in your process are vital to minimizing downtime and the costs associated with it.  Automating the process based on the condition of specific process variables gets you the information you need for making decisions as quickly as possible.

The following short video blog demonstrates step-by-step how easy it is to use the Cogent DataHub to establish a connection to an OPC data source and then define various flexible conditions for triggering email and/or SMS text notifications based on values collected from that OPC server.

Continue Reading

How to Connect, Integrate, or Communicate between Control Systems

7 min read

By John Weber on Jan 11, 2018 2:00:00 PM

Our Automation 101 blog series is designed to help professionals that are new to the industrial automation space whether at the start of their careers, or moving into the operations technology (OT) world from an IT or other background.

One of the common challenges in Industrial Integration is communications between different brands or manufacturers’ control devices (PLC, DCS, Drives, RTUs, smart sensors).  While most control devices have methods of communication, and some industry standards have helped, they don’t all communicate using the same methods or protocols, and even if they both have the same serial or Ethernet wiring the difference in communication protocols prevents them from passing information.  It’s the same problem you have if someone calls you on the phone, but doesn’t speak the same language.

While, as humans, we may be able to overcome a difference in dialect, machine communication has to be precise and exact.  Small differences in addressing or data formatting can be enough variation to create communications failure. So how do people overcome this challenge?

Continue Reading

About this Blog

We're engineers like you, so this blog focuses on "How to" appnotes, videos, tech team tips, product update announcements, user case studies, and other technical updates.  Subscribe to updates below. Your feedback and questions on posts are always welcomed.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all