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