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

Wajih Arfaoui 60 Reputation points
2024-01-24T19:10:15.78+00:00

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

Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,268 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,112 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,065 questions
{count} votes

Accepted answer
  1. Anand Prakash Yadav 2,975 Reputation points Microsoft Vendor
    2024-01-25T08:33:35.6133333+00:00

    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. 


1 additional answer

Sort by: Most helpful
  1. Silvia Wibowo 2,136 Reputation points Microsoft Employee
    2024-01-25T05:22:30.18+00:00