Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Google Analytics API, Kettle question

  1. #1
    Join Date
    Jan 2014

    Default Google Analytics API, Kettle question

    Does anybody have experience getting Google Analytics Data API using Kettle? I downloaded the latest version of Kettle/Spoon and trying to figure out what API key needs to be used. I've gone through the Google Developer Console and activated the Analytics API but I'm not sure which credentials to use - OAuth or the Public Access API Access? I've checked the Pentaho wiki but it seems like it might be outdated. Will the OAuth credentials give me am API key that I can fill into the Spoon Google Analytics Input (see attached)? FYI I'm fairly new to ETL and using API's, any help would be appreciated!


    Name:  Screen Shot 2014-02-04 at 3.57.05 PM.jpg
Views: 64
Size:  30.6 KB

  2. #2
    Join Date
    Dec 2012


    As long as you could generate an API key via the Google developers console, you should be able to use it with your personal credentials (if you have been added to the authorization list for that API). I don't believe the OAuth settings impact this module directly. I did just try to determine my OAuth switch settings, but Google's Analytics API console is clocking and not delivering the screen.

    Although, if you have a proxy in your network, you have other issues that are difficult to resolve with this module. Thus far I've been unsuccessful getting through that proxy with any adjustments to env variables at the OS, java-console, or Spoon.bat level. The same credentials work on another instance (AWS based) that doesn't have a proxy.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.