We have a sensor that publishes data to a TCP socket. How could we create an ingest rule in CrateDB to read from that specific socket? Do we need to use MQTT to read data from the Socket and then publish it as topics so a CrateDB ingest rule can read it? Such approach sounds inefficient. We would…

No this is currently not possible inside CrateDB. Also please aware that the MQTT implementation at CrateDB is deprecated and will be removed in future versions, https://crate.io/docs/crate/reference/en/latest/admin/ingestion/sources/mqtt.html . Main reasons are that the current implementation was v…

@yash what is the recommended way to ingest data from MQTT? Thanks!

@robmarkcole you could use telegraf: https://github.com/influxdata/telegraf

How to load data from a sensor into CrateDB?

CrateDB

hernanc March 7, 2024, 3:06pm 5

I would recommend the approach described in Ingesting MQTT messages into CrateDB using Node-RED - Tutorials - CrateDB Community

1 Like

Topic		Replies	Views
Ingesting MQTT messages into CrateDB using Node-RED Tutorials integration , data-ingestion	0	2795	September 13, 2021
Feeding flat json from a kafka topic to CrateDB using telegraf CrateDB	2	1230	September 2, 2022
Setup HiveMQ using CrateDB as a consumer Tutorials	0	271	April 26, 2024
Migration InfluxDB to CrateDB? (outflux-like) CrateDB	6	1033	August 4, 2021
»Loading data into CrateDB« weekly edition Tutorials integration , getting-started	6	39	March 5, 2026

How to load data from a sensor into CrateDB?

Related topics