Versions Compared

Old Version 3

changes.mady.by.user Ritchie Piessens

Saved on

compared with

New Version 4

changes.mady.by.user Ritchie Piessens

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
English us

With Replica 365 you can replicate Business Central (“BC”) tables to Azure Table Storage (“ATS”“ATS”). In ATS you can store large amounts of data. You can use ATS to query on this set of data using applications like Excel and PowerBI. ATS scales it’s tables automatically as your demand increases.

Replicating your BC tables to ATS will lower the impact on your BC environment, so that your BC environment is not experiencing a significant load when a lot of data is requested for reports. Because the BC data is already available in ATS, reports will also be loaded faster. From ATS you can also use the data as a source for your BI environment, for example in Azure SQL or in your Data Warehouse.

Use the Replica 365 Setup page to configure the app.

Dutch

Gebruik de Replica 365 Setup pagina om de app te configureren.

Configure Replica 365
English us

Prerequisites

  1. A Microsoft Azure environment and Microsoft account with sufficient (admin) permissions to create a Storage account in Microsoft Azure;

  2. A Microsoft Azure Subscription (this may also be a free trial);

  3. The costs for Azure Table Storage can be determined approximately as follows:

    1. Determine the BC tables you want to replicate, by opening the BC page [Table Information]

      1. The column “Data Size (KB)” shows the size in KB’s for each table;

      2. Filter on the tables you are planning to replicate;

      3. Calculate the Sum of the column “Data Size (KB) for all tables you are planning to replicate.

image-20240326-102043.pngImage Added

  1. Calculate the price for ATS using Microsoft’s Data Storage pricelist. Attention: There is a fee for each GB of data that is being stored in ATS + a fee that’s calculated based on the number of transactions.

Preparations

  1. Setup a Storage account in Microsoft Azure

  2. Setup a Shared Access Signature (“SAS”)

1. Setup a Storage account in Microsoft Azure

  1. Sign in to the Azure Portal: https://portal.azure.com

  2. Open the menu on the left side of the screen and click on “Storage accounts”

  3. Click on “Create”

image-20240326-101425.pngImage Added

Behavior with this function activated

Once activated, you can use the Custom Report Layout 11295262 for Payment Reminders for your Customers.

image-20240319-121813.pngImage Modifiedimage-20240319-121842.pngImage Modified