Integration from oracle to PostgreSQL database

Posted by satish on Nov 01, 2021; 7:30am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Integration-from-oracle-to-PostgreSQL-database-tp10378.html

Dear erman,

We have a requirement to fetch and insert data into oracle database from PostgreSQL database and back update in PostgreSQL.

We created dblink using dg4odbc gateway but it has many limitations where it cannot participate in distributed transactions.

Is there any alternative for this.
Some say to use golden gate but it is highly costly for this specific requirement alone.

We need ur valuable suggestions.

Thanks,
Satish