Introduction

Find out how you can ingest files stored on a File Server hosted on Azure, even if you do not want to use Azure Blob Storage.

Recommendation

• Use the Azure Container Instances (ACI) which will allow you to mount your file server within a container
• Templates for setting up a container for a new file share or existing file share can be found here

Once this is complete, all you require for the Fivetran SFTP connection is:

• The username and password setup when creating the container
• The fully qualified domain name (FQDN) can be found in the ‘Overview’ of the container

Context

Creating a VM-based SFTP can be considered costly in terms of maintenance and resource.

Considerations

• The template setup provided is using a public-facing container and ‘All Network Access’ for the storage account
• Requirements within your organization will determine where these services are created in your network
• If you are deploying containers into an Azure Virtual Network, you must add a service endpoint to your Azure Storage Account
• If you are going to stop and start the container, note that the fingerprint of the container will change. This can be updated manually in the Fivetran console, but we recommend automating approval of this using the Rest API.