topic Re: adwords in Talend Studio

adwords

Anonymous — Sat, 16 Nov 2024 12:39:06 GMT

Hi guys !
Im looking for integrating google adwords with talend.
Did any of you suceed to configure it ? please share ?
That would help me ALOT !!
Thanks
ALex

Re: adwords

Anonymous — Thu, 29 Sep 2011 13:02:57 GMT

Dear Alex
There is no connector available for integrating google adwords yet.
Best regards
Shong

Re: adwords

Anonymous — Thu, 29 Sep 2011 13:29:56 GMT

Thanks shong,
but is it possible to do it with twebserviceInput maybe ?
If so, does somebody have an example of configuration ?
Thanks

Re: adwords

Anonymous — Wed, 30 Sep 2015 15:07:20 GMT

this sure would be a nice feature to add. Has anyone successfully done it with the available components?

Re: adwords

Anonymous — Tue, 27 Oct 2015 09:57:32 GMT

Hi,
Here is a custom component tGoogleAdWordsReport written by Talend Community user and shared on Talend Exchange.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F963%252Fitems%252F1794
Best regards
Sabrina

Re: adwords

Anonymous — Wed, 21 Sep 2016 10:14:14 GMT

did anyone here able to make tGoogleAdWordsReport worked? I have been trying to use it but to no avail. I keep on getting error no matter how I follow the instructions. I also searched and searched but i can't seem to find anyone able to make this component work. Any help is appreciated.
Starting job adwords_test at 04:11 21/09/2016.
connecting to socket on port 3725
connected
com.google.api.client.auth.oauth2.TokenResponseException: 401 Unauthorized
at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105)
at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:384)
at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
at de.jlo.talendcomp.google.adwords.AdWordsReport.initializeAdWordsSession(AdWordsReport.java:250)
at adw.adwords_test_0_1.adwords_test.tGoogleAdWordsReport_1Process(adwords_test.java:606)
at adw.adwords_test_0_1.adwords_test.runJobInTOS(adwords_test.java:1074)
at adw.adwords_test_0_1.adwords_test.main(adwords_test.java:931)
Exception in component tGoogleAdWordsReport_1
java.lang.NullPointerException
at de.jlo.talendcomp.google.adwords.AdWordsReport.executeQuery(AdWordsReport.java:274)
disconnected
at adw.adwords_test_0_1.adwords_test.tGoogleAdWordsReport_1Process(adwords_test.java:634)
at adw.adwords_test_0_1.adwords_test.runJobInTOS(adwords_test.java:1074)
at adw.adwords_test_0_1.adwords_test.main(adwords_test.java:931)
Job adwords_test ended at 04:11 21/09/2016.

Re: adwords

Anonymous — Tue, 27 Sep 2016 22:07:46 GMT

Hi,
Same problem with TOS DI 6.1.1 and tgoogleAdwordsReport v6. I followed google's instruction and tried to connect with service account authentification :
com.google.api.client.auth.oauth2.TokenResponseException: 401 Unauthorized
    at com.google.api.client.auth.oauth2.TokenResponseException.from(TokenResponseException.java:105)
    at com.google.api.client.auth.oauth2.TokenRequest.executeUnparsed(TokenRequest.java:287)
    at com.google.api.client.auth.oauth2.TokenRequest.execute(TokenRequest.java:307)
    at com.google.api.client.googleapis.auth.oauth2.GoogleCredential.executeRefreshToken(GoogleCredential.java:384)
    at com.google.api.client.auth.oauth2.Credential.refreshToken(Credential.java:489)
    at de.jlo.talendcomp.google.adwords.AdWordsReport.initializeAdWordsSession(AdWordsReport.java:250)
Any help would be appreciated

Re: adwords

Anonymous — Tue, 27 Sep 2016 22:48:49 GMT

You have an issue with OAuth 2.0. This tutorial might help you out....
https://www.rilhia.com/tutorials/using-oauth-20-talend-access-google-apis

Re: adwords

Anonymous — Wed, 19 Sep 2018 11:18:09 GMT

I dont seems to have access to that link says site cant be reached.

is it possible to document that here if you are able to view the resolution