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:
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
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 customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.