Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Google Analytics Component not working with v5.1.1

I am wondering if anyone has used the GoogleAnalytics component found at http://www.jan-lolling.de/talend/components/help/tGoogleAnalyticsInput.pdf with the latest version of Talend?(v5.1.1)
I try to import the data and it always fails saying that ModuleGoogleAnalytics-1.4.0-jar-with-dependencies.jar required?
Labels (2)
12 Replies
Anonymous
Not applicable
Author

Hi
Are you using Talend Open Studio for data integration or Talend Open Studion for big data. It seems you don't install this component correctly, the required jars are not loaded! I have tested to download this component from Talend Exchange and install it into my studio, it works! How do install this custom component into Talend Studio?
Anonymous
Not applicable
Author

Hi Shong,
I installed the TOS for Data Integration. I downloaded the component, extracted it and then put the tGoogle...folder under the plugins\org.talend.designer.components.localprovider_5.1.1.r84309 folder. I can see that all the jars are present in the folder but still TOS would not recognize it?
Anonymous
Not applicable
Author

I too get the same error on 5.0 as well as 5.1.1
Anonymous
Not applicable
Author

I got it sorted in the end, you need to put an entry for the jar file in the /lib/java/index.xml file
Silly thing to omit from the documentation but then this is open source, you get what you pay for.
Anonymous
Not applicable
Author

Hi
I tested this componenten in exactly this way: loading it from Talend Exchange.
To copy components into the localprovider directory is mostly a bad idea because Talend is managing this and you are unable to get updates from Talend Exchange!
There are a couple of problems with Talend Studio:
If a component carries a jar file this jar file will often not recognized.
My way to fix that is to delete the file ComponentCache.javacache in the subdir configuration.
In fact I do this automatically in the start script of studio (I can do this because under Linux there is a start script)
Best regards
Jan Lolling
_AnonymousUser
Specialist III
Specialist III

Hi,
I successfully use tGoogleAnalyticsInput to pull data from my Google Analytics profile when I run the talend job at home. However, when I try to run the same job in my office (behind a proxy server), I get connection time out error. May I know how to make tGoogleAnalyticsInput component recognize my corporate proxy server? I try to use the tSetProxy component in front of tGoogleAnalyticsInput but this component does not seem to pick up the proxy setting.
Please kindly advise how to resolve such issue. Thanks.
Anonymous
Not applicable
Author

Can i know how to fetch data from Kissmatrics. It is also an Business Analytic site similar to Google Analytics.
Please help if someone knows about it.
Anonymous
Not applicable
Author

Probably Kissmatrix is similar to Goggle but the way to grab the data will be different, also the method to authorize.
I guess there is a web service to fetch the data.
Anonymous
Not applicable
Author

I thinks no body has worked on Kissmatrics, is it? Please provide some help if someone has worked on it.
Meanwhile I have another question about tGoogleAnalyticsInput Component in Talend.
I created one script using tGoogleAnalyticsInput Component but it's giving error--




Exception in component tGoogleAnalyticsInput_1
com.google.api.client.auth.oauth2.TokenResponseException: 400 Bad Request
{
"error" : "invalid_grant"
}
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:103)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:303)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:323)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:320)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:505)
at com.google.api.client.auth.oauth2.Credential.intercept(Credential.java:266)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:859)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:399)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:328)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:449)
at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeDataQuery(GoogleAnalyticsInput.java:260)
at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeQuery(GoogleAnalyticsInput.java:303)
at jasperemail.mygoogleanalyticscontextvariable_0_1.MyGoogleAnalyticsContextVariable.tGoogleAnalyticsInput_1Process(MyGoogleAnalyticsContextVariable.java:784)
at jasperemail.mygoogleanalyticscontextvariable_0_1.MyGoogleAnalyticsContextVariable.runJobInTOS(MyGoogleAnalyticsContextVariable.java:1205)
at jasperemail.mygoogleanalyticscontextvariable_0_1.MyGoogleAnalyticsContextVariable.main(MyGoogleAnalyticsContextVariable.java:1049)

Can anyone tell me why this error is coming, I tried with every option i could but failed.
I am giving proper ProfileId, Service Account Email, Key File and other parameters properly but everytime this error.
If someone has solution for this , please help