Skip to main content
To homepage To homepage
Question

Decryption possibility in TXD on Azure

  • April 3, 2025
  • 1 reply
  • 19 views
X
Contributor

Hello,

 

We have our data warehouse setup on TXD Portal.
Our data source is with provider Azure Data Factory - SQL Server and the data loaded in our Ingest instances is in Azure data lake storage. Then the data is processed in our prepare instances also in Azure SQL database.

The question is now from the data source we have some columns being encrypted via AES_ENCRYPT pySpark function with 16bit key. Is there a possibility to decrypt the data anywhere from our end in ingest instances or prepare instances. For example to add a customized script somewhere (preferably in pySpark as well using AES_DECRYPT function) ? Otherwise, is there encryption method that can be applied from the data source and by that we can decrypt more easily in TXD in SQL Server?

Looking forward to your suggestion/answer. Thank you.

1 reply

rory.smith
TimeXtender Xpert
Forum|alt.badge.img+7
  • rory.smith
  • TimeXtender Xpert
  • 662 replies
  • April 3, 2025

Hi,

most likely the answer is no due to differences in the randomness used in different systems (slight oversimplification here). Normally you would have one layer manage encryption and not split this up. If you are doing the encryption in a very specific way you might get lucky, but that will be very fragile. It is better to have a separate way to ingest sensitive data that allows decryption in the source for restricted logins.

X
1 person likes this
  • X
    Xiaoqing Hu

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings