Skip to Content
0
Jul 05, 2018 at 06:06 AM

How to configure SSL communication between PI and Oracle 12 DB

260 Views Last edit Jul 05, 2018 at 06:33 AM 3 rev

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