5

I have recently created an Azure Hub-IOT in which I am sending some data from a virtualized device, I know that the data arrived because I can see them from a terminal but now I want to take this data and save them into an Azure SQL_DataBase, how can I do this?

If someone can explain me the process or link some tutorial I will appreciate it.

Jason Aller
  • 3,541
  • 28
  • 38
  • 38
Giacomo El Ghisa Zidarich
  • 67
  • 1
  • 5
  • Does this help:https://blogs.msdn.microsoft.com/sqlserverstorageengine/2018/01/23/working-with-azure-iot-data-in-azure-sql-database/ – TheGameiswar Apr 05 '18 at 12:10
  • 1
    Stream Analytics is of cource an easy and fast way but very expencive! I recommend using Azure Functions with dependency injection of DbContext. – David Stania Nov 20 '19 at 00:18

1 Answers1

2

Write the data to IoT Hub, then you just need to create a stream Analytics Job to save the data on an Azure SQL Database:

enter image description here

Please read this tutorial for detailed information. Another useful tutorial may be this one.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30