Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 62 Insurance
- 536.1K On-Premises Infrastructure
- 138.2K Analytics Software
- 38.6K Application Development Software
- 5.7K Cloud Platform
- 109.4K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.2K Integration
- 41.6K Security Software
Goldengate hub from oracle on prem to Amazon Aurora Postgres
SO from what i understand and maybe I am wrong but if one wants to go from Oracle to AWS Aurora Postgres it requires a GGhub setup. On that hub you would need to install it a couple different ways.
- GG installed on source and on hub install GG for postgres. Then just put a replicat on hub to AWS postgres.
- No GG on either source or target. On the hub you put GG for Oracle and GG for postgres and then build extract in oracle version of GG and replicat on Postgres GG version. Do I understand that correctly? Thanks in advance.
Best Answer
-
Yes you are right.
Extract process is faster enough to capture the transactions. But comparing 1 and 2, we can at least avoid a minimal lag (additional network usage) when extracting remotely when you have GG for Oracle in HUB.
We will need to have a Pump process, when we have the GG in same host in On-Prem. Where in if we have it both Source and Target GG in HUB, you don't need one.
Each one has it's own pros and cons.
Regards,
Veera
Answers
-
Yes you are right.
Extract process is faster enough to capture the transactions. But comparing 1 and 2, we can at least avoid a minimal lag (additional network usage) when extracting remotely when you have GG for Oracle in HUB.
We will need to have a Pump process, when we have the GG in same host in On-Prem. Where in if we have it both Source and Target GG in HUB, you don't need one.
Each one has it's own pros and cons.
Regards,
Veera