topic Re: GoogleBigQuery as Targer in Qlik Replicate

GoogleBigQuery as Targer

sri22 — Thu, 14 Dec 2023 21:42:00 GMT

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?

Re: GoogleBigQuery as Targer

Alan_Wang — Thu, 14 Dec 2023 21:45:06 GMT

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/Oracle/oracle_rds_prerequisites.htm

Google Big Query Target:

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

Re: GoogleBigQuery as Targer

Dana_Baldwin — Thu, 14 Dec 2023 21:50:37 GMT

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

Re: GoogleBigQuery as Targer

sri22 — Fri, 15 Dec 2023 14:22:14 GMT

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

Re: GoogleBigQuery as Targer

sri22 — Fri, 15 Dec 2023 14:23:09 GMT

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

Re: GoogleBigQuery as Targer

Alan_Wang — Fri, 15 Dec 2023 17:31:04 GMT

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/ReqWinSoftware.htm#Windows%20software%20requirements

Linux

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