Aws glue jobs and databases

Question

I want to take data and remove the data from the table in SQL database and then insert the data in a new ORACLE database table.Both tables are having same schema.how to do this job with AWS GLUE.

Answer

Do consider other options available to move your data. One tool that would fit this scenario would be [DMS](https://aws.amazon.com/dms/). DMS would provide a GUI for the data movement and would be possibly be cheap.

If you would like to use Glue for the data move, try using Visual job with source as SQL and target as Oracle. I have shown those options below in the Glue Visual editor console:
![Enter image description here](/media/postImages/original/IM_opUpfkoSEaCkq-imSpFIw)

Aws glue jobs and databases

Contenuto pertinente