I am building an integration using API's from ADP. There is already an endpoint that I will be using - this is tied to a azure service bus. I have the name of the topic but I'm having trouble understanding the next artifacts that need to be created in Azure. I want the incoming messages to hit an EDW or just the data lake as data (it might be coming in as XML format, which I may need to convert to azure sql database):
Should I create another subscription tied to the EDW that can pick up the messages from the service bus topic? (I have not attempted this before)
Or Should I create a logic app to directly read the service bus or service bus topic? (I have not attempted this either)
I need to design a scalable solution - any insight would be greatly appreciated
Thanks