SQL intergration

[surangasilva]

Hello,
May I know how we can integrate SQL with broker.We need to get payload which get from specific topic and insert that data to SQL DB.

[myqtthub]

Hello,

Currently we have no option to provide a direct SQL connection to stored messages.

Please, using Stashing to have your messages stored in order:

Managing and using MyQttHub Stashing: storing MQTT messages matching filters

MyQtthub Stashing introduction Stashing function allows to create an ordered storage for incoming PUBLISH messages. Only messages matching configured filter will be stashed. By creating a Stash and Stashing Messages, you are creating an ordered message log that records matching messages (filters using that stash). Together with the message is also stored when it was received, source IP and additional data. This ensures you will not lose any message, even in the case with hardware problems with…

Then use download stash option to have your data downloaded:

Downloading a Stash using JSON, CSV (Excel) or XML format with MyQttHub

On this article you will find information on how to download your stashes, supported formats, internal download format and how to automate your stash download. Available download format for MyQttHub stashes All stashed message can be downloaded using the following available formats: json csv xml How to download a Stash from MyQttHub Here is how to download your stashes: Go to your domain stashes by clicking on your domain’s stash option: [image] …or using menu: [image] Now click o…

You have also a REST API that allows downloading your stash so you can integrate and automate the process:

REST API to manage MyQttHub service

Table of contents 1. Intro: login and logout 1.1) REST API to manage MQTT service (ReactiveMyQtt v6.7.764 1.2) Login into the API and getting a tokenId 1.3) Logout from the API (cancelling tokenId) 2. User management 2.1) Change my password (for a logged device) 2.2) Get user information (for a logged device) 2.3) Get connected devices to your domain (for a logged domain admin device) 3. Domain and device management 3.1) Get connected devices to your domain (for a logged domain admin de…

From there you only have to process and consolidate into your database.