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?
LVL 1
sqlagent007Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Doug WaltonDatabase AdministratorCommented:
Check out the Database Migration Service (DMS) from AWS: https://aws.amazon.com/dms/

I haven't used it for Oracle to SQL Server, but I'm currently using it to replicate Oracle to PostgreSQL.  You'll have to pay per hour for the replication instance itself, but it's pretty cheap especially compared to Golden Gate.  I've been pretty happy with it so far, and the newest version fixed all the issues I was originally having.

The databases don't need to be in the AWS cloud for it to work, but the replication instance will need to be able to reach them so you'd probably need a vpn connection setup.

Here's some basic setup info: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_SettingUp.html
Here's some documentation on using Oracle as the source database: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.Oracle.html
Here's some documentation on using SQL Server as the target database: https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.SQLServer.html
1
sqlagent007Author Commented:
Thanks Doug. Unfortunately, getting the change approved to use AWS will be more work that trying to get SQL server to work. I think we will try to use SQL Server replication first, then if that does not work, maybe we can explore the AWS thing.

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!
1
slightwv (䄆 Netminder) Commented:
I'm not an Expert with Goldengate but used a predecessor, Oracle Streams Replication for MANY years.  Isn't the replica database a live and open Oracle database?  If so, an Oracle database is an Oracle database is an Oracle database.

If it has all the data you need then there shouldn't be any issues using it as a source.
1

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
johnsoneSenior Oracle DBACommented:
I'm not a GoldenGate person either.  But, I can find documentation like the best of them.

You can get to the documentation here

Specific information for working with SQL Server is here

Based on the documentation is seems like you should be able to do what you are asking.  But, I've never done it.
0
sqlagent007Author Commented:
Thanks experts!!! It's trial by fire = )
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.