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

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

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

Logging Smarter - Dynamic Table Selection at Runtime

5 min read

By Marc Holbach on Oct 26, 2017 2:00:00 PM


Does your data logging software force you to define the location where you're logging your data ahead of time?  Wouldn’t it be nice if your logging software could evaluate your data and make a decision on where the data should be logged?

In this first of two posts in a series on dynamic SQL logging, I'll show you how the OPC Data Logger can easily be configured to switch between SQL Tables at runtime, reducing any post-log sorting you have to do in SQL and saving you time and effort in the process.

Continue Reading

Logging Only The Data You Need When You Need It

6 min read

By Marc Holbach on Sep 14, 2017 2:00:00 PM


Do you need to log specific process data to a database or text file based on some predefined variable or condition? We typically refer to this concept as "conditional" or "condition-based" logging.  It sounds simple enough but without a plan, it can be a tricky task to implement.

In this post, I'll introduce you to the considerations involved with conditional data logging and cover how OPC Data Logger can easily be set up to log data based on a variety of conditions without a lot of headaches.

Continue Reading

Bridging the Gap between OPC, DDE, ODBC and Other Data Sources

5 min read

By Win Worrall on Sep 7, 2017 2:00:00 PM


Do you need to directly connect data points or variables in different equipment, processes, or software? This concept is commonly referred to as ‘point-to-point bridging,’ and the DataHub bridging capability allows multiple data sources to communicate with each other in real time.

In this second post of our “I Can Do That?” blog series, we’ll help users like you get the most out of your DataHub by understanding the bridging feature in detail and how this feature can often be combined with other features to accomplish some very powerful automation tasks.

Continue Reading

Break Down Your Obstacles to OPC Standard Interoperability

6 min read

By Win Worrall on Aug 24, 2017 2:00:00 PM


OPC has been around as an industry standard since 1996.  If you’ve been working in the space very long, you have probably heard all the different acronyms thrown around.  If you’re new, well there are different specifications in the OPC software interoperability standards that are used to meet different information integration needs.

In this first post of our “I Can Do That?” blog series, I’ll explore examples of the connections between different OPC standards we hear about from users, ways to address them using OPC Gateway software, and use cases highlighting solutions we’ve seen other users implement successfully.

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 - just use the area at the bottom of any post.

Subscribe to our Blog

Recent Posts

Posts by Topic

See all