Possible and simple solution is to use Oracle Change Data Capture to update tables in SQL Server database. Following blog describes it for SQL Server 2012: http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx. Oracle CDC is available for previous versions of SQL Server from Attunity http://www.attunity.com/products/attunity-cdc-ssis/oracle-cdc-for-ssis.

I am trying to build a database in sql server that replicates exact data present in tables in oracle production database. The database in sql server will be used for reporting and for analysis. I want every new or **updated** data in oracle tables to be present in sql server tables in around 1 hour time span. Does sql server integration services helps on this? is there any tool that does this i.e. it makes sure that data present in oracle table and sql server table is always same( neglecting the 1 hour lag?)......

Possible and simple solution is to use Oracle Change Data Capture to update tables in SQL Server database. Following blog describes it for SQL Server 2012: http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx. Oracle CDC is available for previous versions of SQL Server from Attunity http://www.attunity.com/products/attunity-cdc-ssis/oracle-cdc-for-ssis.