get data from google analytics
Posted: Tue Sep 24, 2013 4:34 am
Hi,
I am trying to get data from GoogleAnalytics with DS 8.7.
Does anyone has experiences in that?
My first idea was to go throw a web service with webservice transform stage.
But GA seems not to provide the data on a webservice.
Next possibility would be to go with odbc stage directly to the MySQL database of GA. But our firewall wouldn't allow this and the firewall and anti virus software would be very difficult to configures. And it is also not clear, wether datastage could connect to ga-database then, or not.
Any better ideas?
Thanks,
Mario
I am trying to get data from GoogleAnalytics with DS 8.7.
Does anyone has experiences in that?
My first idea was to go throw a web service with webservice transform stage.
But GA seems not to provide the data on a webservice.
Next possibility would be to go with odbc stage directly to the MySQL database of GA. But our firewall wouldn't allow this and the firewall and anti virus software would be very difficult to configures. And it is also not clear, wether datastage could connect to ga-database then, or not.
Any better ideas?
Thanks,
Mario