Other: encryption/decryption
Answered1.While doing replication from PostgreSQL to SQL mi server decrypted data is not replicating to always encrypted column from PostgreSQL to SQL mi.
2.From SQL mi to SQL mi also not working as CDC method cannot work on SQL mi as source for always encryption.
Note: -For PII columns always encryption is common in any healthcare domain. and this replication is working using other tools, not with fivetran Please take this as a feature request.
-
Official comment
Hi Anil,
Could you please clarify the use case? What is the encrypted data that you're replicating? Do you expect it be replicated, or want to exclude it? If the former, in which format do you expect it to be replicated?
Any details and specifics on the exact data types you are using, and how they are being converted would be helpful for us to address the request.
Thanks,
Val Kulichenko, Fivetran Product Team
Please sign in to leave a comment.
Comments
1 comment