Google Analytics Integration into Datawarehouse (OBIEE)

sankb99

Hello,

I am looking for a help on Google Analytics integration into DWH system:

1) how to get Google Analytics (GA) data?

2) Any recommended APIs to get GA data into Oracle tables?

There are 3rd party adapters in Informatica (https://marketplace.informatica.com/solutions/google_analytics_connector_for_powercenter) but I prefer to get data thru any OpenSource APIs.

Appreciate the help.

Thanks,

Santosh

[Deleted User]

ad 1.) I don't think you understand how Google Analytics works...you don't "get Google Analytics data".

ad 2.) see 1.) But generally https://developers.google.com/analytics/

sankb99

Thank you for the quick response.

My requirement is to get GA data (like Users, Sessions, start_timestamp, end_timestamp, etc.)  and integrate it with my other BI system.

Possible?

[Deleted User]

I still don't get what you want to do. Are you talking about using the Google Analytics SDK? Or more precisely from their website:

"Web Tracking (analytics.js)

Measure user interaction with websites or web applications."

rmoff

My requirement is to get GA data (like Users, Sessions, start_timestamp, end_timestamp, etc.)  and integrate it with my other BI system.

Have a look at Usage Tracking (out of the box with OBIEE) and Enhanced Usage Tracking, between them they can provide that information

Gianni Ceresa

@Christian Berg and @rmoff are going in one direction, but maybe you want to go in the other one?

Do you mean that you want to export the data collected and analyzed by Google Analytics about your website(s) and load them into your database to be able to do analysis in OBIEE on it? (so Google Analytics is just one of the sources of your BI platform)

sankb99

Thank you Gianni. I am exactly looking for the same to export collected data from Google Analytics and to load into  my warehouse. Do you have any any more information on achieving  this?

Gianni Ceresa

Ok, at least now it's clear what you try to achieve

Honestly I have no idea but I guess the answer will be found on the google side. Did you try searching on Google for that? You are probably not the only one looking for it, like for example http://stackoverflow.com/questions/26515033/google-analytics-getting-raw-data-logs and more ...

sankb99

Thank you. I would look for it and share more details when it is success.