You would like to ingest files stored on a File Server hosted on Azure, and do not want to use Azure Blob Storage for this.
- 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) which can be found in the ‘Overview’ of the container
Creating a VM based SFTP can be considered costly in terms of maintenance and resource.
- The template setup provided is using a public facing container and ‘All Network Access’ for the storage account
- Requirements within your organisation 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