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.
Currently we have no option to provide a direct SQL connection to stored messages.
Please, using Stashing to have your messages stored in order:
Then use download stash option to have your data downloaded:
You have also a REST API that allows downloading your stash so you can integrate and automate the process:
From there you only have to process and consolidate into your database.