Arbitrary JDBC connect string / jar file support

arx-deidentifier / arx

ARX is a comprehensive open source data anonymization tool aiming to provide scalability and usability. It supports various anonymization techniques, methods for analyzing data quality and re-identification risks and it supports well-known privacy models, such as k-anonymity, l-diversity, t-closeness and differential privacy.

http://arx.deidentifier.org/

Apache License 2.0

623 stars 216 forks source link

Arbitrary JDBC connect string / jar file support #274

Open tom-dyar opened 5 years ago

tom-dyar commented 5 years ago

I would like to be able to connect to more databases, such as snowflake, but ARX GUI (and the library?) only supports certain databases.

It would be great to be able to specify an arbitrary JDBC connection string, and be able to point ARX to a jar file that supports that connection string.

prasser commented 5 years ago

Thanks for your interest in ARX! This limitation does not exist in the ARX library, it only affects the GUI. It would be relatively easy to implement a method for dynamically loading the JDBC driver through the GUI. I won't have the time to do this, however, in the foreseeable future. Maybe you could try to enhance ARX in this regard?

tom-dyar commented 5 years ago

Thanks, Dr. Prasser,

So I guess this would entail:

adding a new drop-down option
Implement a dialog to configure for JDBC, that would include:
select .jar file, and then code would enumerate the driver classes in the jar
select driver class

Then this information needs to be used to instantiate the data source object, perhaps after a "classforname" call?

I also don't have time to implement this right now, but it is good to scope out the work in case someone else would like this feature.

prasser commented 5 years ago

Thomas, thanks for your effort! The outline of the changes sounds reasonable. Maybe this gets picked up by someone willing and able to contribute.