This technical guide outlines the steps to set up data replication using Google Cloud Datastream. Specifically, it details the process of setting up data replication from an Oracle 19c database hosted on a Google Compute Engine virtual machine into Google BigQuery. The tutorial covers all necessary steps, including prerequisites—enabling APIs and configuring firewalls, setting up the Oracle source environment, establishing secure networking, creating connection profiles for both Oracle and BigQuery in Datastream, preparing the Oracle database for Change Data Capture (CDC), and finally, creating and validating the Datastream replication job.

Prerequisites

Before proceeding, ensure the following Google Cloud APIs are enabled within your project. This is done through the Google Cloud Console under APIs & Services