Does this tool support SQL server?

[manohar-patil]

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]

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 ***@***.***> 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 <#52>, or mute the thread <https://github.com/notifications/unsubscribe-auth/AAK2ulV8RSh50iWoLvojs6u7FrEe2sFSks5s4nlJgaJpZM4QlY3i> .

[sunitparekh]

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