Dynamics Business Central to Amazon S3 by COZYROC

This gem enables the efficient transfer of data from multiple Dynamics Business Central objects to a designated Amazon S3 bucket. This robust solution enhances data management, accessibility, and scalability by centralizing data from diverse Dynamic Business Central objects within the secure and scalable Amazon cloud 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 gem will then generate a CSV file for each object and send all files to the desired Amazon S3 bucket.

To run this gem and connect Dynamics Business Central to Amazon S3, it is necessary to configure the parameters that are mentioned below.

Dynamics Business Central

• Server Host Required. Specify the server URL https://[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.

Amazon S3

• Server Host Required. Provide the relevant [bucket] and [region] in the Server URL.
• Access Key Required. Specify the access key for Amazon S3 service.
• Secret Key Required. Specify the secret key for Amazon S3 service.
• Destination Folder Required. Specify the path to the destination folder ending with a trailing slash.