PGP Decryption

[Manning_Oz]

Hi, we're doing a proof-of-concept for Alteryx, and the very first task is to decrypt a PGP encrypted file pulled from an SFTP server.

I did a forum search and this topic hasn't been discussed for almost 2 years, so I am "hoping" that maybe some new feature has been added that makes this possible.

If it can't be done natively, does anyone have any suggestions?

[WillBowman]

I am an encryption novice, but it appears there are several command line options to decrypt PGP. I would call those (via batch file) with the command line tool in alteryx.

1. cli https://support.symantec.com/en_US/article.TECH211002.html (I can't tell if this is their product or just a how to)  It is $6000

2. run batch file https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Run-a-batch-file-from-Run-Command-tool...

EDIT:

New proposal is to use python in the python tool. https://pypi.org/project/py-pgp/ 

Again, I don't really know much about decryption. But python tool and command line (which can run batch, python, C, Fortran, blah blah blah) are the best options for situations where there isn't a native solution.

[Manning_Oz]

Hi Will

Thanks for that. Yes, my research thus far indicated that either a command line or Python approach would be best.

I am hopeful of making Alteryx the default data handling platform within our organisation (currently using an array of tools, including Jitterbit, SSIS and naked code). 

Obviously there are many more tasks required other than PGP decryption, so I will find a way to convince my organisation that this particular requirement is a minor issue. If we install PGP on the Alteryx server then I should be able to handle decryption no problem.

[Powya]

Hi @Manning_Oz 

I have the same challenge, can you please let me know if you found a solution? 

Many thanks

[tgkermode]

By far the simplest method for this if you are using a PGP key / password is using the pgpy library which is based on the same tech as GnuPG but doesn't require any gpg install.

Pgpy won't be installed in alteryx so you need to run the function below from the python tool to set it up.

Then load file / key to decrypt, job done.. that simple