Couchdrop
Published in

Couchdrop

Automated SFTP with PGP encryption and decryption

The ability to automatically send and receive data to and from an SFTP server is becoming more prevalent, especially with the uptake of communication across health, finance and logistics in this space. Adding the requirement to have files encrypted and decrypted with PGP can add complexity, especially when you want the process to be fully automated and use your own cloud storage, such as; SharePoint, Box or block storage such as Amazon S3 or Azure.

Couchdrop’s Cloud MFT can enable organizations to automatically pull data from a storage location whether it is SFTP or a cloud platform like SharePoint, encrypt the data with PGP and automatically send it to a remote location or ingest it themselves via SFTP or another cloud. The reverse can also be configured to automate the entire file exchange process.

To use Couchdrop MFT for a one-directional trip you will need the following:

  • Your source platform information (SFTP connection details for example)
  • Your destination platform (for example SharePoint or a third party SFTP location)
  • Your PGP public keys (for encryption) or private key (for decryption)

Connect platform to ingest from

Within the Couchdrop product create a storage connection to your source platform, for this guide we are using a subfolder (/hosted/import) within an SFTP server to ingest the data from.

cloud managed file transfer pgp
Configuring an SFTP endpoint within Couchdrop’s Cloud MFT

Connect platform to stored ingested data / load data into

Next connect your storage location where you wish to store the data. We will mount a subfolder (/Customer Imports) within a SharePoint site to store the data.

managed file transfer sharepoint pgp
Connecting SharePoint as a storage endpoint within Couchdrop’s Cloud MFT

Configure Automated Schedule

We will create a schedule to pull data from the SFTP server and then copy it into the SharePoint location encrypted.

From the below you will see that every hour we will pull all files from the SFTP server and copy them over to the SharePoint subfolder encrypted. This schedule could be customized to be more frequent down to 15 minute intervals. Take note of the variable {EXISTING_NAME} this retains the original filename, we’re also appending .pgp at the end of the filename to highlight the file(s) are encrypted.

pgp encryption sharepoint sftp mft
Configuring the conditions of the scheduled import
managed file transfer cloud sharepoint encryption automated import
Configuring the action to be taken on the files during import

Testing Schedule

You can force the schedule to import the files as a test by selecting “Test” from the menu beside the workflow.

cloud managed file transfer (MFT)
Testing the workflow

When checking the audit log you can see the schedule has operated correctly, by downloading the files from the SFTP server and automatically uploaded them to SharePoint encrypted.

automated file importing managed file transfer cloud sftp
Audit log of events

You can also see the files have appeared in the destination encrypted with the appended .pgp extension while retaining their name.

sharepoint sftp pgp ftp
Files showing in the virtual file system (a reflection of the folder in SharePoint)

For more information or to get started jump across to couchdrop.io or for more guides see community.couchdrop.io

--

--

--

Couchdrop is the secure file gateway and cloud SFTP / MFT platform. Couchdrop acts as your secure access method between systems or for clients to send you files to your cloud storage backend, that can be completely automated.

Recommended from Medium

The Evolution of Connecting Cameras to the Cloud Service

Don’t Fall For Those Enticing Text Messages

Hydra room writeup (Try hack me)

Discovering an Undisclosed Stack Overflow Vulnerability in Microsoft SQL Server (CVE-2019–1068)

{UPDATE} Snake Vs Colors Hack Free Resources Generator

Data protection — What is really important for HR

What is the future of penetration testing?

What Do Cyber Security Professionals Need To Know

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jayden Bartram

Jayden Bartram

COO of Couchdrop and Movebot

More from Medium

Set up Recurring Reservations in AssetSonar: Ensure Equipment Availability at Regular Events

Recurring Reservations

Writing My Own Chapter In NUS School of Computing

Team Skills -Part 1. Checklist for Sending the Email

Build Automations for Dynamics 365 Finance and Operations