Expand my Community achievements bar.

SOLVED

Decrypting files before ingensting

Avatar

Level 3

Since the data files that will be uploaded to Campaign Servers will have PII data, the source system will encrypt (PGP encryption) the data files before uploading them to Adobe Campaign server. As part of the data ingestion process/workflow, we need to first decrypt the files and then ingest the data. Can you please suggest potential solutions for achieving it?

Thanks!

1 Accepted Solution

Avatar

Correct answer by
Level 10

Hi,

There are two options to solve this

option 1: use the "script" i.e use shell script , activity to decrypt the file in the workflow before importing file into adobe  campaign.

option 2: you can follow the following steps:

Step 1:

download pgp either from https://sourceforge.net/projects/ppgp/ or https://pgp.en.softonic.com/

step 2: install the pgp

step 3: Use Data loading (file) activity in your adobe campaign workflow:

step 4: choose pre process the file option: refer to screen:

Capture.PNG

Step 5: Use the following command:

<path-to_pgp_if-not_global_or_server/>pgp.exe --decrypt --input nl6/var/vp/import/filename.pgp --passphrase "your password" --recipient recipient @email.com --verbose --output nl6/var/vp/import/filename

step 6 : save and execute the workflow.

Regards,

Amit

View solution in original post

5 Replies

Avatar

Correct answer by
Level 10

Hi,

There are two options to solve this

option 1: use the "script" i.e use shell script , activity to decrypt the file in the workflow before importing file into adobe  campaign.

option 2: you can follow the following steps:

Step 1:

download pgp either from https://sourceforge.net/projects/ppgp/ or https://pgp.en.softonic.com/

step 2: install the pgp

step 3: Use Data loading (file) activity in your adobe campaign workflow:

step 4: choose pre process the file option: refer to screen:

Capture.PNG

Step 5: Use the following command:

<path-to_pgp_if-not_global_or_server/>pgp.exe --decrypt --input nl6/var/vp/import/filename.pgp --passphrase "your password" --recipient recipient @email.com --verbose --output nl6/var/vp/import/filename

step 6 : save and execute the workflow.

Regards,

Amit

Avatar

Level 1

Hi @Amit_Kumar ,

I have tried above solution but i am getting "WKF-560006 An error occurred when loading the '' file ('Data loading (file)' step) BAS-010014 Cannot open file 'PAth to file' with read access (errno=3, The system cannot find the path specified.)" this error.

could you please help me to solve the error. 

Thanks,

Diksha

 

 

Avatar

Level 1

Hi @Amit_Kumar ,

I have tried above solution but i am getting "WKF-560006 An error occurred when loading the '' file ('Data loading (file)' step) BAS-010014 Cannot open file 'PAth to file' with read access (errno=3, The system cannot find the path specified.)" this error.

could you please help me to solve the error. 

Thanks,

Diksha

 

Avatar

Level 3

Thanks a lot Amit for the detailed response. We will try out the solution options that you suggested.