topic Re: GCP Bigquery Target Enpoint in Qlik Replicate

GCP Bigquery Target Enpoint

Pranita123 — Tue, 05 Dec 2023 07:19:07 GMT

If the service account used in the Google SDK and Simba driver for ODBC connectivity, which is configured for the target endpoint (Google BigQuery), undergoes changes or is removed by the service account holder, will it impact the Replicate task from IBM DB2 iSeries to Google BigQuery?

Re: GCP Bigquery Target Enpoint

boaz_newman — Tue, 05 Dec 2023 08:54:05 GMT

Hello

Yes, it certainly would, there is a need to fix the service account.

Boaz

Re: GCP Bigquery Target Enpoint

cleese74 — Tue, 05 Dec 2023 12:09:56 GMT

Export the data to your local, move it up to GCS then ingest into BigQuery. You can automate this by using Dataflow for your pipeline and cloud functions to watch for an event like when the data gets to GCS to trigger the dataflow pipeline.

Re: GCP Bigquery Target Enpoint

pedrobergo — Tue, 05 Dec 2023 12:38:23 GMT

Wow @cleese74 , very complicated flow! Qlik Replicate make it smoothly, just give to connection user the rigth privileges and everything works fine and easy !

@Pranita123 follow instruction on https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Google%20Cloud%20BigQuery/bigquery_prereq_postgresql_target.htm

Pedro