Share via

Google Analytics Data Migration to Azure Synapse

Srikanth Kasamolu 51 Reputation points
2020-08-27T04:27:13.567+00:00

What are the possible solution to Migrate data from Google Analytics to Azure Synapse ? I know its possible using Google Analytics API along with Azure Function apps , Is there any doc or resource that I could use as a reference to achieve this just to get started.

Any Help is much appreciated

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
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.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
0 comments
Answer accepted by question author
  1. HarithaMaddi-MSFT 10,151 Reputation points
    2020-08-28T09:57:30.753+00:00

    Hi @Srikanth Kasamolu ,

    Welcome to Microsoft Q&A Platform. Thanks for posting the query.

    There is no direct connector supported from Azure Data Factory today 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. Please let us know for further queries on the same and we would be glad to assist.

    GA APIs reference

    using-google-apis-from-azure-functions

    google-analytics-api-on-azure

    functions-scenario-database-table-cleanup

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Gharat, Pradeep 6 Reputation points
    2020-09-06T20:41:23.087+00:00

    @Srikanth Kasamolu , if you datasize 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 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

    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.