Forum Discussion
IoT Solution
Hello, Community,
We have an IoT device that sends data every 5 second with 250 fields. We need to show real time dashboard in th BI and also keep the data for 3 years for compliance purpose. Now it's almost 15 thousand records per day. Which database is more suitable for this task?
Hey zishanmansuri ,
I assume that you are facing three challenges
- capturing the incoming data
- storing the incoming data
- analyzing the data
You can consider Azure IoT Hub for the capturing, Azure Data Explorer for the storage, and Power BI for the data visualization/analysis.
You can use Azure Stream Analyis to "move" the incoming data from the IoT hub to Azure Data Explorer and at the same time the most recent events into Power BI streaming dataset.
Regards,
Tom
3 Replies
Hey zishanmansuri ,
I assume that you are facing three challenges
- capturing the incoming data
- storing the incoming data
- analyzing the data
You can consider Azure IoT Hub for the capturing, Azure Data Explorer for the storage, and Power BI for the data visualization/analysis.
You can use Azure Stream Analyis to "move" the incoming data from the IoT hub to Azure Data Explorer and at the same time the most recent events into Power BI streaming dataset.
Regards,
Tom
Thank you for your help
Hey zishanmansuri ,
you are welcome, if you think that my previous post is answering your question, mark the post as an answer. This will help other users.
Regards,
Tom
