How to get Google analytics data to SQL database without using SSIS 3rd party component

Question

Hi team,

I need to get google analytics data and store into SQL database using API by SSIS. How to do that?

But i don't want to use any 3rd party component.

Please help me out here

Thanks in advance

Regards,

Prathap S

---

Prathap S

Answer 1

Hi Prathap21,

As far as I know, there's no data source connecter in SSIS to extract Google analytics data directly, we can use the 3rd party component(e.g SSIS GoogleAnalyticsSource) to accomplish the requirement.

Besides, in my opinion, you can try to download the Google analytics data then export it to CSV file, then load it to SQL Server database with SSIS. For more information, please refer to: Is there any way to export Google Analytics data into a CSV file?

If you still have any questions, please feel free to ask.

Regards,

Pirlo Zhang 

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 2

Hi Prathap21,

If your issue is solved please mark the appropriate answer as Mark as answer. This will help other members to find a solution if they face the same issue.

Thanks for your understanding and support.

If you still have any questions, please feel free to ask.

Best Regards,
Pirlo Zhang

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail].

Answer 3

Hi Pirlo Zhang,

The solution which was provided was correct thanks for the solution.

Is there any C# code logic to get the google analytics data using REST API in SSIS "Script Component"

Thanks in advance

Regards,

Prathap S

---

Prathap S