https://community.qlik.com/t5/Qlik-Compose/Integration-Always-Encrypted-and-QlikSense/m-p/1837597#M1702 <P><FONT><FONT>Good day!</FONT></FONT></P><P><FONT><FONT>How can I load tables с Always Encrypted из MS SQL в QlikSense? </FONT><FONT>At this moment I have this error:</FONT></FONT></P><P><SPAN>Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Operand type clash: nvarchar(max) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'db_name') is incompatible with nvarchar</SPAN></P> Thu, 20 Mar 2025 15:56:15 GMT Roman3 2025-03-20T15:56:15Z https://community.qlik.com/t5/Qlik-Compose/Integration-Always-Encrypted-and-QlikSense/m-p/1837597#M1702 <P><FONT><FONT>Good day!</FONT></FONT></P><P><FONT><FONT>How can I load tables с Always Encrypted из MS SQL в QlikSense? </FONT><FONT>At this moment I have this error:</FONT></FONT></P><P><SPAN>Connector reply error: ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: Operand type clash: nvarchar(max) encrypted with (encryption_type = 'DETERMINISTIC', encryption_algorithm_name = 'AEAD_AES_256_CBC_HMAC_SHA_256', column_encryption_key_name = 'CEK_Auto1', column_encryption_key_database_name = 'db_name') is incompatible with nvarchar</SPAN></P> Thu, 20 Mar 2025 15:56:15 GMT https://community.qlik.com/t5/Qlik-Compose/Integration-Always-Encrypted-and-QlikSense/m-p/1837597#M1702 Roman3 2025-03-20T15:56:15Z https://community.qlik.com/t5/Qlik-Compose/Integration-Always-Encrypted-and-QlikSense/m-p/1865835#M1703 <P>Good day Roman,</P> <P>Thank you for this post!</P> <P>In case you haven't found a solution to this problem yet, I would recommend asking this question in the Qlik Sense Data Analytics Community Forum, please:&nbsp;<A href="https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense" target="_blank">https://community.qlik.com/t5/Qlik-Sense/ct-p/qlik-sense</A></P> <P>Thank you!</P> <P>Kind regards,</P> <P>Dimitri</P> Thu, 02 Dec 2021 07:47:40 GMT https://community.qlik.com/t5/Qlik-Compose/Integration-Always-Encrypted-and-QlikSense/m-p/1865835#M1703 Dimitri_Remez 2021-12-02T07:47:40Z