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

Posted 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.

Read More

Topics: DataHub, OPC Integration, OPC DA, OPC UA, Excel, DDE, Video Tutorials

Video Tutorial: Tracking the Health of Your Servers

Posted 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.

Read More

Topics: DataHub, OPC Integration, OPC DA, OPC UA, IT/OT, Alarming, Windows, Video Tutorials

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

Posted 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.

Read More

Topics: Device Integration, DataHub, Alarming, SMS, Email, OPC Integration, OPC DA, OPC UA, Video Tutorials

How to Connect, Integrate, or Communicate between Control Systems

Posted by Colin Winchester 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?

Read More

Topics: Automation 101, OPC, OPC DA, OPC UA, DataHub, Bridging, connectivity, OPC Integration, Device Integration

Logging Smarter - Dynamic Table Selection at Runtime

Posted 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.

Read More

Topics: OPC UA, OPC, OPC DA, OPC Integration, Logging, Data Logging, OPC Data Logger

Logging Only The Data You Need When You Need It

Posted 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.

Read More

Topics: OPC UA, OPC, OPC DA, OPC Integration, Logging, Conditional Logging, Data Logging, OPC Data Logger

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

Posted 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.

Read More

Topics: OPC UA, OPC, OPC Alarms and Events, OPC DA, OPC Integration, OPC Conversion, Device Integration, OPC Bridge, Bridging, DataHub

Break Down Your Obstacles to OPC Standard Interoperability

Posted 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.

Read More

Topics: OPC UA, Security, OPC, OPC Alarms and Events, OPC DA, OPC Gateway, OPC Integration, OPC Conversion, DataHub

Join Our Journey

Working in industrial automation since 1996, the Software Toolbox team has seen a lot. The level of automation system sophistication of our integrators and users has evolved, each driven by the demands of their market and clients.  Everyone's learning continues as technological change accelerates.

This blog is about sharing from these journeys.  From tips on implementing software, successes our clients have experienced, or new ideas and things to consider in your journey, we'll be sharing them here.

Subscribe to Our Blog

Recent Posts

Posts by Topic