![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(316.8, 61%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
Azure SQL Database
An Azure relational database service.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 74%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
Hello @Kat_St
If you want just to query some data from Azure SQL DB and send a command to Iot Device, you can use Azure Function with Time Trigger(Runs every X minutes) or invoke it by HTTP request.
Azure Function supports SQL DB connection and can send messages to Iot Device using cloud-to-device messages, device-twins or direct-methods.
https://learn.microsoft.com/en-us/azure/azure-functions/functions-scenario-database-table-cleanup?toc=/azure/azure-sql/toc.json
https://learn.microsoft.com/en-us/azure/iot-hub/iot-hub-devguide-direct-methods
If you want to send a command to Iot Device when for example Table is modified in SQL Database you can use LogicApp + Function.
LogicApp can be triggered when Table in Azure SQL DB is created or modified.
LogicApp can invoke Azure Function with HTTP request.
https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-sqlazure?toc=/azure/azure-sql/toc.json
https://learn.microsoft.com/en-us/azure/connectors/connectors-native-http
One more option is to use LogicApp together with IoT Central.
LogicApp is triggered when Table in Azure SQL DB is created or modified.
LogicApp can send command to Iot Device via IoT Central
https://learn.microsoft.com/en-us/azure/iot-central/core/howto-configure-rules-advanced