question

QSTIngeniera-7077 avatar image
0 Votes"
QSTIngeniera-7077 asked AlbertoMorillo commented

Az web app to visualize SQL Tables for multiple devices

Hi. We are trying to migrate to Azure our app which shows data from multiple IoT devices arranged in SQL tables. From what we read we believe the trick will be done with IoT Hub + Stream Analitics + SQL Az database +Az Web App. We hava many grey areas as to how to implement this, specially the stream input to the Stream Analytics. How to dicern between the different devices which sent the corresponding messages. Could you give us a starting point for this? Which specific azure doc should I read?
Thanks

azure-webappsazure-sql-databaseazure-iot-hubazure-stream-analytics
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
1 Vote"
AlbertoMorillo answered AlbertoMorillo commented

You can configure a stream analytics job which you can configure to create queries and filter data by machine. Here you will find an example.

This article can also give you a good overall picture of things possible.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Great, thanks for your help I'll get on with it.

0 Votes 0 ·

You are welcome! Thank you for visiting QA forums! Have a great day

0 Votes 0 ·
SandervandeVelde42 avatar image
0 Votes"
SandervandeVelde42 answered QSTIngeniera-7077 commented

Hello @QSTIngeniera-7077 ,

as @AlbertoMorillo confirmed, your expectations are right.

You need to connect an IoTHub as input to an Azure Stream Analytics Job.

In this blog post, the almost complete flow is shown: device -> iot-hub -> ASA job -> SQL server (including the AAD security).

If you want to experience a hands-on experience, check out eg this MS Learn module.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Great, thanks for your help I'll get on with it.

0 Votes 0 ·