Encryption Decryption Support in Stage File (Oracle Integration Cloud)

This video will help you to learn how to use two new features(Encrypt and Decrypt Data) of Stage File in Oracle Integration Cloud.

[@garapatisatish1053]

Hi Ankur, Good Explanation...thanks for sharing knowledge. FTP Adapter has download operation with decrypt option, why do we need stage decrypt here? Better make a video on FTP decrypt & encrypt and also compare with STAGE decrypt & encrypt.

[@TechSupper]

Hi Garapati, Might be usefull, before you insert data into downstream application, you want to do some transformation, so you can first decrypt the file on stage and do the transformation.

[@BeautifulEarth9876]

@@TechSupper hi Ankur, thanks for this helpful video. I noticed that you are using the Stage file operations - 'Read' and 'Write' for decryption and encryption respectively, but I think it only supports upto 10 MB files. Can we use the Encrypt File or Decrypt File in the Stage operation dropdown at say, 13:28. I think this will provide a better support of files upto even 1 GB size. What do you say about it?

[@tharunkumar7632]

Hi ankur very good explanation. Did encoding data and encrypting data both are same

[@TechSupper]

No, both are different. Please check this stackoverflow.com/questions/4657416/difference-between-encoding-and-encryption Please subscribe to my KZbin channel kzbin.info if you have not subscribed yet.

[@MohsinKhanSC]

Hi Ankur, How we can pick PGP keys dynamically? Is there any option to use certificates using lookup? My requirement is to pick PGP keys based on operating unit and encrypt the files.

[@TechSupper]

Hi Moshin, No, it's not possible in OIC. Subscribe to my youtube channel kzbin.info if you have not subscribed yet.

[@swatimamgain4043]

Hi Ankur , thanks for this. I have one requirement to encrypt a file, but the file is a combination of two different schemas. How do i encrypt it?

[@TechSupper]

You can combine both the files first and then encrypt

[@swatimamgain4043]

I understand that, i have already combined the two files, but when you stage encrypt it, it asks for the schema right, as you have done it. How do i tackle that?

[@dineshkumar-vi8ul]

how do we get the rest url that we have to mention while configuring the REST Connection.

[@TechSupper]

Hi Dinesh, If you want to consume third party REST API then the REST URL will be given by API provider. Please subscribe to my channel if you have not subscribed yet.

[@hemanthkumarreddy7472]

is this applicable for file size greater than 10 MB ?

[@TechSupper]

No Hemanth. It's limited to 10MB only.

[@nikilvaradharaj7087]

Can you share me the sample json file which you sent which used sample.json

[@TechSupper]

can you please exactly tell me the exact time that I can refer to get the json.

[@srikanthreddy3688]

Could you tell me how to download certificate please?

[@TechSupper]

Which cetificate you would like to download.

[@srikanthreddy3688]

PGP public and private certificate

[@TechSupper]

You can create dummy certificate from pgpkeygen.com/

[@sunnybajaj4993]

Opaque schema ka content dikhn

[@TechSupper]