Hi Experts,
I want to add an extract from Oracle DB using OGG for Oracle and send the changes to a SQL DB using OGG for SQL. Based on what I've read so far the format is something like:
EXTRACT ORAINIT
USERIDALIAS SourceCDB DOMAIN OracleGoldenGate
RMTHOST localhost, MGRPORT 9014
RMTTASK REPLICAT, GROUP ORATEST
Table PDB.SCHEMA.*;
Both Oracle and SQL OGG containers are running on same machine. But I'm not sure what port is being used and how to configure or expose it. Both instances are using same service ports internally. I've only changed the http/s ports to login separately to the console and that works fine.
Has anyone had a usecase like this?