MQTT with FairCom EDGE

MQTT with FairCom EDGE

MQTT overview

MQTT is a lightweight messaging protocol intended for constrained devices with limited/unreliable bandwidth, and has become the de facto standard for Internet of Things (IoT) and Industrial IoT communication. It implements the pub/sub pattern, with clients publishing messages to topics on a broker and/or subscribing to topics on a broker to receive messages.

MQTT clients can be embedded in sensors, actuators, gadgets, appliances and machines – enabling everything from smart homes (e.g., lights and security systems) and smart cities (e.g., parking meters and traffic lights) to smart factories (e.g., machines and robots) and smart farms (e.g., weather stations and crop monitors). MQTT brokers are typically deployed at the edge and/or in the cloud.

FairCom EDGE

FairCom EDGE combines an MQTT broker with a web server and a database, making it the world’s first converged IoT/Industrial IoT hub intended for edge deployments – whether in a retail store, on a factory floor or at a transit station. It can aggregate messages, both MQTT and OPC UA, sent by connected devices and publish them to other MQTT brokers in the cloud (e.g., AWS IoT Core), or to ThingWorx.

MQTT Explorer, a built-in web UI, makes it easy to configure and manage MQTT topics. In addition, customers can take advantage of the internal web server and REST APIs to extend FairCom EDGE by embedding custom web applications/dashboards. Further, messages are automatically parsed and persisted to internal database tables, allowing them to be analyzed with BI/reporting tools and standard SQL.


How to collect, store and query IoT data with MQTT + SQL

MQTT broker

  • MQTT 3.1
  • MQTT 3.1.1
  • MQTT 5.0 (coming soon)
  • MQTT-SN (coming soon)
  • Quality of Service (QoS)
  • Persistent sessions
  • Retained messages
  • Last will and testament
  • Windows x86
  • Windows x64
  • Linux x86_64
  • Linux ARM32
  • Linux ARM64
  • Mac OS
  • Eclipse Paho
  • MQTT.js
  • Node-RED

FairCom EDGE features

MQTT Explorer

MQTT Explorer is a built-in web UI for managing the MQTT broker in FairCom EDGE. There is no need to manually edit configuration files or write code as everything can be done via the UI, including managing topics and subscriptions, browsing published messages and mapping broker activity.

Persistent topics

FairCom EDGE automatically persists messages to tables, and if the message bodies are JSON documents, it maps their properties to columns. When a topic is created, it can be configured to store messages in a new table or an existing table, and multiple topics can persist messages to the same table. As a result, MQTT Explorer can be used to browse the data in all messages published to a persistent topic.

SQL Explorer

SQL Explorer, like MQTT Explorer, is a built-in web UI for querying data in the internal database. While SQL Explorer provides a visual interfacing for browsing and querying the internal database, external applications such a BI/reporting tools can connect to it via standard JDBC/ODBC drivers as well.


Try out the developer edition of FairCom EDGE today!