March 15, 2009 at 1:09 pm
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
March 16, 2009 at 9:16 am
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.
March 16, 2009 at 9:32 am
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
March 16, 2009 at 9:52 am
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.
March 16, 2009 at 10:07 am
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.
Kind regards,
Gift Peddie
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply