How To Collect, Store, and Query IoT Data With MQTT + SQL
FairCom EDGE can be deployed as a dedicated MQTT broker and maps them to tables within its underlying relational database.

What if your database supported MQTT, or if your MQTT broker supported SQL? Well, regardless of which way you look at it, FairCom EDGE simplifies IoT by combining an MQTT broker with a database and a web server.

Industry 4.0 requires a bridge between OT and IT, connecting the physical components managed by OT with the software managed by IT – creating a cyber-physical system to drive production efficiency and cost reduction with intelligent automation, predictive maintenance, and condition-based monitoring.

However, cyber-physical systems are fueled by data and rest on a foundation of data integration pipelines. The challenge is getting access to OT data and making it available to IT software, developers, and data scientists – and without having to write custom code. The solution is an IoT/Industrial IoT edge hub, software that collects data from machines and sensors via common industrial protocols and makes it available to applications via standard software protocols.

MQTT is a lightweight messaging protocol designed for constrained devices with limited bandwidth – and is the de facto standard within the Internet of Things (IoT). MQTT brokers enable devices with embedded MQTT clients to send and receive data by publishing messages and subscribing to topics. However, while some MQTT brokers can persist messages to disk, they can’t be queried via SQL.

In this webinar, we’ll explain how FairCom EDGE can be deployed as a dedicated MQTT broker which parses messages and maps them to tables within its underlying relational database for persistence as well as access via standard SQL.

Register now and learn how to:

  • Get started with MQTT
  • Map MQTT messages to relational tables
  • Query MQTT messages with SQL

FairCom EDGE supports MQTT as well OPC UA, ThingWorx, HTTP/REST and SQL, making it easy to collect data in one protocol and access it in another. In addition, FairCom EDGE can publish messages to MQTT brokers in the cloud. See how easy it can be to get started with MQTT.

Speakers

Mike Bowers
Mike Bowers
Chief Architect, FairCom Corporation
Mike Bowers oversees product strategy and innovation at FairCom. He has 25+ years of experience in software development and architecture, and is a member of the INCITS technical committee for SQL and GQL.
 Shane Johnson
Shane Johnson
Head of Marketing, FairCom Corporation
Shane Johnson is a former Java developer and architect specializing in distributed systems. Prior to joining Faircom, he led technical marketing for Red Hat, followed by product marketing at Couchbase and MariaDB.
Hosts
FairCom
FairCom
We unlock the data generated by connected devices, sensors and machines at the edge, whether it’s the factory floor or a retail store, and make it available for enterprise integration.
We unlock the data generated by connected devices, sensors and machines at the edge, whether it’s the factory floor or a retail store, and make it available for enterprise integration.