I wonder whether some of you have recommendations based on experience of how to move daily data from a on-premise Oracle RDBMS to a GCP service such as BigQuery and Cloud Storage.
In my organization, we are looking for change data capture (CDC), orchestration, scheduling and triggering in order to design and develop a robust process in production. Afterwards, we should proceed to acquire ad-hoc licenses and tools. Since we are just starting in a huge subscription with GCP, we urge in defining these kind of connection component.
We are gauging to use Oracle GoldenGate, but it seems to be quite limited for a end-to-end process.
What may you suggest then? Thanks in advance for sharing your experience.
Alan.