Set up a [database link between Oracle and SQL server][1], then set up a trigger in the Oracle database to update the SQL Server table whenever the oracle table changes.


  [1]: https://stackoverflow.com/questions/6112848/connecting-oracle-to-sql-server-via-database-link