Move data from Azure Data Lake to AWS RDS through Azure Data Factory

Question

Does Azure Data Factory support moving data out of Azure Data Lake into AWS RDS SQL Server?
If not, what are the alternate options to do so?

Answer 1

Hi @Utsav Chanda ,

Thanks for the ask and using Microsoft Q&A forum.

Currently AWS RDS connector in ADF only support as source but not as sink. I see that there is way to move data form Azure blob to S3 as explained in this article using an open source package - https://aws.amazon.com/blogs/storage/one-way-to-migrate-data-from-azure-blob-storage-to-amazon-s3/ but not from ADLS to AWS RDS.

I would recommend you to please try reaching out in AWS community forum to see if they have any other alternatives.

Ref Doc: Supported data stores

Hope this info helps.

----------

• Please don't forget to click on and upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators