Replication between RDS and on premises Oracle

Question

I am planning to build a standard three tier architecture web portal with an RDS backend. Some of the data needs to be sync'd back to my on-premise Oracle database.

I want updates from either source (the portal or the Oracle database) to sync to the other database in near real time.

I have looked at DMS, Oracle Goldengate and using a Lambda function to trigger an update.

Have you got any guidance on how to approach this problem?

Accepted Answer

If you have a GG license already then that would be the first choice. If not then DMS but DMS does not do two way replication so you will have to address handling replication in both directions. Other native replication options may work like looking at distributed transactions in Oracle.

Another option would be to code the app tier to update both databases.

Replication between RDS and on premises Oracle

Relevant content