Dynamics Business Central to SFTP by COZYROC

This gem enables the efficient transfer of data from multiple Dynamics Business Central objects to a designated SFTP folder. This robust solution enhances data management, accessibility, and scalability by centralizing data from various Dynamics Business Central objects into a secure SFTP 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 SFTP folder.

To run this gem and connect Dynamics Business Central to SFTP Server, 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.

SFTP

• Server Host Required. Specify the name or IP address of the SFTP server.
• Port Required. Specify the port number.
• Username Required. Specify a username to access the SFTP server.
• Password Required. Specify a password to access the SFTP server.
• Destination Folder Required. Specify the path to the destination folder ending with a trailing slash.