How to decode data from the database that is Base64 encoded

Maryna Paluyanava 211 Reputation points
2023-02-28T18:50:46.3733333+00:00

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

Azure SQL Database
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,750 questions
0 comments No comments
{count} votes

Accepted answer
  1. ShaikMaheer-MSFT 38,126 Reputation points Microsoft Employee
    2023-03-03T07:11:45.9533333+00:00

    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.

    1 person found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful