updating sqlserver table via oracle trigger
We have an Oracle 9i database, with a table that get's populated with a new record every minute or so.
We need to take some values from the newly inserted record and populate a table in a sql server database instantly. The people requesting this have not said as much, but I am thinking deletes and updates would need to be treated the same.
How would it be best to do this? My first thought was a trigger on the oracle table that populates the sql server table via heterogeneous db link. Then someone mentioned transparent gateway, which is something I have not worked with yet.
Any other ideas?
thanks in advance..