A step-by-step guide to ingesting OPC-UA and MQTT data into CrateDB using Telegraf as the integration layer. Covers configuring the OPC-UA polling input for PLC/SCADA nodes, the MQTT consumer input for edge sensors with JSON payloads, and the CrateDB output plugin with auto table creation. Includes SQL query examples for reading latest readings, aggregating over time windows, and correlating data from both protocols in a single join query. Also covers Grafana dashboard integration and how this stack fits into an industrial IoT analytics architecture.
Table of contents
What Telegraf does in this stackConfiguring the OPC-UA inputConfiguring the MQTT inputThe CrateDB outputVerifying the data landedQuerying sensor dataCorrelating OPC-UA and MQTT in one queryWhere this fits in the industrial stackNext steps130 Impressions