Where I can parse IoT data in Azure so I can afterwards save it to SQL DB

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.

Upvotes: 0

Views: 116

Answers (1)

Murray Foxcroft
Murray Foxcroft

Reputation: 13745

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.

Upvotes: 2

Related Questions