Qlik Sense Insert To Microsoft SQL Server database that uses SQL encryption.

[BmRoux]

Hi all,

I want to insert some transformed data to a SQL server table that uses SQL level encryption.

According to SQL all connections must be made with the following setting enabled "Column Encryption Setting=enabled".

The table is encrypted with a key that is stored in the Azure Key Vault.

I get the following error when trying to insert "ERROR [22005] Operand type clash: varchar is incompatible with varchar(25) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name =

How can I make this work in QlikSense?

Thanks 🙂

[mato32188]

Hi @BmRoux ,

perhaps this article could help you

https://www.sqlservercentral.com/blogs/always-encrypted

Using ODBC 13.1 might help.

br

m