Software Toolbox Technical Blog

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.

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.

When you live in a remote region that is one of the most arid places on earth, you import your raw materials, and you’re making millions of hectoliters of beer a year, you have to make the most of all the resources you have and leverage what is in abundance in your location.  Namibia Breweries Ltd. (NBL) has a long history of success in a tough environment at their Windhoek site. They have received numerous awards for their innovative approaches to meeting their information system needs.

In this blog post, we’ll share their look into how they use off-the-shelf software and their teams' intellectual know-how and creativity to empower their manufacturing success.  If you read the stories in Automation World or Pro Food World you learned about how Andre Engelbrecht, manager of industrial control systems at NBL, and his teammates Annemarie Kruger, Rolando du Pisani and others unlocked data sources and built a digital smart manufacturing platform across the entire facility.  In this article, we’re going to share the rest of the story of NBL’s integration points, problems solved, and how they leveraged Software Toolbox’s full value proposition as part of their team effort.

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.

The New Year is a time of renewal, new projects, new challenges, and for some of you, new roles, or new people on your teams.  The last year has been one where our team has grown and worked to deliver the relevant content you need to learn more about software for automation & control, how to use our products, and the type of problems we solve.

In this blog post, we’ll provide a quick review of some key items from the last year that can help you or your colleagues in the coming year.  If you aren’t already subscribed to our blog, we encourage you to . We publish new content at least once a week, sometimes more often, and you can control the frequency of when you are notified of new content.

Our  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?

The heart of any control system is the computers and servers that run your automation software.  For example, when PLCs talk to AC drives over Ethernet, the drives will shut down if they lose communications for more than a second, sometimes even milliseconds.  Drives shutdown = Line shutdown = Plant shutdown.  What IT calls a blip for plant operations can mean downtime, scrapped product and even your company’s reputation due to missed delivery deadlines.

Traditionally, server maintenance and upkeep is the role of IT.  However, when these systems go down, it affects operations (OT) with different pains than IT sees on the business side.  IT has systems to monitor their own assets, on the standards they need for the business, but they need the OT side to expand monitoring of their own systems and self-reliance in order for OT to meet operational needs, while bringing in IT as a resource.

This blog post will discuss how to get information about health of servers and PCs that runs the automation software OT users need without having to rely solely on IT.

It is common for companies to use databases for long-term storage of their critical information.  In our experience, we also see machine setup information, short term operational data and much more besides traditional historical data put into shop floor databases in the operations technology or “OT” world.

Over on the business side or the “IT” world, everything somehow ends up in a database: Production plans, forecasts, orders, it’s all there.  Increasing business demands and IT/OT convergence are driving more real-time integration between these databases and control systems.

This blog discusses some of the key reasons users like yourself need this information and then shows how the DataHub can help move this data from a database to your control systems via OPC DA, OPC UA, Modbus and other interfaces or protocols that are common in the automation layer.