Hello Santhi Dhanuskodi,
Yes, I belive you can use ADF to read SQL Broker messages from an on-premises SQL and process them before sending them to another API.
You can use the dataflow for this.
Here are the high level steps:
- Configure a self-hosted integration runtime and connect to source on-prem.
- Use a data flow in the pipeline to transform the messages as needed. You can use the transformations like filtering, aggregating, and joining etc
- Use the REST connector as sink in ADF to send the transformed messages to the target API.
- Schedule the pipeline.
I hope this helps.