Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 65 Insurance
- 536.7K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
GoldenGate extract from OCI hosted Oracle DB to Azure hosted SQL DB
User_RNDR7
Member Posts: 2 Red Ribbon
in GoldenGate
Hi,
We have aGoldenGate for Oracle DB running on OCI. Looking to use it to extract from OCI hosted Oracle DB and send the trail files to a remote GG for SQL Server running on Azure VM and use GG for SQL Server to replicate to target Azure SQL server.
Do we need to keep GG for SQL server which will need to receive trail files behind a proxy? Are there any detailed instructions available ?
Tagged:
Answers
-
GG doesn't care, your mgr process running on Azure will have a port, say 7809. You just have to make sure firewall rules between OCI and Azure are met. Forget about GG, how you communicate between OCI and Azure is what you need for the extract on OCI to send the trail to the server process on Azure on port 7809.