How Can I Use Containers to Host an Azure File Server?

Question

How can I ingest files stored on a file server hosted on Azure without using Azure Blob Storage?

Environment

SFTP Connectors

Answer

To ingest files stored on a file server hosted on Azure, do the following:

1. Use Azure Container Instances (ACI) that allow you to mount your file server within a container.
2. Use templates to set up a container for a new or existing file share.

To complete the Fivetran SFTP connection, you need the following:

• The username and password you used to create the container.
• The fully qualified domain name (FQDN). You can find this information in the container's Overview section.

Context

Creating a Virtual Machine (VM) based SFTP is non-optimal for maintenance and resource management.

Considerations

• The template setup uses a public-facing container and the All Network access rule for the storage account.

• The requirements within your organization 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. You can update this manually in the Fivetran console, but we recommend automating the approval process using our REST API.