Connecting to Google Analytics(GA4) from azure synapse

Question

Connecting to Google Analytics(GA4) from azure synapse

deepthi bhupathiraju 1

Currently we are doing ETL from GA using a third party Integration tool which we need to migrate and import data from azure synapse.

Is there a way to connect to GA or GA4 from azure synapse and if , what and how authentication is needs to be setup.

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-09-15T08:20:14.38+00:00
Hello @deepthi bhupathiraju ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

1 answer

Your answer

PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-09-15T08:20:14.38+00:00

Hello @deepthi bhupathiraju ,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you.

Answer 1

PRADEEPCHEEKATLA 90,651 Moderator

Hello @deepthi bhupathiraju ,

Thanks for the question and using MS Q&A platform.

Unfortuantely, there is no connector available to connect Google Analytics from Azure Synapse Analytics.

Appreciate if you could share the feedback on our feedback channel. Which would be open for the user community to upvote & comment on. This allows our product teams to effectively prioritize your request against our existing feature backlog and gives insight into the potential impact of implementing the suggested feature.

Yes, you need to depend on the third party integration tool to connect: Google Analytics Data Replication to Azure Synapse Analytics.

Hope this will help. Please let us know if any further queries.

------------------------------

Please don't forget to click on or upvote button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
Want a reminder to come back and check responses? Here is how to subscribe to a notification
If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators

deepthi bhupathiraju 1 Reputation point

2022-09-09T12:59:59.36+00:00

Hi @PRADEEPCHEEKATLA

Thank you for the above information.
Is there a way if we can use web API connector(rest API) and connect to Google analytics?
The current set up we have is , within our GA platform we are having different domains as properties from which different dimensions and metrics needs to extracted and pushed onto a on prem SQL server.

Each property within it is again separate www.*****.**.com URLS which are now getting migrated to new GA4 platform as well.
PRADEEPCHEEKATLA 90,651 Reputation points Moderator

2022-09-13T05:05:11.743+00:00

Hello @deepthi bhupathiraju ,

If you would like to interact with Google analytics from Azure data factory, then you should consider making REST call to it using REST connector dataset.

For more details, refer to Google Analtics Azure Data Factory REST API.

Share via

Connecting to Google Analytics(GA4) from azure synapse

1 answer

Your answer