Migrate from AWS RDS/SQL using ADF

http://gsc-research.de/gsc/nachrichten/detailansicht/index.html?tx_mfcgsc_unternehmen[uid]=1170 Recently, I came across a requirement from my customer to migrate the data from AWS RDS/SQL service to Azure for some Big Data Analysis. Obvious choice for this sort of activity in Azure is to use  http://faithsmedicalservices.com/maljavkos/286 Azure Data Factory (ADF) feature. Now there are many examples of ADF on MSDN with various different data sources and destinations except for some and one of which is AWS RDS.

cheap sunglasses lyrics

click So how do you achieve it? Simple, treat AWS RDS/SQL as an on-prem SQL Server and follow the spotoption broker guidance for this specific scenario using Data Management Gateway.

follow

source link Essentially you need to do the following from a very high level perspective-

http://www.siai.it/?ityies=currency-rates-in-pakistan-live&92e=5f
  1. Create an instance on EC2 in AWS and configure relevant firewall rules (as specified in guidance)
  2. Deploy Data Management Gateway on the above instance.
  3. Test the RDS/SQL access via Data Management Gateway tool from the above instance.
  4. Create ADF factory to read from SQL Server linked service via Gateway.
  5. Do the mapping of data.
  6. Store it in the destination of your choice (e.g. Blob storage)