Learn how to export data using a GPG key installed on Control Panel
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. -
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.
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. -