How To Collect, Store, and Query IoT Data With MQTT + SQL
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.