I have detailed a scenario below in which we need to access our data in a vendors private cloud. I know sql server replication but am not very familiar with GoldenGate outside of the basic concept.
Scenario: We use a vendors online application. The vendor application is hosted in their own cloud along with all of our data.
We need direct access to our data for warehousing and pumping into downstream systems.
The vendor does not provide direct access to the production database for good reason, but they also do not provide any means for us to access the data. We are proposing a reporting snapshot/replica of the production database.
We use sql server in azure, vendor uses oracle in their own private cloud.
Microsoft SQL Replication is supported only for Oracle up to 10g. So the question is actually: either to use Oracle GoldenGate or downgrade the Oracle database to unsupported version 10g and use unsupported Microsoft SQL Server Publisher.
You might actually ask: to use Oracle GoldenGate or maybe some other software like Dell Shareplex or Attunity. Those products support Oracle as a source database and are fully supported.