Send Sensor Data to Azure mysql database and send alerts via mqtt Protocol
We have been working in machinery firms where we test Vibration of machines but we have to carry huge PLC and discrete PID equipment as well as wired SCADA network systems,
We wanted to use internet friendly Wireless Vibration sensors https://store.ncd.io/product/iot-long-range-wireless-vibration-and-temperature-sensor/ which has secured PAN network,
send the data of sensors to azure Sql database, I am using Arduino Uno with ESP8266 for internet wifi connection and also receives the data from sensors
But I need to confirm the valuable solution to make the data of sensor stored in Azure mysql database and set some parameters in azure in such a way that it compares the data of sensors and use MQTT protocol to message the alert via SMS on smartphones whenever the parameters of sensor is high or low from the defined one in Azure.
Thanks for the feedback. Can you provide more information about the data that is output by the sensors? Is the data structured? How large could the raw data get?
Andrea Lam on behalf of the Azure DB for MySQL team