0

I'm working on some IoT integrations and I am wondering where in the Azure I can parse my IoT data (JSON data).

My earlier workflow was this; sensor pushes data -> iot hub -> stream analytics jobs -> sql database. Stream analytics job works fine but I have heard that it is not "right" way to parse data in Azure. So what is the right and best way to do that. I need to save it to SQL database.

Ollipekka Väänänen
  • 1

1 Answers1

2

Stream Analytics jobs are perfect for setting up real time analytics on your data.

As an alternative, you can also use databricks and Structured Streaming.

If you do not have a real time requirement, consider using Azure Functions (Processing data from IoT Hub with Azure Functions). If you were using Event Hubs, you could use Event Hubs Capture to move your data in to a storage account and then process further using Azure Data Factory, databricks, or any other technology that can connect to the storage account.

Murray Foxcroft
  • 12,785
  • 7
  • 58
  • 86
  • 1
    Thank you for the answer! The data needs to be real time because I have IoT sensor which basically calculates how many people are in the room and sends that data to iot hub. So is there any other/better way to do that than stream analytics job? – Ollipekka Väänänen May 07 '19 at 10:33
  • 1
    I would agree with Murray. Stream Analytics is a very good fit for this job. Where did you hear that it's not the right way? If you need more customizable options, Spark Streaming on Azure Databricks is also an alternative - but it includes much more coding and management for you – silent May 07 '19 at 10:44
  • You can use Structured Streaming with databricks as an alternative - I have updated my answer with a link. – Murray Foxcroft May 07 '19 at 10:46
  • 2
    Thank you! This gave me more belief to continue with stream analytics job. – Ollipekka Väänänen May 07 '19 at 11:06