How to configure SSL communication between PI and Oracle 12 DB

[gopalkrishna_baliga]

Hi experts,

I have a requirement where I need to call Oracle DB from PI using SSL. Oracle DB version is 12. In PI side I have configured receiver JDBC communication channel.

Idea is to encrypt the data that is sent from PI to Oracle DB and vice-versa.

I did search the internet but not getting any clarity on the same.

In the Past I had a similar case with MSSQL server and it worked fine.

For MSSQL in PI JDBC communication channel I have just added below parameters in the connection value: encrypt=true;trustServerCertificate=true;

Same does not work with Oracle. Looks like we need to use Additional parameters.

Can some body help what need to be done in PI channel? Also what setup is needed in Oracle DB adminstration level?

Thanks

Gopal

[TomXing]

Hi Gopal,

The encryption are done on driver side (Oracle JDBC driver <-> Oracle DB).
It first of all depends on how Oracle handles the secure communications.

This old wiki gives some clue.
Also see this SAP KBA.

Best regards,
Tom

[gopalkrishna_baliga]

Hi Tom,

Thanks for your answer. appreciate it.

I have already seen the Wiki link you gave but images in that wiki are not loading.

Are these images getting displayed for you? If Yes, can you share it here or email me at gopalbaliga@rediffmail.com?

SAP KBA link is also not working for me.

Thanks

Gopal

[TomXing]

Hi Gopal,

You'll need an S-user to access SAP KBA.
There's a visible picture in the KBA.

I don't think it's good to "smuggle" some information that requires authentication. =D

But basically you have to add parameters like

driver:oracle.net.encryption_client = REQUIRED
driver:oracle.net.encryption_types_client = AES256
driver:oracle.net.crypto_checksum_client = REQUIRED
driver:oracle.net.crypto_checksum_types_client = SHA1

Best regards,
Tom