How to maintain Postgres to Oracle data synchronized?
Currently we are trying to mimic the Oracle to Oracle database link but with Oracle to Postgres. I know that we can add FDW wrappers to connect but the latency is huge.
I have also checked AWS DMS process but it has lot of data type issues when data load and synchronization from Oracle to Postgres happens.
Can someone tell a better way?