Decrypting files before ingensting

[archit_garg]

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!

[Amit_Kumar · Accepted solution]

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:

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

[shrinithiak]

Is it the same procedure for ACS?

[dikshac51668437]

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

[dikshac51668437]

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

[archit_garg]

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