How to connect Service bus queue to Azure Data Factory as source

ankit kumar 101 Reputation points
2020-09-29T11:32:30.463+00:00

I have a service bus configured where i get messages in my subscription, I would like to move the data from the messages in the service bus queue to table storage using Azure Data factory, I would like to know if it is possible to do it.i couldn't find any online resource which talks about service bus as a source so would like to know if anyone has any experience here.

Thanks

Azure Service Bus
Azure Service Bus
An Azure service that provides cloud messaging as a service and hybrid integration.
556 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,685 questions
{count} votes

Accepted answer
  1. MartinJaffer-MSFT 26,036 Reputation points
    2020-09-29T20:14:14.287+00:00

    Hello @ankit kumar and welcome to Microsoft Q&A.

    Data Factory does not have a connector for Service bus. However there are several options available to you.

    • You can create a consumer for Data Factory to call upon.
    • You can raise a feature request in the feedback forum.
    • You could re-route your messages to be written to blob, and then leverage the Blob Event Trigger.
    • Use ADF Web Activity to retrieve a message.

    By "create a consumer for Data Factory to call upon," I mean either create a Function App which batch-reads the messages, and returns them, utilizing ADF Azure Function, or , create some code to do the same with the ADF Batch Service Custom Activity. There are more variations as well.

    Which one to use, depends upon your volume and cadence (frequency).

    Please let me know if you desire more information.

    3 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful