Does anyone know if the EPIC database encrypt data?
I have asked our lead DBA and he says that there is no encryption done by his team but to check if the data is encrypted through the application.
The data stored in CA PPM are not encrypted except couple of column like password and salt in CMN USER table, rest are in clear text. If you want to enable data encryption then you need to do at the database level and that will have over head on the performance and not fully supported also.
Hope this helps
Thank you Suman - very helpful as always!
Is this answer still valid? Not supported encrypted database?
Yes ,i think.
Database encryption is a feature provided by database and it's completely transparent to apply. You will need to make changes to the JDBC URL in order to make it working.
From my experience it definitely works and I have implemented across few customers however it been tested fully.
can we have a use case for this and share Alicia if possible . How to implement this ?
I would need to understand whats the use case and what kind of encryption you are trying to implement and then provide the solution accordingly.
Thanks so much for the answer. My customer is requesting to encrypt the entire DB and the question is:
- You are asking for type. CAn you please let me know the different types to choose¿
- Are interfaces impacted? We send several messages and also receive many? would that be affected?
- Access to DB by developers to work in the project will also need encryption keys or something like that?
Thanks very much again for your support,
Please touch base off line via email to discuss further.
Retrieving data ...