Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pranita123
Partner - Contributor II
Partner - Contributor II

GCP Bigquery Target Enpoint

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?

Labels (1)
1 Solution

Accepted Solutions
pedrobergo
Employee
Employee

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

View solution in original post

3 Replies
boaz_newman
Employee
Employee

Hello

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

Boaz

cleese74
Contributor
Contributor

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
Employee
Employee

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