Replicate data from PostgreSQL to Google BigQuery
Before you begin
To successfully complete this quicktart, you must have the following:
- A PostgreSQL installation to serve as the source database (Installation instructions follow in Task 0.)
- Open port 5432 in your VCN's security list.
- Create a connection to Google Cloud
Storage.
Note:
Ensure that the GCS bucket and the BigQuery dataset exist in the same location/region. - Google Cloud Service Account Key.
- Google Cloud Platform BigQuery Permissions.
Task 1: Create the OCI GoldenGate resources
- Create a deployment for the source PostgreSQL database.
- Create a Big Data deployment for the target Google BigQuery.
- Create a connection to the to the target Google BigQuery.
- Create a connection to the source PostgreSQL database.
- For Type, ensure that you select PostgreSQL Server.
- For Database name, enter
ociggll
. - For Host, enter the public IP of the Compute instance that PostgreSQL runs on.
- For Port, enter
5432
. - For Username, enter
ggadmin
. - For Password, enter a password.
- For Security Protocol, select Plain.
- Create a connection to GoldenGate, and then assign this connection to the source PostgreSQL deployment.
- Assign the source connection to the source PostgreSQL deployment..
- Assign the target connection to the target Big Data deployment.
Task 3: Create the Extracts
- Add the Change Data Capture Extract:
- Add the Initial Load Extract:
You return to the Administration Service Overview page, where you can
observe the Extract starting.
Task 4: Create the Distribution Path for Change Data Capture
To create a Distribution Path for Change Data Capture, complete the following:
Create OCI GoldenGate Users and Credentials:
Replicate data from PostgreSQL to Google BigQuery
Copyright ©2023,2024,
Oracle and/or its affiliates.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customer access to and use of Oracle support services will be pursuant to the terms and conditions specified in their Oracle order for the applicable services.