File Transfer from Azure Storage to onprem

Question

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

Answer 1

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.

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