By using AWS re:Post, you agree to the Terms of Use

ETL Replication from Oracle to Postgres

0

I need to replicate data from Oracle database(views) to Postgres . please let me know the best to do it.I believe AWS Glue can help in replicating ETL data, If you have any documents(step by step instructions) please share with me. If you have any other tool Please share the details.

2 Answers
1

Hello,

Adding to the above point, SCT can help to move from Oracle to Glue - [] Converting extract, transform, and load (ETL) processes with AWS Schema Conversion Tool - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP-converting-etl.html

Adding that to the "data" movement via SCT + DMS (as mentioned in prev response)& connecting to RDS can help - [] AWS Glue connection properties - AWS Glue JDBC connection properties - https://docs.aws.amazon.com/glue/latest/dg/connection-defining.html#connection-properties-jdbc

More details should-be discussed with your Solutions Architect Team - Hope the links above help in the general idea of the architecture

answered a month ago
0

Hello,

Thanks for posting on AWS re:Post.

I think the doc below will give a high level overview of the process of migration-> https://aws.amazon.com/blogs/database/how-to-migrate-your-oracle-database-to-postgresql/

Ideally - AWS SCT-> [] What is the AWS Schema Conversion Tool? - https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Welcome.html

Couple with DMS will help->

Oracle as source [] Using an Oracle database as a source for AWS DMS - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html

Postgres as target [] Using a PostgreSQL database as a target for AWS Database Migration Service - https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.PostgreSQL.html

I sincerely hope I was able to shed some light on the matter for you - Have a great rest of the day!

answered a month ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions