idea Re: SQL Server Source - Encrypted data replication to target in Suggest an Idea

SQL Server Source - Encrypted data replication to target

yandra_rk — Mon, 13 Jul 2020 12:41:05 GMT

This idea is to enhance Qlik replication process to support encrypted data.

This limitation is mentioned in the Qlik user guide.

"Column-level encryption is not supported as SQL Server database as source and hence you are not seeing data for encrypted columns"

This is very common use case to keep encrypted data on Source (our case SQL Server), and the same is expected to replicate on target (our case Snowflake).

Re: SQL Server Source - Encrypted data replication to target - Status changed to: Open - Collecting Feedback

Ola_Mayer — Mon, 20 Jul 2020 12:52:53 GMT

Re: SQL Server Source - Encrypted data replication to target

Ola_Mayer — Mon, 27 Jul 2020 12:28:39 GMT

Column level encryption is not supported with TDE, only using always encrypted.

(https://azure.microsoft.com/en-us/blog/transparent-data-encryption-or-always-encrypted/)

Are you asking us to support Always-encrypted?

Re: SQL Server Source - Encrypted data replication to target

LoriDobson — Fri, 15 Jan 2021 14:35:54 GMT

Also need this for Salesforce Shield encryption implementation. Qlik Replicate does not see those columns.

Re: SQL Server Source - Encrypted data replication to target

prashant_pandey — Tue, 02 Mar 2021 23:46:30 GMT

I have a similar request from a POC prospect to support SQL Server homogeneous replication support for tables with 'Always Encrypted' data. Details are on the *internal* ideation site:

https://community.qlik.com/t5/Ideas-Internal-Only/Enhancement-Request-Replicate-Support-for-SQL-Server-Always/idi-p/1787684

At the least, the prospect would like a documented way to handle it. At best, it would be ideal to have a feature to automatically handle it.

@Ola_Mayer @Shelley_Brennan

Re: SQL Server Source - Encrypted data replication to target

srstage80 — Thu, 25 Aug 2022 18:33:24 GMT

We have a use case that is very similar where we'd like to leverage authentication (encryption keys) to write to a SQL Server target that has the encryption features enabled as confidential information is coming from source systems.

Re: SQL Server Source - Encrypted data replication to target

seanhawkes — Wed, 31 Aug 2022 14:14:47 GMT

We also have a requirement to utilize the always encrypted features of sql server on for targets. Given the modern security climate i'm surprised that this isn't a higher priority.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 15:25:12 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: SQL Server Source - Encrypted data replication to target - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 15:25:13 GMT