I have a unique situation where my source system is Oracle, the Oracle DBAs (ODBAs) are using Golden Gate to push data to a replica that is also Oracle. The SQL Server (SDBAs) want to ingest the data from the Oracle Replica, and if we could get transactional replication to work, that would just be fantastic. I have read through some MS KBs that it is possible to have an Oracle source as the replication publisher. I wonder though if this would work knowing the Publication source is a golden gate replica.
I know with some Change Data Capture (CDC) tools, they actually use the replication engine of the source and target system. So enabling SQL Server replication on top of that does not always work as advertised.
The trick here is we are trying to not pay for another set of GG licenses if possible.
Are there any experts out there who have done this in the past?