Software Toolbox Technical Blog

DataHub is a solution in Software Toolbox’s portfolio of software that integrates various IT and OT data sources, and is particularly strong in working with a wide range of OPC standards, secure multi-layer data tunneling, databases, historians and more. If you've ever worked with DataHub, you've probably seen the "Scripting" tab shown in the image below with some sample scripts. Perhaps you've wondered what this scripting can do or were curious about the language that DataHub scripts use. With that in mind, in this week’s blog we will cover the "what" and "why" of scripting in DataHub, and point you to "where" you can find more resources of "how" to take advantage of the DataHub scripting engine, included free with all DataHub licenses.

This week's post is a technical update to share news about updates released for DataHub and OPC Data Logger, reminders about the value of the Tech Support corner, and your last warning about DCOM Hardening before the Windows update next week!

The team is working on some more tech tips and video tutorials that you'll start seeing later this month. Meanwhile, here's this week's update.

Users of AVEVA™ software are already familiar with the native connectivity options they have for interfacing with different systems and devices. AVEVA users often turn to Cogent DataHub® for integration of a wide variety of industrial and other data sources such as MQTT clients/brokers, SparkplugB systems, databases, historians and much more.

AVEVA InTouch users have traditionally connected to DataHub via its OPC DA Classic interface (via AVEVA OI Gateway). AVEVA's OI Gateway also provides those users the additional option of connecting to OPC UA data sources, for easier and more secure remote connections to such data sources.

In this video blog post, we will cover the basic steps to connect AVEVA InTouch to DataHub via OPC UA, expanding the variety of connectivity options available to AVEVA users.

If you have been following our blog for a while or have been exploring IoT platforms available in the market, you may know that the Google Cloud Platform combined with the Google IoT Core is a frequently used combination in the industry. Google has recently announced that it will be shutting down the Google IoT Core. In doing so, Google is forcing many of its Cloud Platform users to switch platforms.

In this blog post, we will review detailed information about the alternatives to the Google Cloud Platform that are available for use with all of the IoT capable products we provide, and how the change works.

Cogent DataHub® is a gateway that enables a wide range of connectivity interfaces for different data sources such as OPC UA, OPC DA, ODBC, DDE and so much more.  Included in those available interfaces is the ability to act as both an MQTT client and broker even including Sparkplug B support for enabling MQTT integration with many other types of systems that don't natively support MQTT.

A key facet of the MQTT specification that can sometimes be complex for our users and cause issues with compatibility between DataHub and other MQTT clients and brokers is how to handle the formatting of MQTT messages. As you may or may not know, while MQTT does specify how to construct a message header for routing by an MQTT broker, it does NOT specify the actual message content. This tends to be a challenge when MQTT clients from different developers need to work together, since they need to be using the same format for the message content.

In this video blog, I'll show you how to use DataHub V10's Advanced MQTT Parser capability to specify flexible formats that will work with virtually any other vendor's MQTT clients and brokers.

AVEVA™ users already have a wide range of connectivity options for interfacing with different systems. Cogent DataHub® also supports an extensive selection of connectivity to different systems that users sometimes need to access from AVEVA System Platform. Users of AVEVA System Platform have traditionally connected to DataHub via OPC DA Classic. AVEVA's OI Gateway provides those users the additional option of connecting to OPC UA data sources, for easier and more secure remote connections to such data sources.

In this blog post, we will cover the basic steps to connect AVEVA System Platform to Cogent DataHub via OPC UA, expanding connectivity options for AVEVA users.

Ongoing digital transformation and operational visibility initiatives continue to demand the integration of different systems using different technologies. With increased adoption of secure OPC UA and MQTT Sparkplug B, it’s only to be expected that users will have systems that support one or the other technology but need to communicate with each other.

Although OPC UA supports a publish-subscribe mechanism with OPC UA PubSub, and adoption of OPC UA is strong and growing, the reality is there will be situations where the user is already using MQTT Sparkplug B and needs to integrate it with OPC UA or vice-versa, without writing custom code or going through complex configuration.

Software Toolbox was founded in 1996 on the principal of making data and device integration easy by using configurable off-the-shelf software to avoiding writing custom solutions and knowing the pros and cons of and ins and outs of many technologies. That mission remains strong, as you’ll see, as we discuss interoperating between OPC UA and MQTT in this blog post.

Are you or have you ever been in a situation where you were working with both an AVEVA™ solution and some other client or system (HMI, SCADA, other) and needed to share data?  Perhaps your company acquired another company and its assets and a non-AVEVA HMI/SCADA came as part of the assets.  Or perhaps your company merged with another and now your AVEVA system is expected to integrate with other systems.  Your options for sharing data largely depend on what software interfaces these "other systems" support.

In this blog post, I'll discuss how to share your AVEVA System Platform 2020 (or newer) data via OPC UA (without using OI Gateway) using the Cogent DataHub® for situations where you have another non-OPC UA capable client application that needs access to process data in your AVEVA system.