sqlagent007
asked on
Is is possible to configure SQL Server replication from an Oracle source system that is a Golden Gate replica?
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?
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?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks experts!!! It's trial by fire = )
ASKER
I am going to keep this in my back pocket though as this does appear to be a very useful tool.
Thanks for the great feedback!