How to decode data from the database that is Base64 encoded

Question

Hello,

I need to load tables from AWS RDS for MySQL into Azure SQL Database. I use MySQL connector for creating a Linked Service.
When I loaded data from the database I noticed that data was Base64 encoded, values of JSON objects are encoded and values within this JSON are also encoded.
Can this be decoded somehow adding parameters into Linked Service?

Thanks

Answer 1

Hi Maryna Paluyanava,

Thank you for posting query in Microsoft Q&A Platform

If I understand correctly, you are using ADF to load data from your source to sink and your data is encrypted, and you want to decrypt it while loading data. Please correct me if I am wrong.

Azure Data factory don't have any support of encryption and decryption in built. So, you need consider writing your own code in Azure functions or batch services and run them to perform your encryption and decryptions.

Please check below links to understand about Azure functions and batch services.

https://learn.microsoft.com/en-us/azure/azure-functions/functions-overview

https://learn.microsoft.com/en-us/azure/batch/batch-technical-overview

You can consider using Azure function activity or custom activity in Azure data factory to run the same as part of your pipeline.

Hope this helps.

---

Please consider hitting Accept Answer button. Accepted answers help community as well.