How to ingest data from Google Analytics to Azure Synapse or Azure Blob

Question

Hello, Is there A solution to retrieve data from my google analytics account into Azure Blob or Azure Synapse ? like a connector in ADF or do I need to an Azure Function ? Thank you

Answer 1

Hi @Wajih Arfaoui ,

Thank you for posting your query here!

Adding on to the previous response, please note that there is no direct connector supported by Azure Data Factory and I would recommend to upvote the below feedback item.

Feedback Forum

Alternative would be to use Azure functions to call Google Analytics APIs and to load into Azure Synapse. Below articles might help as reference for the same.

GA APIs reference

using-google-apis-from-azure-functions

google-analytics-api-on-azure

functions-scenario-database-table-cleanup

Also, if your data size is large, ADF can also be a good option. You can test REST API connector or use BigQuery option if you analytics data is available in BigQuery. ADF is meant for large data pipelines and might be a cheaper option, especially if you have self-hosted runtime available.

https://learn.microsoft.com/en-us/azure/data-factory/connector-rest

https://learn.microsoft.com/en-us/azure/data-factory/connector-google-bigquery

Similar query: https://learn.microsoft.com/en-us/answers/questions/1365368/how-to-pull-all-google-analytics-data-into-azure-b

Please let us know if you have any further queries. I’m happy to assist you further.  

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members. 

Answer 2

Hi @Wajih Arfaoui , please refer to https://learn.microsoft.com/en-us/answers/questions/1365368/how-to-pull-all-google-analytics-data-into-azure-b