How to connect adf from one subscription to azure file storage in other subscription

Rushikesh Yelane 20 Reputation points
2023-07-11T19:27:03.92+00:00

I have Azure Data Factory in one subscription-A and a File storage account in other subscription-B. I want to store the CSV created with the help of tables accessed from subscription-A and put those in the file storage account created in the Subscription-B. But when I created a LinkedIn service for it on testing, it is giving me a time out error. I am using the Self hosted IR for which the firewall request I have set up already.

Azure Storage
Azure Storage
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,529 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
{count} votes

Accepted answer
  1. PRADEEPCHEEKATLA 90,641 Reputation points Moderator
    2023-07-12T13:23:28.86+00:00

    @Anonymous - Thanks for the question and using MS Q&A platform.

    I'm not sure, why Self-hosted IR is used in the scenario.

    Source: You can use AutoResolveIntergrationRuntime and enter manually details about the storage account as shown below for source subscription A: CHEPRAGEN2

    User's image

    Source Linked Service connection:

    User's image

    Desitination: You can use AutoResolveIntergrationRuntime and enter manually details about the storage account as shown below for destination subscription B: CHEPRADEMO
    User's image

    **
    Sink Linked Service connection:**

    User's image

    By using the above configuration, we were able to connect adf from one subscription to azure file storage in other subscription and transfer csv files between the storage accounts as shown below.

    User's image

    Hope this helps. Do let us know if you any further queries.


    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.


0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.