Application Note: MQTT Recorder Module
The MQTT Recorder module receives a block of data from an MQTT Server and enters it as a record into a database table.
For years data has been created in PLC’s, RTU’s and HMI’s that represent a record of information such as a ticket for a transaction. With the limitations of register-based communication protocols this information has been clumsily handled as consecutive blocks of registers. This method runs the risk of not keeping all the data together as a record event when a partial subset of the registers gets overwritten with a newer set of information. Today with the power of MQTT these records of data can be published, on event, as an immutable record which automatically builds and populates a table within a database. The record can also be time stamped and carry a SHA-256 Hash key that will guarantee that the entire contents of the record are unedited from source. The MQTT Recorder module receives these records and first automatically builds the database table, and then populates each record into the table as it is received.
Record Data sent as immutable object to database
Examples of the record data applications are:
- Oil & Gas – EFM Quantitative Transaction Records (QTR’s), EFM Alarms, EFM Events, P’cards for Pump of Controllers
- Any Industry – Ticket information to record a transaction event
- Pharmaceutical – Batch records for drug manufacture
- Transportation Industry – Locomotive engine events
Extremely simple to configure
For tutorials visit MQTT Recorder Configuration
Benefits
The MQTT Recorder offer the following benefits:
- Receives any RECORD object and creates the database table
- Receives any RECORD object and populates the data within the database table
- Records can be sent as an immutable object with a 256-SHA hash key for audit purposes
- Works with all databases supported by Ignition
Customer Quote:
“I’ve got a simple HMI built in Ignition Edge that users enter ticket information into. The fields are bound to tag values, and when the user clicks submit it writes a 1 to the record publish flag.
On the other side of the MQTT Server, I have a full version of Ignition running the Recorder module which receives the record and writes it to a database table.
I was surprised to see how easy it was to setup and get working quickly out of the box.
I think the recorder module will work great for this application. Even the store and forward worked as expected.”
Trent Boudreaux – Director Technical Services – TIGA
Powered by Ignition:
Cirrus Link MQTT modules are powered by Ignition, the powerful HMI, SCADA, and MES software platform from Inductive Automation providing cross-platform compatibility, unlimited free clients, robust out-of-the-box SQL database support, and fast installation.
Leveraging the full power of the Ignition universal industrial automation platform with fully integrated HMI/SCADA functionality, the Cirrus Link MQTT Modules will unleash the true value of your IIOT Data.
Call or email us today to setup a demo
sales@cirrus-link.com – 844 824 7787
or simply download and start to test yourself for free:
Download Strategic Partner Modules