File Transfer from Azure Storage to onprem

Keshav Rajput 1 Reputation point
2022-05-01T17:00:53.54+00:00

Hi Team,

I am working on a scenario in that I need to transfer files from Azure Storage to on-premises. But I didn't find any best way to do that. Could you please help me out which method would be best suitable for me and what would be the procedure to implement that scenario.

Even I tried with azure logic but unable to solve my problem. Could you please send the proper steps for azure logic app or if there is another option better than this, please provide me.

Please send me response as soon as possible.

Thanks & Regards

Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,994 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Bruno Lucas 4,421 Reputation points MVP
    2022-05-02T04:19:23.17+00:00

    Hi @Keshav Rajput

    There are different ways to accomplish that. Depend on budget or preferences.

    One very popular way is to create an API hosted on premise that allows logic apps to push data to your on-prem resource.

    198212-image.png

    1 is a REST API you can write to connect to your destination resource. Of Course it must be exposed to the internet

    If you don't want to write code and keep it more on azure you will need to use one of these approaches to link your on-prem network to azure and make your on-premises resources visible to azure :

    https://www.serverless360.com/blog/azure-logic-apps-integration-service-environment
    https://learn.microsoft.com/en-us/azure/logic-apps/connect-virtual-network-vnet-isolated-environment-overview#access-to-on-premises-systems

    Or

    https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection

    Where are you dropping the files? Are you passing to an on prem folder or DB? Large scale? You may find azure data factory is a better fit depending of the scenario:

    https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

    https://learn.microsoft.com/en-us/azure/data-factory/connector-file-system?tabs=data-factory

    You can also use SSIS if you are pushing to SQL Server on-premises: https://learn.microsoft.com/en-us/azure/architecture/data-science-process/move-data-to-azure-blob-using-ssis

    0 comments No comments