Hey everyone. Newb here and have a question regarding a project I'm working on.
The idea is to utilize Arduino/Lora Gateway to retrieve sensor data from Lora Nodes periodically, probably once an hour. Water Tank Level Data to be more specific.
I have SCADA software that I plan to use for the website/display portion of this. The SCADA software can communicate with Databases so my question is, would I be able to publish data from the nodes to a SQL Server? From there, I can use my Display software to retrieve and display the data.
So far with this project I have been able to publish sensor data from the Lora nodes to ThingSpeak Iot Server. I'd like to remove ThingSpeak as the middle man if I could and set up some sort of database of my own to store the data, then use my software to display the data for my users. I don't believe the software I am using works with REST API, or else I'd just extract the data that way. I'm also exploring the idea of MQTT and running my own broker/server but have a lot of research before I get there.
Does anyone have experience with publishing sensor data to their own server and displaying on their own server? I'd love some advise on this project and to give you a quick run down on the project, I have some close friends and family that have oil and they are interested in a cheap solution to monitor their oil tanks. Like super cheap, so I thought I'd play around with Arduino/Lora technology and so far I'm impressed, but I could really use some help in the data storage/publishing portion of this project. Thanks.