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 HostRequired. Specify the server host URLhttps://[Host]:[Port]/[Instance]/oDataV4.UsernameRequired. Specify the username.Access KeyRequired. Specify the access key.CompanyRequired. Specify value in format Company('[id]').Object ListRequired. This parameter accepts comma-separated values if you want to pull data from multiple Dynamics Business Central objects, e.g. PurchasePrices.Batch SizeRequired. The default is set to 200.Query ParameterOptional. Multiple query parameters are separated by a new line.CompressionOptional. The default is set to false.
Azure Blob Storage
Server HostRequired. Specify the storage account name in the server host URLhttps://[account].blob.core.windows.net.Storage AccountRequired. Specify the storage account name.Shared KeyRequired. Specify the shared key.Destination FolderRequired. 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.