Clarity

Expand all | Collapse all

Database Encryption

CMCN1982

CMCN1982Sep 22, 2015 04:27 AM

  • 1.  Database Encryption

    Posted Sep 21, 2015 11:24 AM

    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.



  • 2.  Re: Database Encryption
    Best Answer

    Broadcom Employee
    Posted Sep 22, 2015 03:20 AM

    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



  • 3.  Re: Database Encryption

    Posted Sep 22, 2015 04:27 AM

    Thank you Suman - very helpful as always!



  • 4.  Re: Database Encryption

    Posted Nov 21, 2018 03:35 PM

    Hi,  

     

      Is this answer still valid? Not supported encrypted database?

    Thanks!

    Alicia



  • 5.  Re: Database Encryption

    Broadcom Employee
    Posted Nov 21, 2018 11:32 PM

    Yes ,i think.



  • 6.  Re: Database Encryption

    Broadcom Employee
    Posted Nov 21, 2018 11:43 PM

    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



  • 7.  Re: Database Encryption

    Broadcom Employee
    Posted Nov 21, 2018 11:47 PM

    Hello Suman, 

     

    can we have a use case for this and share Alicia if possible .  How to implement this ?  



  • 8.  Re: Database Encryption

    Broadcom Employee
    Posted Nov 22, 2018 02:10 AM

    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 Pramanik 



  • 9.  Re: Database Encryption

    Posted Nov 23, 2018 05:22 AM

    Hi 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



  • 10.  Re: Database Encryption

    Broadcom Employee
    Posted Nov 23, 2018 05:26 AM

    Hi Alicia,

     

    Please touch base off line via email to discuss further. 

     

    Regards

    Suman Pramanik 



  • 11.  RE: Re: Database Encryption

    Posted Nov 29, 2019 08:43 AM
    Hi Suman.
    Is database encryption definitevely supported ?
    Customer has clarity version15.6, he already encrypted database and changed jdbc url adding the following: EncryptionLevel=accepted;DataIntegrityLevel=accepted

    Thanks
    Stefano


  • 12.  RE: Re: Database Encryption

    Broadcom Employee
    Posted Nov 29, 2019 08:45 AM
    Hi Stefano

    Yes we have multiple customers using it. What is the problem being faced?

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------



  • 13.  RE: Re: Database Encryption

    Posted Nov 29, 2019 09:40 AM
    Thanks Suman. No problems until now , just searching for a confirmation.
    I've just also found confirm also in release notes.

    Regards
    Stefano


  • 14.  RE: Re: Database Encryption

    Broadcom Employee
    Posted Nov 29, 2019 10:00 AM
    Thanks Stephano

    ------------------------------
    Thanks & Regards
    Suman Pramanik
    Sr. Principal Support Engineer | Customer Success & Support, Enterprise Software Division
    Broadcom
    ------------------------------