Tag Info

New answers tagged

0

I have several easy to apply advises, drawn from my own personal experiences when "pulling" data from a transactional Oracle database into a "staging" database (under Microsoft SQL Server 2012 / 2014): In the SSIS packages do strive to use Oracle's own OLE DB Provider. Likewise, use Microsoft's latest OLE DB Provider for the ADO Destination. REDUCE (yes, ...


2

For advertising purposes, you could use the term "Business data enhancement engineering"? :-) Personally, I would call what you do "[complex] [business] data processing". Thanks. Any suggestion on what terms I should be googling for if I want to find new tools for our processes? Just various combinations of what you already do - etl/data ...


0

You can synchronize Oracle and SQL Server in many ways. For example: You can use sql server transactional replication with Oracle as a publisher: https://msdn.microsoft.com/en-us/library/ms152481.aspx You can use Oracle GOldengate (very expensive): http://www.oracle.com/technetwork/articles/datawarehouse/oracle-sqlserver-goldengate-460262.html regards ...



Top 50 recent answers are included