Software Toolbox Technical Blog

DataHub – 3 Ways to Transform Database Writes

9 min read

By Kyle Persyn on Mar 14, 2024 2:00:00 PM

If you’re an existing user or 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 options to industrial data systems, but most importantly its secure, high performance, scalable, firewall, DMZ, & proxy friendly data transfer within premises and to/from the cloud. 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 and securely traverse across various platforms. We truly believe that "once the data is in DataHub, it can go anywhere, securely".

In this blog post, I'll provide insight into using DataHub’s Transform property to manipulate data that is being logged to a database table. To follow along with this blog, as a prerequisite, you will need to have an ODBC database configured and have DataHub set up to be writing to that database. For more information on connecting and writing to a database, please read our blog DataHub – 5 Quick Steps to Writing to a Database Table”. Unlike loggers that only work with OPC data sources, DataHub’s capability to securely tunnel data and aggregate from diverse sources besides OPC empowers many different types of applications.

Continue Reading

Using TOP Server's Advanced Tags Plug-In: Calculations & Data Bridging

7 min read

By John Gonzalez on Mar 7, 2024 2:00:00 PM

TOP Server is widely used in automation for data collection from your industrial control systems. One of the many benefits of using TOP Server is that it ensures data integrity – meaning that the accuracy, consistency, and completeness of the data is maintained from your data source all the way up to whatever is consuming that data from TOP Server, such as your HMI, SCADA, MES, or Historian. While its capability to collect unchanged raw data from field devices is invaluable, it may not always align with the desired format, and there could be elective data massaging or manipulation required to meet your business demands. TOP Server can convert data types and even scale to engineering units, but what if you need more advanced data such Cycle Time, Maximum Temperature, Downtime Reason, etc.?

The TOP Server Advanced Tags Plug-in enhances functionality by providing added features to any TOP Server driver, such as mathematical operations and data bridging across protocols, thereby streamlining analysis processes and enhancing decision-making capabilities within industrial control applications.

In this article, we'll briefly introduce a few key features of the TOP Server Advanced Tags Plug-in that could serve valuable to you in your data collection processes.

Continue Reading

Video Tutorial: Getting Started with OPC Router Project Development

1 min read

By Nicole Knox on Feb 22, 2024 2:00:00 PM

OPC Router is a powerful tool that can be used to easily integrate large quantities of data from a variety of sources using its modular configuration, adding value to a variety of industrial, business (ERP/SAP), and IoT data systems. It's drag and drop visual workflows result in reduced engineering time and risk in Industry 4.0, IIoT, and Digital Transformation applications. When combined with Software Toolbox's OPC server offerings and other automation software, plus decades of expertise in automation, the results are rapid time-to-value solutions.

In the following video, we'll walk through a simple example to show you the fundamentals of developing a project in OPC Router. You'll learn how to comfortably navigate the interface and how to verify that your setup is functioning properly. This process will also give insight into the building blocks that make the product so malleable and adaptable to many different use cases.

Continue Reading

Logging OPC Data with Custom Time Formats

4 min read

By Connor Mason on Feb 15, 2024 2:00:00 PM

When logging data to a database or text file, the way that data is presented is essential due to the implications it has for who, or what, is reading this data to make decisions. Without the correct configuration of the data’s timestamps, records can easily become misinterpreted or sorted in non-chronological order by further systems. It’s critical that your data logging solution provides flexibility to get your data when you want it, how you want it, and stored the way you want it. Providing full control of the timestamp format for many users is not just a feature of our OPC Data Logger, but a requirement based on other connected systems and standards. Customizable Time Formats is the focus of today’s blog, but it is just one of the OPC Data Logger’s many flexible features that have our fans raving over it.

Continue Reading

OPC Data Client and NuGet: The What, Why, and How

5 min read

By Zachary Parham on Feb 8, 2024 2:00:00 PM

Software Toolbox has been a fixture in the automation industry since 1996, offering software tools and components from project conception to completion. Our expert staff is committed to helping customers leverage current technologies while offering ways to enhance or expand systems and approaches to achieve even greater returns. When it comes to our OPC Data Client Development Toolkit, that promise remains the same, and we want to help you make the best decisions for your development workflow.

The OPC Data Client has offered the usage of NuGet packages since 2016 as an alternative to adding assembly references via the components when writing custom OPC client applications. As our users have moved towards the use of NuGet, we made this a requirement for .NET Framework beginning with our V2022.2 release. In this blog post and accompanying video, we will cover what NuGet is, when to use it, and how to use it if it makes sense for your requirements.

Continue Reading

Automating Data Entry from Test Stand & QC Devices as Keyboard Input

9 min read

By Jessica Dillon on Feb 1, 2024 2:00:00 PM

Unlike off-the-shelf OPC servers and drivers that talk to specific devices or protocols and no others, OmniServer can be configured to talk to virtually any device or combination of serial, USB, or Ethernet connected devices with some outliers based on the complexity of the protocol. OmniServer helps you bring data that would otherwise be inaccessible into your process and business systems, helping you make more effective decisions. In our experience there are still many software applications that do not have open interfaces such as OPC for data input. This is particularly common in quality control and test stand applications. Operators use a digital device to capture a measurement, and then have to type that into their test stand or QC software. This slows testing rates and can be error prone. There is a better way. 

Continue Reading

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

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