Clarity PPM1

Expand all | Collapse all

Anonymize/Delete data only older than...?

  • 1.  Anonymize/Delete data only older than...?

    Posted 09-27-2018 08:12 AM

    Hi All,

     

    We'd like to anonymize (or delete) older data (actuals, tasks, assignments) older than 10 years.

     

    I've just got known there is a special functionality for "Anonymization" of resource data  vailable in Clarity 15.4

    https://docops.ca.com/ca-ppm/15-4/en/administration/configure-secure-authentication-user-accounts-and-passwords/gdpr-pro… 

     

    I was not able to find if such a time setting can be used for anonymization... I was not able to find anything relevant for deletion also. Does someone has any experience with such thing?

     

    Thanks,

    Matej



  • 2.  Re: Anonymize/Delete data only older than...?

    Posted 10-09-2018 04:53 AM

    The GDPR job is coming from a resource point of view and mostly just masks PII data.

     

    It only runs on resources flagged and anonymises all their data across the schema but does not delete it. (Very thorough)

    Targeting a date range is a lot more complex, there was a third party "archive" tool which can do this.

     

    Why are you doing this though? 



  • 3.  Re: Anonymize/Delete data only older than...?

    Posted 10-09-2018 02:00 PM

    If you scroll down the docops you get to the list of attributes/fields that can be replaced with an encoded serialized number.

    The related "objects" do not have a date related to those values either.

    See below.
    actuals, tasks, assignments are not among them.

    Out of the box it is also hard to delete those, because of the relations or links in the database between the data.

    CA PPM does not have an archiving or a cleanup utility.

    As Andrew points out there has been at least one third party tool which does the archiving in a controlled manner.

     

    CMN_AUDITS
    • value_before
    • value_after
    • raw_value_before
    • raw_value_after
    CMN_SEC_USERS
    • user_name
    • first_name
    • middle_name
    • last_name
    • email_address
    • sms_email_addresss
    • photo_file
    • full_name
    • bo_user
    • user_uid
    • favorite_photo
    NBI_PROJECT_CURRENT_FACTS
    • ae_last_name
    • ae_first_name
    • manager_last_name
    • manager_first_name
    NBI_RESOURCE_CURRENT_FACTS
    • manager_last_name
    • manager_first_name
    • resource_code
    • last_name
    • first_name
    NBI_RT_FACTS
    • resource_code
    • last_name
    • first_name
    • manager_last_name
    • manager_first_name
    NMC_CONVERSATIONS
    • resource_name
    NMC_INTEGRATIONS
    • user_name
    • proxy_user_name
    ODF_CA_RESOURCE
    • obj_bi_user_id
    PAC_MNT_PROJECTS
    • resource_code
    • approvedby_resource_code
    • awaitapprvl_resource_code
    PAC_MNT_RESOURCES
    • resource_code
    • reportsto_resource_code
    PPA_BILLING
    • resource_code
    • entry_resource_code
    • lastupdtdby_resource_code
    PPA_MATRIXVALUES
    • value1…value10
    PPA_POSTINGBATCH
    • post_resource_code
    PPA_TRANSBILL
    • resource_code
    • entry_resource_code
    • lastupdtdby_resource_code
    PPA_TRANSCONTROL
    • resource_code
    • entry_resource_code
    • lastupdtdby_resource_code
    PPA_TRANSWIPADJUST
    • resource_code
    • entry_resource_code
    • lastupdtdby_resource_code
    PPA_WIP
    • resource_code
    • entry_resource_code
    • lastupdtdby_resource_code
    PROJSTAFF
    • resource_code
    PROJREVISION
    • approvedby_resource_code
    • awaitapprvl_resource_code
    • resource_code
    SRM_CONTACTS
    • job_title
    • address1
    • address2
    • address3
    • city
    • state_province
    • country_id
    • postal_code
    • phone_home
    • phone_work
    • phone_cell
    • phone_fax
    • phone_pager
    • url
    SRM_RESOURCES
    • unique_name
    • first_name
    • middle_name
    • last_name
    • full_name
    • email
    • sms_email


  • 4.  Re: Anonymize/Delete data only older than...?

    Posted 10-10-2018 04:01 AM

    Hi All,

     

    Hmm, I also got known from CA that "CA PPM does not have an archiving or a cleanup utility" as Urmas said.

    However can you please tell me the name of the 3rd party tool?

     

    Thanks



  • 5.  Re: Anonymize/Delete data only older than...?

    Posted 10-10-2018 04:12 AM

    Pemari Archiving for CA PPM (CA Clarity PPM) - 2014-10-02 - YouTube 

    You'd have to check in with them whether it's still being sold, I don't think CA ever certified it.