Unzip or decrypt a file unzipping-or-decrypting-a-file-before-processing
Adobe Campaign lets you import zipped or encrypted files. Before they can be read in a Data loading (file) activity, you can define a pre-processing to unzip or to decrypt the file.
To be able to do so:
-
Use the Control Panel to generate a public/private key pair in order to allow file decryption.
note note NOTE Control Panel is accessible to all Admin users. The steps to grant Admin access to a user are detailed in this page. Note that your instance must be hosted on AWS and upgraded with the latest GA build. Learn how to check your version in this section. To check if your instance is hosted on AWS, follow the steps detailed in this page. -
If your installation of Adobe Campaign is on premise, install the utility you want to use (for example: GPG, GZIP) as well as the necessary keys (encryption key) on the application server.
If your installation of Adobe Campaign is hosted by Adobe, contact Adobe Customer Care to have the necessary utilities installed on the server.
You can then use the desired pre-processing commands into your workflows:
- Add and configure a File transfer activity in your workflow.
- Add a Data loading (file) activity and define the file format.
- Check the Pre-process the file option.
- Specify the pre-processing command you want to apply.
- Add other activities to manage data coming from the file.
- Save and execute your workflow.
An example is presented in the use case below.
Related topics:
Use case: Import data encrypted using a key generated by Control Panel use-case-gpg-decrypt
In this use case, we will build a workflow in order to import data that has been encrypted in an external system, using a key generated in the Control Panel.
The steps to perform this use case are as follows:
-
Use the Control Panel to generate a key pair (public/private). Detailed steps are available in Control Panel documentation.
- The public key will be shared with the external system, which will use it to encrypt the data to send to Campaign.
- The private key will be used by Campaign Classic to decrypt the incoming encrypted data.
-
In the external system, use the public key downloaded from the Control Panel to encrypt the data to import into Campaign Classic.
-
In Campaign Classic, build a workflow to import the encrypted data and decrypt it using the private key that has been installed via the Control Panel. To do this, we will build a workflow as follows:
- File transfer activity: Transfers the file from an external source to Campaign Classic. In this example, we want transfer the file from an SFTP server.
- Data loading (file) activity: Loads the data from the file into the database and decrypt it using the private key generated in the Control Panel.
-
Open the File transfer activity then specify the external account from which you want to import the encrypted .gpg file.
Global concepts on how to configure the activity are available in this section.
-
Open the Data loading (file) activity, then configure it according to your needs. Global concepts on how to configure the activity are available in this section.
Add a pre-processing stage to the activity, in order to decrypt the incoming data. To do this, select the Pre-process the file option, then copy-paste this decryption command in the Command field :
gpg --batch --passphrase passphrase --decrypt <%=vars.filename%>
note caution CAUTION In this example, we are using the passphrase used by default by Control Panel, which is “passphrase”. If you have already had GPG keys installed on your instance through a Customer Care request in the past, the passphrase may have been changed and be different form the one by default. -
Click OK to confirm the activity configuration.
-
You can now run the workflow. Once it is executed, you can check in the workflow logs that the decryption has been executed, and that data from the file have been imported.
Tutorial video video
This video shows how to use a GPG key to decrypt data.
Additional Campaign Classic how-to videos are available here.