The Challenges of Being Safe

  • Gift Peddie

    SSC Guru

    Points: 73570

    Statements like this is the reason we have to start the Personal Data SET algebra required movement so only people who knows SQL and what is needed to resolve very complex issues are the only people who will be approved to handle such data.

    If you believe a program can do this job there is a bridge in Brooklyn with your name on it.

    http://www.compuware.com/products/fileaid/datasolutions.htm

    Kind regards,
    Gift Peddie

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720491

    I think a program could do the job, but not by just installing and click "next". A person that undestands the data and relationships should be able to map fields and specify rules and then have it automated from that point on.

  • Gift Peddie

    SSC Guru

    Points: 73570

    I think a program could do the job, but not by just installing and click "next". A person that undestands the data and relationships should be able to map fields and specify rules and then have it automated from that point on.

    That is ETL which takes skills on both ends of the relational model and sometimes includes expensive tools like Informatica on none SQL Server based database or a team of developers using SSIS. So it is still skills and development required.

    Kind regards,
    Gift Peddie

  • gerry.leith

    SSC Rookie

    Points: 26

    Masking is not an ETL operation, it is an in-situ update process and does not need other relational databases to succeed. The knowledge required is an understanding of the relationships in the entity.

  • Gift Peddie

    SSC Guru

    Points: 73570

    I am not talking about masking which you could also do and currently do in most cases with encryption, I am talking about moving large amount of personal data from different sources and making sure the final data is actually valid. Teen agers should be alive and dead people should remain dead. That is ETL if your employees are not skilled you need Informatica. Informatica in most Enterprise implementation is one million dollars.

    Then making sure that data cannot be moved without escort. And in the VA case only encryption would have made the loss limited not masking.

    it is an in-situ update process and does not need other relational databases to succeed.

    The tool in the link below only support SQL Server some versions and Oracle some version with DB2 edition in development so it is RDBMS versons dependent.

    http://www.datamasker.com/

    Kind regards,
    Gift Peddie

Viewing 5 posts - 16 through 20 (of 20 total)

You must be logged in to reply to this topic. Login to reply