oracle-databasepostgresqldatabase-replicationtransactional-replication

Data replication between Oracle and Postgres


Is there a way to replicate data(like triggers or jobs) from oracle tables to postgres tables and vice versa(for different set of tables) without using external tools? Just one way replication for both the scenarios.


Solution

  • Just a hint:

    You can think of create a DB link from Oracle to Postgres which is called heterogeneous connectivity which makes it possible to select data from Postgres with a select statement in Oracle.

    Then use materialized views to schedule and store the results of those selects.

    As you don't want to use any external tool otherwise the solution should have been much simpler