ETL Replication from Oracle to Postgres

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

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!