Hello,
We are exploring options on data encryption for our PeopleSoft Databases. We were looking at Oracle ADS with TDE option. I have few questions before i can take it up with my management
1. What is the database performance impact when we implement this solution
2. Should the DB be in unicode mode or will non-unicode work
3. Is the encryption done only at DB level or what about PeopleSoft Pages. How does that work? Can it block specific fields?
4. We also have few off-shoot MS Access DBs. Once this data is encrypted, and when this data gets pulled into MS Access, what will be the impact. Will it all be encrypted? or will it go in decrypted format.
5. Is there a DEMO site that i can take a look at and understand it better.
Please let us know.