topic Re: source data language translation into English in Talend Studio

source data language translation into English

Anonymous — Sat, 16 Nov 2024 09:01:11 GMT

I have a scenario below and it would be great if anybody share the solution for the same here.

Scenario:

I have a source file having two columns which contain customer name and customer address, this I need to load this into database. But here the twist is, customer address values are in French language. I need to convert the customer address into English language and load into Target.

If anybody knows the solution, please share with me.

Re: source data language translation into English

Anonymous — Fri, 24 Nov 2017 09:28:58 GMT

Hello,

In talend, here is a TalendHelpCenter:tTransliterate component which can convert strings from many languages of the world to a standard set of characters (Universal Coded Character Set, UCS).

Note:translisteration is not the same as translation.

Best regards

Sabrina

Re: source data language translation into English

Anonymous — Fri, 24 Nov 2017 09:40:43 GMT

This seems like an odd request. Why would you translate an address?

For example, a street in Paris called "Rue des Rosiers" would translate to "Street of the Rosiers". This is not the address. The name of a street would not be the "name" to a local or even a tourist. Maybe I am misunderstanding, but it seems like a weird requirement.

However, you could achieve this by using Google Translate (their API would be easy to use) or maybe even their geocoding API, but I strongly suspect that it would keep the addresses in the language of their location.

Re: source data language translation into English

Anonymous — Sat, 25 Nov 2017 10:44:39 GMT

What about web services like this:

https://cloud.google.com/translate/docs/samples

Re: source data language translation into English

Anonymous — Sun, 26 Nov 2017 05:56:14 GMT

Hi Rhall,

Thanks for the reply.

The address column which I mentioned in my query is an example. Let say some source systems from Japan, they saved the data in Japanese, we need to load this into target system in English. So as per my knowledge this is an expected scenario.

Could you please guide me to use Google API in Talend.

Thanks in advance.

Re: source data language translation into English

Anonymous — Sun, 26 Nov 2017 21:52:43 GMT

You will need to use REST services to do this. @lli has provided a link to the documentation. Using Google's APIs with Talend for the first time can be a bit tricky, but it is worth struggling through with it. Once you understand it, you will find using Google's APIs much easier. Come back here if you have specific questions about how to do this.

Re: source data language translation into English

Anonymous — Mon, 27 Nov 2017 06:23:03 GMT

Thanks Rhall!