Tuesday, August 24, 2021

OIC - Encrypt and Decrypt using FTP adapter and PGP

Use Case: Here, we will first read a csv file and then encrypt the file (with Write) and then read the encrypted file and decrypt the file(with Write).

Implementation steps:

Step1: Create a FTP connection using PGP keys. Follow below blog:

https://soalicious.blogspot.com/2021/08/oic-create-sftp-connection-with-pgp.html

Step2: Create a scheduled orchestrated integration and drag and drop FTP connection and configure with read operation with input directory and filename details and provide a CSV file as schema reference.


Step3: drag and drop FTP connection and Write with output directory and filename and select PGP encryption option.


Step4: map the read file details to write fields.


Step5: drag and drop FTP server and read the encrypted file with inpit directory and file name details.


Step6: map the write file fields to read encrypted file fields.


Step7: Drag and drop FTP with Write operation and select Perform PGP Decryption option as below.


Step8: map the file fields


Step9: add tracking and now the integration will like as below. Save it and test.


Input CSV file:


Encrypted file:


Decrypted file:



No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...