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

Can Your OPC Tunnel Unlock All of Your Data Sources?

2 min read

By Win Worrall on Aug 23, 2016 12:39:14 PM


The word tunneling, when it comes to industrial automation and data, typically goes together with OPC.  OPC tunneling is generally the most common form of tunneling, but what if your data sources aren't OPC?

What if you have more than just OPC clients and servers in your architecture and those non-OPC data sources have vital information that needs to be collected and shared with your other systems?

This blog post will discuss why it's  important for a tunneler solution to support more than just OPC-capable data sources in a diverse control system.

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