Hi, So I am very new to MQTT and after a few false starts I finally got my data coming through to the Broker.
The data I am handling is from a heat meter, so it has a few bits of information per chunk that arrives:
Date and time
Serial number of the meter
Kwh of the meter
Flow and return temperatures.
With other technologies I have to read meters we get CSV files with a time entry per line against a heat meter. It would be great to just bundle up the last … time period of meter readings that have come through and stick them in a CSV on our FTP/SFTP server.
Alternatively the billing software is a MS Business Central product, so if there is a more direct route than sticking it on the FTP be to digested with the other readings that might work as well.
Welcome to HiveMQ Community! While I’m not personally familiar with Dynamics 365 Business Central, I’d like to suggest a potential pathway for the integration you’re seeking. HiveMQ offers robust Databases and Data Analytics extensions that could facilitate the conversion of MQTT messages into a format suitable for ingestion by Business Central
The general idea would be to use these extensions to first store the MQTT data into an external database. From there, you could leverage Business Central’s capability to connect to external databases presumably via a database connector to retrieve and utilize the data within your business processes.