Software Toolbox Technical Blog

DataHub – 5 Quick Steps to Writing to a Database Table

10 min read

By Kyle Persyn on Jan 18, 2024 2:00:00 PM

If you've been keeping up with our previously released Cogent DataHub blogs, you're already aware that Cogent DataHub is renowned for its extensive connectivity. However, it's worth emphasizing that DataHub's connectivity includes MQTT, IoT, OPC DA, OPC UA, OPC UA Alarms & Conditions, OPC Classic Alarms & Events, Modbus, Excel, ODBC & more. These methods of connectivity help users realize that with DataHub, data has the freedom to seamlessly traverse across various platforms. We truly believe that "once the data is in DataHub, it can go anywhere, securely".

Continue Reading

Why Are My Data Values Wrong? - Exploring Modbus TOP Server Settings

12 min read

By Ryan Royse on Jan 11, 2024 2:00:00 PM

In the world of industrial automation and control systems, communication protocols play a crucial role in ensuring seamless data exchange between devices. Modbus started as a protocol used in Modicon, now Schneider Electric, PLCs in the 1970’s. It was adopted across the industry for its clarity and simplicity. With any protocol, including and especially with Modbus, there are areas where the parties to the communication, the client and server, can interpret the bit stream of data differently once exchanged because the Modbus protocol specification does not speak to those interpretations.

Continue Reading

Data Exchange File Formats: Exploring ETL Tools with OPC Router

3 min read

By Nicole Knox on Dec 21, 2023 2:00:00 PM

To achieve operational and business goals, many industrial automation system architectures are designed to push and pull data from a multitude of sources and destinations that come with a variety of formats. Bridging the gap between systems that use distinct standards and protocols can be challenging if the right tools aren't properly selected, and too often users resort to custom software. This is where users can leverage OPC Router’s ETL (Extract, Transform, Load) Tools—a valuable solution for seamlessly repackaging data across processes that use distinct standards or protocols.

In this article, we will briefly introduce the power of OPC Router’s ETL Tools, exploring a few use cases that highlight their role in structuring data into popular file formats. If you are not already familiar with what OPC Router is and what it can do for your particular process, you can visit the OPC Router website or the OPC Router Technical Guides with a Quick Start for New Users.

Continue Reading

Exploring Cogent DataHub's Alarm & Notifications Plug-In

5 min read

By John Gonzalez on Dec 14, 2023 2:00:00 PM

Cogent DataHub is primarily known for its extensive connectivity to OPC DA, OPC UA, OPC A&E, Databases, Historians, Excel, ODBC, DDE, Linux, Modbus and more. However, it is worth noting that this platform offers more than just connectivity. In this blog post, we'll cover the capabilities of DataHub’s Alarm & Notification Plug-In, which supports the configuration of custom alarms, events, and notifications. You can enhance your A&E Client applications by adding this feature to any DataHub License Pack, and generate alarms based on any data integrated into the DataHub, or simply send email/SMS alerts.

Continue Reading

Exploring MQTT – Understanding Quality of Service (QoS) with DataHub

7 min read

By Connor Mason on Nov 30, 2023 2:00:00 PM

MQTT continues to grow in popularity and implementation within the industrial automation community. For those who are still new and learning about this protocol, MQTT is a light-weight transfer protocol built around a publish/subscribe architecture. In simple terms, MQTT can be compared to a mail envelope, providing structure and a common appearance with a supported delivery system, while the actual content of that envelope can vary widely.

Because of the ambiguity of message content, implementations of MQTT can be utilized for various needs across segments in our industry, though the varying message content presents its own issues that are outside the scope of this article. There are multiple solutions for providing structure and standards around the message content that we will discuss in future posts.

This blog will primarily focus on the reliability of message delivery based on the concept of Quality of Service (QoS). We will be utilizing the Cogent DataHub to showcase these options, as it can act as both the MQTT Broker & Client. It is important to note that this information can be applied to various MQTT implementations, including other Software Toolbox product offerings with MQTT, such as OPC Router or the TOP Server MQTT client driver.

Continue Reading

Exploring TOP Server's Out-of-the-Box Security Features

10 min read

By Kyle Persyn on Nov 16, 2023 2:00:00 PM

Whether you're running a production system in manufacturing, oil and gas, building automation, or energy, safety and uptime are of the utmost importance, especially with cybersecurity attacks increasing in frequency and complexity.

That’s why when running an application with widespread user access, managing user permissions and configurations is so important, and you need a solution that is as security centric as you are. In this blog post, we delve into how to manage user groups and permissions inside the TOP Server’s User Manager and Security Policies Plug-In to ensure a robust and secure gateway to your TOP Server Configuration.

Continue Reading

Understanding the Different OPC Data Logger Components

7 min read

By Zachary Parham on Nov 9, 2023 2:00:00 PM

Applications tend to have a lot of moving parts. Here at Software Toolbox, we know that understanding these parts is important whether you are new to an application or a seasoned veteran who wants a more robust understanding for the sake of troubleshooting and optimization. Because of this, part of our job is to help you recognize and understand the components of our products to maximize your ROI when using our solutions.

In this blog post, we'll provide an overview of the different components of OPC Data Logger, an effective solution for reliable, event-driven logging of data from OPC server data sources (both OPC UA and OPC DA) to SQL and ODBC databases (including Microsoft Azure SQL) or text and CSV files. We'll cover the wizard-based interface used for Configuration, the difference between the Service and Runtime, and the Notification functionality so you can understand the purpose of each component and how to configure them to meet your logging needs.

Continue Reading

Using OPC Router to Log OPC Data to JSON Files Without Code

9 min read

By Jessica Dillon on Nov 2, 2023 2:00:00 PM

In today's business landscape, the exchange and storage of data plays a pivotal role in ensuring efficient and robust operations. Whether operating in sectors like Pharmaceuticals, Manufacturing, Power, or related industries, the exchange of data between services and applications has become standard practice, often an imperative. Consequently, many organizations leverage resources such as databases and historians to archive their invaluable data. However, there are instances where the need for simpler storage methods or direct interchange of data via Webservices is required to maximize application interoperability. Unfortunately, this solution area is often one filled with custom software applications. In this blog, we'll show you how to eliminate custom code and build sustainable solutions.

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