Azure Blob Storage

This chapter describes how to set up and configure an Azure Blob Storage to save BLOBs (e.g. image files) that are stored in the Business Central database in a separate storage container.

If you use a separate storage container you don’t have to store big files (item pictures) that are rarely used in the database. By using an external storage container, the performance of the system/database can be improved.

This chapter is divided into the following chronological sections:

Set Up Storage Account in Microsoft Azure

This section describes how to set up a storage account in Microsoft Azure. This instruction is aimed at the IT administrator of your company/employees working in IT.

To set up a new storage account in Microsoft Azure, proceed as follows:

Note

If you click on the following link, you will leave the TRASER DOCS. TRASER Software GmbH isn’t responsible for the content on these websites.

Open Link in new tab

  • A new tab will open in your browser.
  • Log into your Microsoft Azure account.
  • Click into the search bar on the Microsoft Azure website and enter Storage Accounts.

Microsoft Azure

  • The page Storage Accounts opens. The page shows all storage accounts that have been set up so far.
  • Click New in the menu bar.

Set up new storage account

  • The page Create a storage account opens.
  • In the Subscription field, enter your subscription data. This field is filled out automatically.
  • In the Resource group field, enter the container that contains similar resources. Alternatively, you can create a separate container for the blob storage. Click on Create New to create a new container.
  • In the Instance Details tab, enter the name of the storage account in the Storage account name field. You cannot use capitalized letter for the name of the storage account. Write down the name of the storage account in a separate file or on a piece of paper.
  • In theRegion field, choose the geographic location that you are in.

Create new storage account

  • To create a new storage account, click on Review + Create at the bottom on the page.
  • To be able to review your settings, you will be shown a summary of the storage account settings.
  • Scroll to the bottom of the page and click on Create.

The storage account will be created. A message indicating that your storage account has been set up appears at the top of the page. This process can take a few minutes.
As soon as the storage account has been set up, a message will appear at the right-hand side of the page, indicating that your storage account has successfully been linked to the defined resource group. Click on the option Go to Resource. You can now start setting up the container. You can find more information about this in the section Set Up Storage Container in Microsoft Azure,.

Set Up Storage Container in Microsoft Azure

This section describes how to set up a container for a storage account in Microsoft Azure. To be able to set up a container, you have to have a storage account. Before carrying out the next steps, you have to set up a storage account as described in Set Up Storage Account in Microsoft Azure.

To set up a container for a storage account in Microsoft Azure, proceed as follows:

  • Select your storage account in Microsoft Azure. If you have selected the right storage account, the name of the storage account will be framed in blue in the menu bar on the left-hand side of the page.

New storage account

  • In the menu bar on the left-hand side of the page, click on Containers in the Data storage tab.
  • The page is updated.
  • To set up a new container, click Container.

New container

  • On the right-hand side of the page, a new pane opens.
  • In the Name field, enter the name of the container. Write down the name of the blob storage container in a separate file or on a piece of paper.
  • In the Public access level field, select the value Private (no anonymous access).
  • To finish setting up the container, click on Create at the bottom of the page.
  • The blob storage container will be shown on the list that contains all the storage containers linked to this storage account.

You have finished setting up the blob storage container. The following section describes how to schedule the automatic upload of files to the Azure blob storage.

Schedule Automatic Upload of Files

This section describes how to schedule the automatic upload of files to the Azure blob storage. Among other things, you will find out how to schedule the automatic upload for a specific day of the week.

To schedule the automatic upload of files to the Azure blob storage, proceed as follows:

  • Use the quick search (ALT+Q) in TRASER DMS 365 to find the page Azure Blob Storage Setup.
  • The page Azure Blob Storage Setup is displayed.

Schedule Automatic Upload

  • In the General tab, choose the value Automatic for the Upload to Azure field.
  • Activate the Automatic Schedule toggle switch in the Automatic Schedule tab.
  • You can now edit the Minutes between runs field.
  • Enter a value into the Minutes between Runs field. We recommend choosing the value 60 minutes.

You have set up an automatic schedule for uploads. In the following, you will find out how to schedule the upload for non-business days. Next, proceed as follows:

  • Use the quick search (ALT+Q) in TRASER DMS 365 to find the page Job Queue Entries.
  • The page Job Queue Entries is displayed.

Job Queue Entries

  • The column Description shows an entry called Automatic Blob Storage Upload. Select that entry.
  • Click Set On Hold in the menu bar.
  • The status of the entry is set to Hold.
  • To open the card of the job queue entry, click on On Hold in the Status column.
  • The card of the job queue entry is displayed.
  • In the Repetition tab, you can enter a day and time for the automatic upload. We recommend choosing a non-business day.

Set up intervals

You have set up the automatic upload to an Azure blob storage in TRASER DMS 365. The following section describes how to link a blob storage to TRASER DMS 365.

Link Blob Storage to Business Central

This section describes how to link a blob storage to TRASER DMS 365. Please read the sections Set Up Storage Account in Microsoft Azure and Set Up Storage Container in Microsoft Azure and perform the steps described in these sections before you continue.

To link a blob storage to TRASER DMS 365, proceed as follows:

Open Link in new tab

  • A new tab will open in your browser.
  • Log into your Microsoft Azure account.
  • Click into the search bar on the Microsoft Azure website and enter Storage Accounts.

Microsoft Azure

  • The page Storage Accounts opens. The page shows all storage accounts that have been set up so far.
  • Select the storage account that contains the blob storage container that you want to link to TRASER DMS 365.
  • In the menu bar on the left-hand side of the page, click on Shared access signature in the Settings tab.

Shared Access Signature

  • Create a new SAS token
  • Complete the following information:
Setting Description
Signing method Here, select Account key.
Signing key Here, select Key 1.
Permissions You have to grant all permissions when it comes to using SAS.
Start Specifies the date from which the SAS token is valid.
Expiry Specifies the date from which the SAS token will no longer be valid.
Allowed IP addresses Here, you can define IP addresses. We recommend not to touch this setting.
Allowed protocols Here, you can define protocols. We recommend choosing HTTPS only.
  • After entering all information, click on Generate SAS token and URL at the bottom of the page.
  • Beneath the button, two new fields will be displayed: Blob SAS token and Blob SAS URL.

Copy Shared Access Signature token

  • At the bottom of the Blob SAS token field, click on the clipboard icon (Copied).

The following steps will be carried out in TRASER DMS 365. You can open a new tab and proceed as follows:

  • Use the quick search (ALT+Q) in TRASER DMS 365 to find the page Azure Blob Storage Setup.
  • The page Azure Blob Storage Setup is displayed.
  • Fill in the information in the Blob Storage Information tab.

Set up link to Azure Blob Storage

Field Description
Storage Account Name In this field, enter the name of the storage account (in Microsoft Azure: Storage account name).
API Version In this field, enter the API version you would like to use. We recommend using the newest API version.
Source Container Name In this field, enter the name of the blob container.
  • Fill in the information in the Authentication Information tab.
Field Description
Authentication Type In this field, select the option Shared Access Signature.
For more information on the Shared Access Signature option, click on the following link: https://docs.microsoft.com/en-US/azure/storage/common/storage-sas-overview
Secret Key In this field, enter the copied value from the Blob SAS token field.

The link between the blob storage and TRASER DMS 365 will be created once you have entered the information mentioned above.