IOT sevice to Azure Database for MySQL

0

I'm hoping someone can help me with something. First I will explain the context of my problem.

I am currently using IOT devices to collect customer data. At the moment I have my IOT devices linked to my Azure IoT Hub. I now want to transfer this data into an Azure Database for MySQL which is connected to a PHP app that I am running using an Azure App service. I was hoping to use Azure stream analytics but this seems to be only compatible with an Azure SQL Server. Is it possible to use stream analytics to output to Azure Database for MySQL? Is there an obvious simple alternative that I could use to move my data from the IoT Hub into the AZ DB for MySQL if this is not possible?

At a later stage I will want to do some simple filtering on the data prior to its database insertion, which I believe stream analytics is able to complete.

Ivan Wall

Posted 2019-06-14T13:53:07.430

Reputation: 1

No answers