topic Re: Configure Replicate task with Google Analytics as end point in Qlik Replicate

Configure Replicate task with Google Analytics as end point

GT_SrDBA — Mon, 08 Aug 2022 19:36:27 GMT

Hello,

We are currently using Qlik replicate for SQL Server and AWS end points. We have a BI team that needs Google Analytics data.

My question is what is the best way to set up a Qlik Replicate task with and end point to connect and bring down Google Analytics data?

Do we need to set up BigQuery with a custom query and then connect to that?

I supposed we need to flatten the data first and then bring it into SQL Server?

Just looking for ideas from anyone that has already done this type of project. Thanks.

SwathiPulagam — Mon, 08 Aug 2022 19:46:12 GMT

Google Analytics data is not a supported source endpoint.

Below is the user guide link regarding the supported source endpoints for your reference:

You can try with ODBC endpoint to pull or Replicate the data from Google Analytics data.

Thanks,

Swathi

GT_SrDBA — Mon, 08 Aug 2022 19:50:19 GMT

Ok, the quide references MySQL to Google Cloud connectivity. Which is the same for AWS. We use MySQL to connect to that as well.

That points me in the right direction. I thought we would have to use Google BigQuery.

Thanks.

SwathiPulagam — Mon, 08 Aug 2022 19:55:18 GMT

Thanks, please mark it as an accepted solution based on your findings.

Thanks,
Swathi