GoogleBigQuery as Targer

[sri22]

Hello,

I have installed Qlik replicate server in AWS cloud environment want to replicate oracle source data which resides in Oracle RDS into Google Big Query as Target

How to achieve this?

[Alan_Wang]

Hello @sri22 

Please refer to these user guide links for the setup.

Oracle RDS:

https://help.qlik.com/en-US/replicate/November2022/Content/Global_Common/Content/SharedReplicateHDD/...

Google Big Query Target:

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Google%20Cloud%20BigQuery/...

[Dana_Baldwin]

Hi @sri22 

Please note, on the documentation links Alan shared, you can update the page for the version you are running at the top left of the screen, just in case there are any version specific instructions to take into account.

Thanks,

Dana

[sri22]

What kind of communication should be there  between the firewall from AWS to GCP

[sri22]

How is the connection flowing from AWS to GCP is there a API call or some thing else...

[Alan_Wang · Accepted solution]

Port 443 should be opened for Windows and 3552 for Linux. For a full list of prerequisites, refer to these links.

Windows

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Installation/ReqWinSoftwar...

Linux

https://help.qlik.com/en-US/replicate/November2022/Content/Replicate/Main/Installation/install_proce...