Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Processing encrypted (PGP encryption) files using ODI 11g (11.1.1.7)

srivatsan purushothamanApr 25 2013 — edited Apr 25 2013

Hi,
I am using ODI 11g (11.1.1.7) which is hosted on a Windows 7 server, One of my requirement is to read encrypted flat files (CSV) and load the data into oracle tables. The incoming flat file is encrypted based on PGP encryption. Also, for a different set of interfaces, I have to retrieve the data from Oracle tables, populate it in a flat file (CSV) and then encrypt using PGP encryption. Is there any direct method in ODI to process the encrypted files?

When I searched the forums, I got only work-arounds like executing a shell script which will do the pre-processing and then having the interface pick the processed file. I didnt get any direct method using ODI.

Thanks,
Srivatsan P

Locked Post

New comments cannot be posted to this locked post.

Locked on May 23 2013

Added on Apr 25 2013

#business-intelligence-applications, #data-integrator, #system-management-and-integration

1 comment

1,065 views