Encryption and Decryption at SAP/Oracle
We have a requirement where we need to Encrypt a custom infotype field values (1 record) and same needs to be decrypted at Oracle.
Data Movement Flow is as below:
SAP HCM System -> SAP PI System -> ORacle system.
Can you please help me in understanding how this can be achieved.
Stefan Koehler replied
what you are looking for is called Oracle TDE (Transparent Data Encryption) or to be more specific "TDE Column Encryption". However be aware of the limits of encrypted index columns. The whole stuff is very well explained in SAPnote #974876 (" Oracle Transparent Data Encryption (TDE)").
In addition here are some interesting links to consider:
- ORACLE 11g TDE (Transparent Data Encryption) on SAP ERP - Performance Impact ???
- Indexing and Transparent Data Encryption Part I (The Secret Life of Arabia) | Richard Foote
- Indexing and Transparent Data Encryption Part II (Hide Away) | Richard Foote
- Indexing and Transparent Data Encryption Part III (You Cant Do That) | Richard Foote