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

About:

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
@grossetti79
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
Hi,

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

http://www.talendforge.org/forum/viewtopic.php?id=29714

regards,
 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?

Thanks
 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.cimt.talendcomp.googleanalytics.GoogleAnalyticsInput
"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.

Tanks,
 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
Name:*
Email:*
Title:*
Please select your rating*
Review:*


Version Author Released on Rating Downloads
Regex

Training export

0.1 cathyc 2014-06-10
9

Training export

Regex

Minutes Seconds

2.1 mhallam 2014-05-26
144

validates minutes:seconds format

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

SQL

hotmail email

2.0 scorreia 2014-05-26
312

filters email from hotmail.com

Regex

Dutch Postal Code

2.0 fcweeber 2014-05-26
112

Postal Code format verfication (Netherlands)

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

Regex

Dutch Phone Number

2.0 fcweeber 2014-05-26
114

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
Matches
0031121234567|+31123123456|0121234567|012-1234567|0123-123456
Non Matches
012 1234567|1234567
match 02.31.23.45.67.22 or 004923123467223

Regex

Names with unicode characters

2.0 scorreia 2014-05-26
110

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

Regex

FR Phone Number (parenthesis allowed)

2.0 scorreia 2014-05-26
324

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

Regex

Email Address (with list of top-level domains)

2.0 mzhao 2014-05-26
172

Check the validity of email addresses.

Regex

Regular Text

2.0 scorreia 2014-05-26
91

match regular text

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

Regex

Text

2.0 scorreia 2014-05-26
69

match regular text with punctuation correctly placed.

Version Author Released on Rating Downloads
Export

Product Demo

3.0 ctoum 2012-05-31
595

Product & families, with Cafepress pictures.

Data-Model

Clinical Trials: Janus Model Basics

1.0 jaymce 2010-11-22
400

This is a model of the basic of the Janus Clinical Data Repository.
http://www.fda.gov/ForIndustry/DataStandards/StudyDataStandards/ucm155327.htm

Data-Model

D* Demo Model

1.0 ctoum 2010-08-13
737

Model used in the D* Demo.

Export

Talendshop Demo

1.0 ctoum 2010-08-04
1127

Talendshop Demo (Demo Project)


55 ms