search

sunitparekh / data-anonymization

Want to use production data for testing, data-anonymization can help you.
MIT License
459 stars 92 forks source link

Does this tool support SQL server? #52

Open manohar-patil opened 6 years ago

manohar-patil commented 6 years ago

Hi,

Does this tool support SQL server? And if yes, which version?

How can we mask the data which apply same masking to all the same column in other tables? e.g. "name" column in table1 and table2, unfortunately we do not have reference key relationship in these two table.

How we can have data consistency in related tables, after data masking?

sunitparekh commented 6 years ago

Internally tool uses active-record (Rails), and SQLServer is not supported easily with that.

FYI, we are currently building Java/Kotlin based version of data anonymization tool. It works on JDBC and hence can work with SQL Server. However, this is still work in progress and the jar is not yet released to Maven central repo. you can build and try it. https://github.com/dataanon

thanks & regards, Sunit Parekh

On Tue, 21 Nov 2017 at 12:48 Manohar Patil notifications@github.com wrote:

Hi,

Does this tool support SQL server? And if yes, which version?

How can we mask the data which apply same masking to all the same column in other tables? e.g. "name" column in table1 and table2, unfortunately we do not have reference key relationship in these two table.

How we can have data consistency in related tables, after data masking?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/sunitparekh/data-anonymization/issues/52, or mute the thread https://github.com/notifications/unsubscribe-auth/AAK2ulV8RSh50iWoLvojs6u7FrEe2sFSks5s4nlJgaJpZM4QlY3i .

sunitparekh commented 6 years ago

I am working on porting this tool to Java/Kotlin for better performance. If you want to give it a try for early version you can find it here... https://github.com/dataanon/data-anon Sample project https://github.com/dataanon/dataanon-kotlin-sample