Talend Exchange is the place where Talend community can share items related to Talend opensource products, such as Data Integration, Data Quality and Data Master Management. Contribution is open to any user, no specific validation is needed. As soon as you have your forum account, you automatically get a Talend Exchange account.

Unknown extension

  • Author:
  • Categories:
  • First revision date: no revision yet
  • Latest revision date: no revision yet
  • Compatible with: Data Integration releases
  • Downloads: 0


Related links

Revision list

expand/collapse all

No revision available for this extension.

Reviews (14)

 Able to fetch 20000 rows only By sudharshan.c on June 9, 2014
Hi ,
I am able to fetch only 200000 rows of data n total for a data load(i am not telling about the fetch size for each internal iteration), when i use this component to pull data from Google Analytics. Please let me know if this data fetch restriction is at the google analytics level or at the component level.

Thank You
Google tells you absolute clear whats wrong with your request and you ask here via a rating function?
 Metrics Limitation By grossetti79 on May 12, 2014
Can someone confirm if there is a max number of Metrics to define? Is there a way to bypass it?

I'm currently having this issue

Exception in component tGoogleAnalyticsInput_1
com.google.api.client.googleapis.json.GoogleJsonResponseException: 400 Bad Request
"code" : 400,
"errors" : [ {
"domain" : "global",
"message" : "Requested 11 metrics; only 10 are allowed.",
"reason" : "badRequest"
} ],
"message" : "Requested 11 metrics; only 10 are allowed."
at com.google.api.client.googleapis.json.GoogleJsonResponseException.from(GoogleJsonResponseException.java:145)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:113)
at com.google.api.client.googleapis.services.json.AbstractGoogleJsonClientRequest.newExceptionOnError(AbstractGoogleJsonClientRequest.java:40)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest$1.interceptResponse(AbstractGoogleClientRequest.java:312)
at com.google.api.client.http.HttpRequest.execute(HttpRequest.java:1049)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:410)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.executeUnparsed(AbstractGoogleClientRequest.java:343)
at com.google.api.client.googleapis.services.AbstractGoogleClientRequest.execute(AbstractGoogleClientRequest.java:460)
at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeDataQuery(GoogleAnalyticsInput.java:248)
at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeQuery(GoogleAnalyticsInput.java:291)
at bi.googleanalyticsexport_0_1.GoogleAnalyticsExport.tGoogleAnalyticsInput_1Process(GoogleAnalyticsExport.java:1500)
at bi.googleanalyticsexport_0_1.GoogleAnalyticsExport.tOracleInput_1Process(GoogleAnalyticsExport.java:3163)
at bi.googleanalyticsexport_0_1.GoogleAnalyticsExport.tOracleConnection_1Process(GoogleAnalyticsExport.java:2558)
at bi.googleanalyticsexport_0_1.GoogleAnalyticsExport.runJobInTOS(GoogleAnalyticsExport.java:3435)
at bi.googleanalyticsexport_0_1.GoogleAnalyticsExport.main(GoogleAnalyticsExport.java:3262)
 userful By lqian on April 23, 2014
good thing to review.
 Great Component By amenezes on April 14, 2014
Fantastic work!
 Auth problem By MedAchraf on March 5, 2014
when trying to connect I get this error:

Exception in component tGoogleAnalyticsInput_1
com.google.gdata.util.AuthenticationException: Error connecting with login URI
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:489)
at com.google.gdata.client.GoogleAuthTokenFactory.setUserCredentials(GoogleAuthTokenFactory.java:346)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:362)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:317)
at com.google.gdata.client.GoogleService.setUserCredentials(GoogleService.java:301)
at googleanalyticstes.googletest_0_1.googleTest.tGoogleAnalyticsInput_1Process(googleTest.java:574)
at googleanalyticstes.googletest_0_1.googleTest.runJobInTOS(googleTest.java:1089)
at googleanalyticstes.googletest_0_1.googleTest.main(googleTest.java:947)
Caused by: java.net.ConnectException: Connection timed out: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at com.sun.net.ssl.internal.ssl.SSLSocketImpl.connect(Unknown Source)
at com.sun.net.ssl.internal.ssl.BaseSSLSocketImpl.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.http.HttpClient.openServer(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.(Unknown Source)
at sun.net.www.protocol.https.HttpsClient.New(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.getNewHttpClient(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net.www.protocol.https.AbstractDelegateHttpsURLConnection.connect(Unknown Source)
at sun.net.www.protocol.http.HttpURLConnection.getOutputStream(Unknown Source)
at sun.net.www.protocol.https.HttpsURLConnectionImpl.getOutputStream(Unknown Source)
at com.google.gdata.client.GoogleAuthTokenFactory.makePostRequest(GoogleAuthTokenFactory.java:551)
at com.google.gdata.client.GoogleAuthTokenFactory.getAuthToken(GoogleAuthTokenFactory.java:487)
... 7 more

I think this may be related to the advanced setting parameters

Can anyone tell me that what am i missing? Thanks.


 dependency still not found By mlindman on March 6, 2013
I tried the steps for problemsolving, but I'm still getting the error "Module cimt.talendcomp.gaanalytics-1.5.0-jar-with-dependencies.jar required"

Is there something that would prevent this module from working on Enterprise version (with svn)?

Are there any steps I could take to fix this manually?
 Directeur Informatique By Pierret on February 13, 2013
One functionality missing.

This is a great component and it works fine but Iit's not possible to limit the results. I don't want to store all the results in my database. Is it possible to add a parameter to set max-results?

 Can't make it work with Talend 5.1.1 By atienza on February 13, 2013
I just downloaded the last version but when trying to launch the job, I get errors (in the code windows) indicating this :
"de. cannot be resolved"
Did I miss anything in the installation process ?
 Great component By BZIKHA Rabi on January 15, 2013
I already use this component.It's very good and it is important in Datamanagement.

 Great Tool By ketan_dangi on September 21, 2012
Other then initial installation problem its really great tool.
 Jar not found Issue By ketan_dangi on September 11, 2012
After downloading above latest version and two steps still getting "...1.4-dependency.jar not found".

After fresh install its works fine. By ketan_dangi on September 21, 2012
After installing again above error no longer exist. now I can say this is really great tool
 Great component! By mkeyes on July 18, 2012
Works like a charm, and since it uses OAuth it is about as future proof as you can get. Two suggestions from the author to get it to work right out of the box:

1) After you create your service account key in the Google API Console add your service account email as a user of the GA profiles you're using.
2) Delete the ComponentCache.javacache in the configuration subdirectory and restart Studio to get rid of the "jar not found" error after install.

After I did these two steps it worked perfectly.

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:340) 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:857) at com.google.api.client.googleapis.json.GoogleJsonResponseException.execute(GoogleJsonResponseException.java:182) at com.google.api.client.googleapis.services.GoogleClient.executeUnparsed(GoogleClient.java:279) at com.google.api.client.http.json.JsonHttpRequest.executeUnparsed(JsonHttpRequest.java:207) at com.google.api.services.analytics.Analytics$Data$Ga$Get.execute(Analytics.java:1622) at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeDataQuery(GoogleAnalyticsInput.java:260) at de.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput.executeQuery(GoogleAnalyticsInput.java:303) at dheeraj.gtest_0_1.gtest.tGoogleAnalyticsInput_1Process(gtest.java:493) at dheeraj.gtest_0_1.gtest.runJobInTOS(gtest.java:822) at dheeraj.gtest_0_1.gtest.main(gtest.java:690) [statistics] disconnected
Submit review
Please select your rating*

Version Author Released on Rating Downloads

Training export

0.1 cathyc 2014-06-10

Training export


Minutes Seconds

2.1 mhallam 2014-05-26

validates minutes:seconds format

Validates 3:56, 59:59,...
Does not validate 60:59 or 59:60.


hotmail email

2.0 scorreia 2014-05-26

filters email from hotmail.com


Dutch Postal Code

2.0 fcweeber 2014-05-26

Postal Code format verfication (Netherlands)

9999AA|9999 AA
Non Matches
9999aa|9999Aa|9999 aa|9999 aA


Dutch Phone Number

2.0 fcweeber 2014-05-26

Phone Number format verfication (Netherlands)

Local: Dutch Phonenumber format is area code (3 or 4 digits), phone number ( 7 or 6 digits) - total length (10 digits)
International: country code 0031 and then remove zero from area code
Non Matches
012 1234567|1234567
match or 004923123467223


Names with unicode characters

2.0 scorreia 2014-05-26

Match people names with unicode characters.
Matches Jean-Marc, Jørn, Mc\'Neelan, Pz. López
Does not match I.B.M.


FR Phone Number (parenthesis allowed)

2.0 scorreia 2014-05-26

match French phone numbers in several format:
0033 1 47 25 00 00
+33 1 47 25 00 00
(33) 1 47 25 00 00
01 47 25 00 00
Does not match
0147 250 000


Email Address (with list of top-level domains)

2.0 mzhao 2014-05-26

Check the validity of email addresses.


Regular Text

2.0 scorreia 2014-05-26

match regular text

matches regular text such as \"hello Jean-Baptiste\".
does not match text with any special character such as \"# num\", \"test;\"



2.0 scorreia 2014-05-26

match regular text with punctuation correctly placed.

Version Author Released on Rating Downloads

Product Demo

3.0 ctoum 2012-05-31

Product & families, with Cafepress pictures.


Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22

This is a model of the basic of the Janus Clinical Data Repository.


D* Demo Model

1.0 ctoum 2010-08-13

Model used in the D* Demo.


Talendshop Demo

1.0 ctoum 2010-08-04

Talendshop Demo (Demo Project)

55 ms