Hi
I am currently looking for a mechanism to get in the Google analytics data in Dashboard. As the Google analytics data is sitting in the website behind a username authentication, I couldn’t retrieve the data using the “From Web” external data connectivity in the Excel.
I am using Dashboard 4.0 SP6 version. Is there any way or direct connectivity that can be used to get Google analytics in dashboards?
Thanks in Advance
KK123 
(BOB member since 2012-03-25)
We purchased JDBC drivers that connect to Google Analytics and generate content. We connect these to our web service generator to create a SOAP Web service wsdl you can connect to the dashboard.
kmcmanus (BOB member since 2005-09-02)
Hi kmcmanus,
Thanks for the input. As our organisation wanted to use the google analytics data along with other DW metrics, we used the SSIS package to extract the API from google analytics into the SQL server tables. The data is then reported in the dashboard connecting to the universe developed on those SQL tables.
Thanks again for your time and suggestion.
KK123 (BOB member since 2012-03-25)