Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, NagaRaju.

Asked: May 31, 2017 - 6:04 pm UTC

Last updated: November 02, 2023 - 5:00 am UTC

Version: 11g

Viewed 1000+ times

You Asked

I am trying to find the solution on sending the Data from Golden Gate Streams to Oracle Advanced Queue.

Please advise what are the steps i need to follow.

and Connor said...

Prior to Oracle GoldenGate 12.3, we were not able to replicate directly into Oracle Advanced Queues (AQ). To do this in earlier release of Oracle GoldenGate, you needed use the GoldenGate JMS Adaptor (which is not part of the Oracle GoldenGate BigData Adapter).

Starting in Oracle GoldenGate 12.3, if you are running on Oracle Database 12.2; you can replicat directly into an AQ using Procedural Replication. Procedural replication is a new functionality in the Oracle GoldenGate 12.3 release.

Here are some handy links for reference:

https://docs.oracle.com/en/database/oracle/oracle-database/19/xstrm/gg_proc_rep.html#GUID-825339D0-89D1-4DC6-A655-10E78CD57C0A

https://forums.oracle.com/ords/apexds/domain/dev-community/category/goldengatenested?tags=goldengate

http://jianmingli.com/wp/?p=1613

Enjoy!!

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

links in this article are no longer available.

robert mackowiak, November 01, 2023 - 4:46 pm UTC

links in this article are no longer available.
Connor McDonald
November 02, 2023 - 5:00 am UTC

Thanks for the report.

Links have been updated.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database