SQL Server database mit 'Always encrypted' data

I want to use data from SQL Server database that has encrypted data fields by ‘Always Encrypted’ technology.
For decryption it is a ADO.net connection driver necessary. KNIME must connect the database over this.
Is it possible to configurate the JDBC driver for this connection?
Can please help me someone ??

I’m not sure what you mean with ado.net connection driver. However tt seems that the JDBC driver supports this kind of connection as described here. I would suggest to register the latest version of the JDBC driver as described here as it seems to support more options via parameters. Please notice that you do not need to install the Java Cryptography Extension since it is already part of the JVM that is shipped with KNIME. Once the driver is installed you can add the described parameters via the JDBC Parameters tab.

1 Like

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.