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!
Hi,
Is this answer still valid? Not supported encrypted database?
Thanks!
Alicia
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.
Regards
Suman
Hello Suman,
can we have a use case for this and share Alicia if possible . How to implement this ?
Hi Sudheer,
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.
Regards
Suman PramanikHi Suman,
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,
Alicia
Hi Alicia,
Please touch base off line via email to discuss further.
Regards
Suman Pramanik
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