File Transfer from Azure Storage to onprem

Question

question

KeshavRajput-6587 asked May 1, '22 MayankBargali-MSFT edited May 4, '22

File Transfer from Azure Storage to onprem

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

· 1

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

BrunoLucas-9843 · May 03 at 09:44 AM

Hi @KeshavRajput-6587 ,
Just checking to see if you need any further help. To reach on-premises resources using logic apps or any azure resource you will need to link your azure environment to your on-premises network (https://docs.microsoft.com/en-us/azure/architecture/reference-architectures/hybrid-networking/). There are many ways to accomplish that but can also be done provisioning something like an web api or ssis from your on-premises environment.

0 ·

Answer 1 · 2022-05-02T04:19:23.17Z

BrunoLucas-9843 answered May 2, '22 BrunoLucas-9843 edited May 2, '22

Hi @KeshavRajput-6587

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://docs.microsoft.com/en-us/azure/logic-apps/connect-virtual-network-vnet-isolated-environment-overview#access-to-on-premises-systems

Or

https://docs.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://docs.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-on-premise-sql-server

https://docs.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://docs.microsoft.com/en-us/azure/architecture/data-science-process/move-data-to-azure-blob-using-ssis

image.png (12.8 KiB)

5 |1600 characters needed characters left characters exceeded

Attachments: Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

question