Tuesday, August 24, 2021

OIC - Decrypt file using FTP download operation and read reference in stage activity

Use Case: Here, we will download (with decrypt) an encrypyed csv file without schema option  and then read file reference using stage read entire file option.

Implementation steps:

Step1: First create FTP connection following below blog:


Step2: Create an orchestrated intwgration and drag and drop FTP connection and download the file with pgp encrypt option.

Step3: add the stage activity and choose the read the entire file option and provide the file reference from download response object.

Step4: provide the csv sample file for reading the reference.

Now the integration flow will like as below:

Save and test.

Encrypted csv file:

From Monitoring - view activity stream:

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...