Az web app to visualize SQL Tables for multiple devices

QST Ingeniería 26 Reputation points
2021-09-10T18:50:22.17+00:00

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 SQL Database
Azure IoT Hub
Azure IoT Hub
An Azure service that enables bidirectional communication between internet of things (IoT) devices and applications.
1,156 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
343 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
7,351 questions
0 comments No comments
{count} vote

Accepted answer
  1. Alberto Morillo 33,421 Reputation points MVP
    2021-09-10T22:57:15.417+00:00

    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.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Sander van de Velde | MVP 31,116 Reputation points MVP
    2021-09-13T09:02:36.073+00:00

    Hello @QST Ingeniería ,

    as @Alberto Morillo 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.