Decrypt data

Transcript

In this video, I will show you how to decrypt data that arrives to Adobe Campaign. But before we get started, I want to make sure that I give you an overview of the entire procedure. Decrypting encrypted data that arrives to Adobe Campaign is a five-step process. The first two steps take on Adobe Campaign Control Panel. For this you need to generate a public/private key pair using Campaign Control Panel. You then download the public key and use that public key to encrypt your data. Then in Adobe Campaign instance itself, when you transfer the file from the outside system, you need to specify that the file is encrypted and you would like to decrypt it using the private key that has been installed. To get us started, navigate to Adobe Campaign Control Panel, go to Instance Setting card, navigate to GPG Keys, and select the instance that you would like to work with.

So, I get started by generating the key. So, I click on Generate Key button.

And here, the important part is I would like to name my key such that I could remember what was this key used for. So for this case, I will just name Video Tutorial, and I click on Generate Key. That generates a private/public key pair, and I will soon be able to see it on Adobe Campaign Control Panel.

As you see within seconds, my key is here. Now in order to download the public key, I click on Download Key, and my public key now is downloaded to my computer.

From here I can use this key, so you I see that it has been imported successfully, I can use this key now, a public key to encrypt my data that comes to Adobe Campaign. Now, there are five steps to decrypting data arriving to Adobe Campaign with GPG Decryption. I’ve already created a key in Adobe Campaign Control Panel and I’ve downloaded the public key. Now I’ve used the public key that I have downloaded from Control Panel to encrypt the file in the outside system. I’ve already done the encryption. Now, what I’m going to show you in this section is how to decrypt the data that has been encrypted for that public key.

So I go to my outside system which contains the file, and you’ll see in here it has a GPG extension. In order to make the file arrive to Adobe Campaign, so I use a File Transfer activity and I specify the action to be File download. I will be downloading the file from my external SFTP account, but I can also use Amazon S Three or Azure Blob, or another external system. So, all I need to do in here is to specify that the external account that I’m using, in this case, my Adobe SMTP account and the file. You can also use variables or do it in a much more sophisticated way, but for the purposes of this video, I just copy-pasted the name of the file. Then I go and create a Load file activity. So, this Load file activity. I’ve already pre-configured it by loading a sample file though the schema is recognized. And now in the pre-processing stage, this is where I have to tell Campaign that this file is in fact encrypted, and I need to decrypt it. So in the add processing stage, by default, it’s set to process the file without having to decrypt anything. So I need to specify that this file is encrypted, and I would like to decrypt it using a GPG. Notice that I didn’t have to specify the specific key that I would use for decryption. This is because, remember the private key is stored on Adobe Campaign Control Panel and it intelligently recognizes which key to use. You do not have to specify what private key to use for decrypting the file. I click Confirm, and this is pretty much it. Now, when I start running my workflow, the file will be downloaded from an SFTP server, and decrypted with the public/private key that I have installed.

You see the Data Structure is recognized. And in fact, I did have an email and the name in my file that I just uploaded.

That’s all. -

Transcript

In this video, I will show you how to decrypt data that arrives to Adobe Campaign. But before we get started, I want to make sure that I give you an overview of the entire procedure. Decrypting encrypted data that arrives to Adobe Campaign is a five-step process. The first two steps take an Adobe Campaign control panel. For this, you need to generate a public private key pair using Campaign control panel. You then download the public key and use that public key to encrypt your data. Then in Adobe Campaign instance itself, when you transfer the file from the outside system, you need to specify that the file is encrypted and you would like to decrypt it using the private key that has been installed. To get us started, navigate to Adobe Campaign control panel, go to Instance Setting card, navigate to GPG Keys and select the instance that you would like to work with.

So I get started by generating the key, so I click on Generate Key button. In here, the important part is I would like to name my key, such that I could remember what was this key used for. So, for this case, I will just name Video Tutorial. And I click on Generate Key, that generates a private public key pair. And I will soon be able to see it on Adobe Campaign control panel.

As you see, within seconds, my key is here. Now in order to download the public key, I click on Download Key, and my public key now is downloaded to my computer.

From here, I can use this key, so I see that it has been imported successfully. I can use this key now, public key, to encrypt my data that comes to Adobe Campaign. There are five steps to decrypting data arriving to Adobe Campaign with GPG decryption. I’ve already created a key in Adobe Campaign control panel and I’ve downloaded the public key. Now I’ve used the public key that I have downloaded from control panel to encrypt the file in the outside system. I’ve already done the encryption. Now, what I’m going to show you in this section is how to decrypt the data that has been encrypted with that public key.

I have placed that file into my SFTP folders and I named it recipient-Sunday.csv.gpg. You see that the file is encrypted because it has a GPG extension. Now I just copied the name of the file because I will be using that name of the file to load that file. So, in order to load the file, I’m using the file download activity.

And I specify that the file is coming from the SFTP account, if I had other accounts I could specify it here, and the what the name of the file is. If you like, you can use more sophisticated functions and use some variable name of the file, but for the purposes of this demo, I just copy and pasted the name of a file into the activity. Click OK in the file transfer activity. And next, in order to decrypt the file, I need to use the data loading file activity. So I connect my file transfer activity and I use the data loading file activity. If you notice in here prior to doing this, I actually preloaded a test file into the data loading activity. That’s in order to enable Campaign understand what is the file structure of the file that is coming into here. So I’ve had a copy of the sample file on my computer, so adobetechops1.prod3, which I loaded and enabled Campaign to recognize what the structure was. It recognized what number of column was, but it doesn’t matter how many rows you have in the file because the most important thing is the column and structure. I also recognized that I have a comma delimited file. In the preprocessing file, I make sure that I click on preprocessing file that the file indeed needs to be decrypted. And I copy pasted that function from documentation that tells Campaign that the file needs to be decrypted via the GPG. So, if you notice in here, now I’m using the virus file name. This is just a variable that I’m using in order to recognize that the file coming in actually comes from the previous activity, the file transfer activity. You will also notice that I’m using a passphrase, by default, control panel uses a passphrase, just passphrase. Then this is what you can specify as well in here.

You know this that I actually do not specify a specific key with which to decrypt a file, that’s because the way Campaign works, it actually will automatically match the public key with which the file was encrypted to the private key that it has on file in order to do the decryption. So you don’t have to specify yourself what key you want to be using. Now, if I wanted to continue with a workflow, I can include query activity or enrichment activity, or edit scheme activity, or any other number of activities. But for the purposes of this tutorial, I just wanted to show you how to do a decryption. And now I just ran this workflow. You see that the workload finished and I got four results, two rows, two columns. And I can see here that the schema has been recognized. And if I wanted to further understand if my activities have been executed correctly, I could check the journal and the logs, and see what was the status of my activities. And you can see in here that the file was loaded as a GPG encrypted file. And it was in fact loaded and decrypted using the decrypt command that I specified in pre-processing stage. The status is blue on this activity, so I know now that the command executed correctly. -