Data From IOTCentral to Azure SQL Server

Question

Hi all

A fairly straightforward question i can't seem to find out how to do it !

I'm wanting to extract telemetry data out of IOTCentral using the data export facility into Azure via an Event Hub. Then i want to move it into Azure SQL. How can i do this ? It looks as if you create a Storage Account for the data and that's where i can't see how it then gets into Azure SQL. Does anyone know where i can find any user/set up guides for doing this ?

Your help is greatly appreciated.

Answer 1

You could be using an Azure Function with an EventHub Trigger to write the data to an Azure SQL.

This project might give you hints on how to implement this: https://www.codeproject.com/Articles/1169531/Sending-events-from-Azure-Event-Hub-to-Azure-SQL-D

---

rMVP 

Answer 2

Hi JSC99,

- another way without additional cost for exporting data to the Event Hub resource is pushing a telemetry data to the webhook. See more details in my answer here.

Thanks

Roman

---