10 Replies Latest reply on May 30, 2018 11:05 AM by Sachin Naik

How to do PGP encryption to a file while uploading to UCM

Sachin Naik May 16, 2018 8:44 AM

We want to achieve PGP encryption for our HDL files while they are waiting in UCM for HDL process pick up.

I know we can do PGP encryption in the FTP adapter however how can we do that in case of UCM.

We want to create HDL file in ICS then encrypt it and upload to UCM.

Any help/pointers appreciated.

Thanks,

Sachin

1. Re: How to do PGP encryption to a file while uploading to UCM

Hemanth Lakkaraju-Oracle May 16, 2018 9:57 AM (in response to Sachin Naik)

Is the question here about - How to achieve PGP encryption without using FTP Adapter?
Like Show 0 Likes(0)

Actions
2. Re: How to do PGP encryption to a file while uploading to UCM

Sachin Naik May 16, 2018 11:52 AM (in response to Hemanth Lakkaraju-Oracle)

Yes thats correct.We want to encrypt the file in ICS and then upload to UCM
Like Show 0 Likes(0)

Actions
3. Re: How to do PGP encryption to a file while uploading to UCM

Ravi Sankaran-Oracle May 16, 2018 1:17 PM (in response to Sachin Naik)

Sachin,

PGP Encryption as well as Decryption support in Stage File Action is in the works.

Ravi
Like Show 0 Likes(0)

Actions
4. Re: How to do PGP encryption to a file while uploading to UCM

Sachin Naik May 16, 2018 3:09 PM (in response to Ravi Sankaran-Oracle)

OK thanks for the information.Is there any workaround till this comes out.
Like Show 0 Likes(0)

Actions
5. Re: How to do PGP encryption to a file while uploading to UCM

Hemanth Lakkaraju-Oracle May 16, 2018 3:12 PM (in response to Sachin Naik)

As far as I know, FTP Adapter is the only option.
Like Show 0 Likes(0)

Actions
6. Re: How to do PGP encryption to a file while uploading to UCM

Ravi Sankaran-Oracle May 17, 2018 4:09 AM (in response to Hemanth Lakkaraju-Oracle)

Hi Sachin,

Hemanth is correct.

Here is the work around - use FTP Adapter to write the file on a sFTP server in encrypted mode - and you would then want to use FTP adapter to download the newly created file from sFTP server to ICS - And the last step would be to use the SOAP Adapter for uploading the file to UCM

Ravi
Like Show 0 Likes(0)

Actions
7. Re: How to do PGP encryption to a file while uploading to UCM

Ravi Sankaran-Oracle May 28, 2018 2:44 AM (in response to Ravi Sankaran-Oracle)

Hello Sachin,

did you get a chance to try this option?

Ravi
Like Show 1 Likes(1)

Actions
8. Re: How to do PGP encryption to a file while uploading to UCM

Sachin Naik May 28, 2018 12:47 PM (in response to Ravi Sankaran-Oracle)

Not yet.We have following issue to go for the FTP adapter.
1. We have only one ftp server which is our source system,The source system encrypts the file using its public key and keeps the file on the ftp server
2. We read that file in ICS and decrypt it and do the transformations and create a new file
3. Now this new file needs to be encrypted with the public key of Oracle HCM and not the source system mentioned in step 1.
4. If we push the same file again to the ftp server it will be the public key of source system however we want oracle public key for encryption so that that cab be decrypted by oracle while upload.

Thanks,
Sachin
Like Show 0 Likes(0)

Actions
9. Re: How to do PGP encryption to a file while uploading to UCM

Ravi Sankaran-Oracle May 29, 2018 12:11 AM (in response to Sachin Naik)

Sachin,

Steps #1 & #2 will remain the same

Step 3 - for this , you could either use the same FTP adapter, and specify the public key or create a new FTP adapter specific connection - and specify the public key. The private key you specified for the FTP connection (the connection you used for connecting to the sFTP server that had the file from source system) is used for step #2 for decrypting the ffile that the source system has placed in step #1. The public key you specify in the FTP connection will be the same public key you got from HCM Cloud. You could use the FTP Adapter to write the file into sFTP server with encryption enabled

Step 4 - use FTP Adapter to download the newly created file (in encrypted mode) from sFTP server - but without decryption -

Step 5 - upload the file to HCM Cloud

hope it makes sense
Like Show 1 Likes(1)

Actions
10. Re: How to do PGP encryption to a file while uploading to UCM

Sachin Naik May 30, 2018 11:05 AM (in response to Ravi Sankaran-Oracle)

Thanks Ravi.
So the solution could be
same FTP adapter connection but keys specified different.
Public key - Public key from HCM cloud
Private key - Private key from Source system.

I will try this out,Thanks
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.