Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
Hello
Yes, it certainly would, there is a need to fix the service account.
Boaz
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.
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