Use a GPG key to encrypt data

Transcript

In this video, I will show how to use a GPG key that adjusts install data campaign control panel to encrypt the data that is leaving Adobe campaign standard instance. To get us started, I created a quick workflow and I’ve used a query activity to select a few records that I would like to explore to my SFTP folder.

So it’s just two records that I would like to export for the purposes of the demo. Next, I need to create and extract file activity. And first of all, I need to name my files that I would like to be put in. You can use some dynamic naming but for the purposes of the tutorial, I’m using video tutorial demo, and I’m also a pending date and time. And in the next step, in the output columns, you need to specify what are the columns that you would like to output as a part of this file. You can select as many as you like, but to keep things simple, I’m just selecting the email column. Next, I moved to the ad post-processing stage. This is where I tell campaign that I would like the data coming from campaign to be encrypted. And I select the encryption GPG key. If you notice this is a key that I’m selecting, and this is a comment that I’ve entered when creating the key. It is important to select the precise key that you would like to use and not other keys that are specified in the systems, because in this case, if you selected the wrong key, the receiving side, wouldn’t be able to decrypt it. It only able to decrypt the file where there is a private key match. And then file structure I specify that that would like a CSC file to be generated. And that’s all I need to do for the extract file activity. So I click on confirm. And now I need to actually export the file. I do that using the transfer file activity.

And in here I specify in the transfer files that I would like to use a file upload functionality and the protocols because I will be outputting into this FTP location. I quickly suggest what is this FTP location I’m transporting the file to, which I previously predefined, And what is the folder.

Now that I’ve connected the activities and made sure I have an end activity in the end, I start my workflow and I see that the workflow is run.

I want to check anything that can check the status, data structure, but most importantly, I will just go to my SFTP folder, refresh it and see that the file with GPG extension has been created. -

Transcript

In this video, I will show you how to encrypt data that is going to be leaving Adobe Campaign.

Now that I have installed a GPG public key into my control panel instance, I am able to use that public key in order to encrypt data that is going to be leaving Adobe campaign. To get me started, I will go to Adobe Campaign Classic Instance and create a simple query activity. You can use another activity. As you see, as a result of that query activity, I have three records that I would like to make into a file. So I use the data extraction file activity. I name my file recipient-tutorialdemo.csv and I’m using the CSV format to extract the data, and in the Edit File format, I make sure to specify that the file is going to include the following columns, just the email domains and the creation date.

If I want to specify any other options, I proceed with this, but for the purposes of this demo, I will just keep it very simple. Now, where do I do the encryption? To do the encryption, there are many options. But I would prefer to do it in the JavaScript activity. So I have written a short script, which will allow me to encrypt the data that comes from the Extract File activity. This script, you can find in the documentation. From the documentation, once I copy the script into the activity, and the only thing I need to do, really, is to replace the word fingerprint with the fingerprint of the key that I’ve just included with my public key that I installed with control panel. In order to copy that fingerprint, I click on the three dots, copy the fingerprint, and go back and paste it instead of the fingerprint. You’ll se that I am using varsfilename variable in order to consume the file that arrives from my Extract File activity. And I’m appending GPG extension to that filename after the encryptions. So as a result, I should get a .gpg file. I click on OK, and now after the encrypted file is created, I need to export it. To export that file into an external file activity, pretty much need to specify where am I exporting it, so I’m going to specify the option in the file transfer activity that it’s an upload activity. And I will specify that the file to upload is the one that was generated in the previous activity, in my case it’s a JavaScript activity. And I will specify that I would like to export it to a SFTP folder that I have previously set up into the incoming folder. Once I have specified all these options, I can simply check my SFTP folder. As you see, there is no file that’s called demo.csv.gpg. And I run my workflow.

It takes a second.

And in here, when I refresh my SFTP folder, I can see the recipient-tutorialdemo.csv.gpg file has been successfully imported.

In addition, I can also verify that the file has been created, and it’s decrypted from the journal, and that’s all. -