GCP Bigquery Target Enpoint

[Pranita123]

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?

[boaz_newman]

Hello

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

Boaz

[cleese74]

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.

[pedrobergo · Accepted solution]

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/bigqu...

Pedro