This gem enables the efficient transfer of data from multiple Dynamics Business Central objects to a designated Azure Blob Storage container. This robust solution enhances data management, accessibility, and scalability by centralizing data from diverse Dynamics Business Central objects within the secure and scalable Azure Blob Storage environment in the form of CSV files. The uploaded files will be named as Object_currentdate
.
Setup Guide
This gem will pull the data from each Dynamics Business Central object specified in the Object List
parameter. The integration will then generate a CSV file for each object and send all files to the desired Azure Blob Storage container.
To run this gem and connect Dynamics Business Central to Azure Blob Storage, it is necessary to configure the parameters that are mentioned below.
Dynamics Business Central
Server Host
Required. Specify the server host URLhttps://[Host]:[Port]/[Instance]/oDataV4
.Username
Required. Specify the username.Access Key
Required. Specify the access key.Company
Required. Specify value in format Company('[id]').Object List
Required. This parameter accepts comma-separated values if you want to pull data from multiple Dynamics Business Central objects, e.g. PurchasePrices.Batch Size
Required. The default is set to 200.Query Parameter
Optional. Multiple query parameters are separated by a new line.Compression
Optional. The default is set to false.
Azure Blob Storage
Server Host
Required. Specify the storage account name in the server host URLhttps://[account].blob.core.windows.net
.Storage Account
Required. Specify the storage account name.Shared Key
Required. Specify the shared key.Destination Folder
Required. Specify the path to the destination folder ending with the trailing slash.
Note This integration only supports Shared Key authentication type for Azure Blob Storage.