Export data from Azure SQL database and send it to azure IoT Central

Question

Can I export data from Azure SQL database and send it to azure IoT Central ?

Answer 1

Hello @nikita ,

yes, it's possible to send data from both devices and services to Azure IoT Central.

Ingesting data from a database is a common solution for simulation or for systems where sensor data is collected and stored in a local database and the sensor state can be retrieved from that database.

To ingest device/database data into IoT Central, create an application acting as a device, honoring the device registration.

Follow this tutorial in any of the programming languages (see also the other tabs).

---

If the response helped, do "Accept Answer". If it doesn't work, please let us know the progress. All community members with similar issues will benefit by doing so. Your contribution is highly appreciated.

Answer 2

Thank you @Sander van de Velde | MVP for your inputs on this.

@nikita , in addition to the above approach mentioned by Sander, you can also leverage Azure functions and add a trigger function such as Timer Trigger to read the data from the database and periodically push it to the Azure IoT Central. Here is an article Add a timer triggered function which provides an example on updating records into the Database. You can modify this function to fetch the records and use 'DeviceClient' class within the function to send telemetry to IoT Central.

Please refer the sample code provided in How to generate in a single and simple C# project custom telemetry for a IoT Device Template with complex object for reference on how to push the data to your custom device template through the code.

Hope this helps. Please let us know if you have any additional questions.

---

If the response helped, please do click Accept Answer and Yes for the answer provided. Doing so would help other community members with similar issue identify the solution. I highly appreciate your contribution to the community.