Skip to main content
Announcements
UPGRADE ADVISORY for Qlik Replicate 2024.5: Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Pranita123
Partner - Contributor III
Partner - Contributor III

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