IoT Solution

[zishanmansuri]

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?

[TomMartens · Accepted solution]

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

[zishanmansuri]

Thank you for your help

[TomMartens]

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