want to aggregate all data from loaf devices to edge and send all data to iot hub or iot central note : this loaf devices send to data in SQL forum

Hello @AhmedAssad-8581 , it seems you want to read data from a device that contains a database? In that case, write a custom IoT Edge module that is able to execute the SQL query (once every x seconds?) and transforms the result into messages which can be sent to the IoT Hub. To build a custom module, you need to use any of the programming languages which are supported by Azure IoT edge SDKs. An example is this NodeJS tutorial. There are also tutorials for C, C#, Python, and Java. Some examples of already built modules can be found here . Depending on your use case, you can transform each row into a message or all rows into a single message. There is a 256K limitation to a single message. Regarding IoT Central, you need to define an IoT Edge device template first for your edge device and the model. For this, you need to create the deployment manifest first. So I recommend starting with Azure IoT Hub first.

how to forward masseges from iot edge to iot hub ?

Accepted answer

Sander van de Velde | MVP 33,636 Reputation points MVP

2021-01-31T13:42:30.397+00:00

Hello @AhmedAssad-8581 ,

it seems you want to read data from a device that contains a database?

In that case, write a custom IoT Edge module that is able to execute the SQL query (once every x seconds?) and transforms the result into messages which can be sent to the IoT Hub.

To build a custom module, you need to use any of the programming languages which are supported by Azure IoT edge SDKs. An example is this NodeJS tutorial. There are also tutorials for C, C#, Python, and Java.

Some examples of already built modules can be found here.

Depending on your use case, you can transform each row into a message or all rows into a single message. There is a 256K limitation to a single message.

Regarding IoT Central, you need to define an IoT Edge device template first for your edge device and the model. For this, you need to create the deployment manifest first. So I recommend starting with Azure IoT Hub first.
Please sign in to rate this answer.
Ahmed Assad 266 Reputation points

2021-01-31T13:53:15.707+00:00

Thanks for responding , My case is some ready loaf devices that i can not edit any software on it .
So i think to aggregate all data from this devices to central local device and route it to iot hub ..
can recommend any way to real time solution ?

Sander van de Velde | MVP 33,636 Reputation points MVP

2021-01-31T14:44:34.833+00:00

Hello @AhmedAssad-8581 ,

It seems that you actually want to drop the telemetry in some SQL database eventually, right?

Can you tell me more about the leaf devices (make, type)? Which protocol do they support to retrieve data from them?

Adding an Edge device in between is a great idea to aggregate all data and only send certain filtered data to the cloud.

If you want to put telemetry in e.g. SQL Azure, use an IoT Hub which can send data to e.g. Azure Stream Analytics or an Azure Function which bove has the capabilities to access a database.

IoT Central is a SaaS solution, containing an IoTHub which is 'hidden' behind a dashboard. IoT Central has an export function that exports all incoming data to blob storage, EventHubs, etc. From there, use e.g. Azure Function or Stream Analytics.

Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer.

Ahmed Assad 266 Reputation points

2021-01-31T15:00:29.587+00:00

loaf devices sinking data on central server in SQL forum , so what i want that reroute telemetries from sql server to iot hub

Sander van de Velde | MVP 33,636 Reputation points MVP

2021-01-31T15:11:19.587+00:00

Hello @AhmedAssad-8581 ,

OK, in that case, you only have to be sure you can query the SQL database using custom code.

Then wrap this query in an IoT Edge custom module and transform the telemetry in anything you like and send this over to the cloud.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

how to forward masseges from iot edge to iot hub ?

0 additional answers

Your answer