Suggest an Idea

[yandra_rk]

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).

[Ola_Mayer]

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?

[LoriDobson]

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

[prashant_pandey]

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-Serv...

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 

[srstage80]

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.

[seanhawkes]

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.

[Meghann_MacDonald]

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.