hi ,
We are trying to integrate application written in Oracle with Sql server DB. I came acroos some articles talking about linked server. Linked server is used from Sql server to connect oracle db. Is there a way to have two way communication like read sql server tables data from Oracle database.
ideally i have a trigger written on one of my oracle table om_product , whenever if there a record inserted or updated into it , it should replicate the data in a table residing on sql server.
similarly i want to update data in oracle if there is a insert or update in om_customer table in sql server.