Database with encyption

[Former Member]

Hi all,

We have to develop a PI interface which will fetch the data from a database table and send it to SAP. Since this data is highly sensitive the requirement is to make the transmission secure and also encrypt the data before PI picks it from the database.

Can you please suggest how this can be achieved. Does the JDBC adapter support encryptionor SSL

Thanks

Srikanth

[baskar_gopalakrishnan2]

>Can you please suggest how this can be achieved. Does the JDBC adapter support encryptionor SSL?

Yes it is possible. What is your backend database?. If it is oracle, the answer is sure yes. I don' know about other databases.  You have to do encryption at the jdbc adapter level and we need to do decrypt on the oracle database end. I think oracle 11 versions support this. There are some versions of 10 too. check with oracle team about encryption decryption support on their end.

Please check this wiki.. good one.

http://wiki.sdn.sap.com/wiki/display/XI/Encryption+in+scenarios+involving+JDBC+Adapter+with+Oracle+D...

Hope that helps ....