SFTP usage in Dynamics 365 Business Central

There are 2 possible situations:

• SFTP server provided to us and we can read/write files from there
• we create our own SFTP server where the files are uploaded to from outside, and handled by us

In both cases we will use an Azure Storage Account.

• there is a native integration in between Azure Storage and Business Central
• Storage Account can be used as SFTP server
• Storage account events can be used for Logic Apps. Logic Apps also has a connector to SFTP server.

What is Azure Storage Account and how to create it:

https://learn.microsoft.com/en-us/azure/storage/common/storage-account-overview

Azure Storage API to handle files:

https://learn.microsoft.com/en-us/rest/api/storageservices/blob-service-rest-api

Finally, Business Central has Azure Blob Storage (ABS) module. You can find it by filtering codeunits of the System Application:

ABS Container Client allows to manage containers and ABS Blob client allows to manage blobs inside containers.

Now let's describe some scenarios.

We create our own SFTP server, and read files from there.

When you create a storage account - choose "Enable hierarchical namespace" and "Enable SFTP":

Add local user on the SFTP tab. This user will be used to connect to the SFTP server.

Your partner (vendor or customer) provides SFTP server and we send files to the SFTP server from Business Central.

You don't need to enable SFTP on your storage account, but you should use an intermediate connector between your Storage Account and partner's SFTP - Azure Logic App.

Logic Apps provides many triggers. For example, we can create the following process:

• send a file from Business Central to Azure Blob Storage
• use "when blob added" trigger of Azure Logic App
• send created file to partner's SFTP

The scenario will look like this inside the Logic App:

Your partner provides SFTP server and we must read files from there.

Similar to the previous scenario:

• use "When a file added to SFTP" trigger in Logic App
• create a file in your Storage Account
• delete the file on SFTP if needed
• read the file from Storage Account with ABS module of Business Central.

Here in Siberus we have strong expertise in Azure Logic Apps and Blob Storage functionality. Should you require an assistance with Business Central and SFTP integration - feel free to reach out.