Can we execute sql query in aws DMS

Question

Can we execute sql query inside DMS task so that it just fetches the required data and not the whole db. If its not possible then which aws service is used to fetch query based data from on-prem data source to aws S3.

What is your data source tech? – Kannaiyan Mar 08 '19 at 21:36 — Kannaiyan, Mar 08 '19 at 21:36

score 1 · Answer 1 · answered Mar 22 '19 at 12:02

1

You can use filters and/or exclude fields: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Tasks.CustomizingTasks.TableMapping.html

Contact me if you have problems.

answered Mar 22 '19 at 12:02

César Zea Gómez

198
1
7

score 0 · Answer 2 · answered Mar 26 '19 at 18:41

For alternate solution to DMS, you can use AWS Glue with data retrieved using PYSPARK dataframe from on prem DB to either s3 and AWS RDS. This works very well. The only down side is the cost.

This solution supports both table and SQL as input for data extraction

Can we execute sql query in aws DMS

2 Answers2