topic How to use tGoogleGeocoder Component in Talend job. in Data Quality

How to use tGoogleGeocoder Component in Talend job.

Anonymous — Thu, 08 May 2014 16:09:11 GMT

Hi,
I am trying to use tGoogleGeocoder Component in my Talend job, but it returns the error:
Exception in component tGoogleGeocoder_1
java.io.IOException: Server returned HTTP response code: 403 for URL: http://maps.google.com/maps/geo?q=799+E+DRAGRAM+SUITE+5A+TUCSON+AZ+85705+USA&output=csv&key=AIzaSyDtYaJ_bUxQ7NdjUjiq4qVO-0wBxLhXwt4
at sun.net. www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1313)
at java.net.URL.openStream(URL.java:1010)
at wycht_wr.sample_0_1.sample.tFixedFlowInput_1Process(sample.java:1053)
at wycht_wr.sample_0_1.sample.runJobInTOS(sample.java:1474)
at wycht_wr.sample_0_1.sample.main(sample.java:1339)
I have attached the screen shot for the same.
Please help me.

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Fri, 09 May 2014 03:44:18 GMT

Hi,

Exception in component tGoogleGeocoder_1
java.io.IOException: Server returned HTTP response code: 403 for URL: http://maps.google.com/maps/geo?q=799+E ? 0wBxLhXwt4

Do you have permission to access the URL or did your certification is authorized by this server?
We would suggest you to connect to the Talend Support portal and log your request, so that we treat it with priority, through the support cycle.
Best regards
Sabrina

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Fri, 09 May 2014 06:27:20 GMT

Hi Sabrina,
I am trying to log in to support portal but it shows the error:
"Login failed! Your user name or password was entered incorrectly."
is there any other registration for that?

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Fri, 09 May 2014 08:11:37 GMT

Hi,
Did you use support account to login to support portal instead of forum account?
If so, please contact to your usual Talend representative to make sure your support account is correct.
Best regards
Sabrina

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Fri, 09 May 2014 08:15:59 GMT

Thanks Sabrina.

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Wed, 28 Oct 2015 20:51:37 GMT

Hi Sabrina,
Do you know if this problem has been resolved? I seem to be getting the same error message (show below). How does one get permission to access the URL? I did obtain a api key from Google and I am using it.

S

Re: How to use tGoogleGeocoder Component in Talend job.

Anonymous — Thu, 29 Oct 2015 03:04:40 GMT

Sabrina.
I got it to work. I downloaded tGoogleGeocoder from GitHub as opposed to using the one I found in Talend Exchange and the one from GitHub worked perfectly. I suspect the one in Talend Exchange may be old. Or I wasn't using it properly!
Here is the Github link I used:
S