topic Converting from one currency to another currency in Talend Studio

Converting from one currency to another currency

Anonymous — Thu, 25 Oct 2018 05:23:24 GMT

Good Morning ,

i am new to talend ,i am having an requirement on currency conversion.

Example : if our data in USD and need to convert to indian currency .

how can i deal this ,please guide me

Re: Converting from one currency to another currency

TRF — Thu, 25 Oct 2018 07:02:52 GMT

If you need real time currency rate, you have to call an external web service. You find many on Google. Else you need a table for each currency rates to be applied.

Re: Converting from one currency to another currency

TRF — Thu, 25 Oct 2018 17:28:46 GMT

@Ravivarma, did this help?
If so, thanks to mark your case as solved.
Kudos also accepted.

Re: Converting from one currency to another currency

Anonymous — Sat, 27 Oct 2018 09:54:15 GMT

I am new to talend ,the process your are explaining i am unable to understand

Re: Converting from one currency to another currency

Anonymous — Sat, 27 Oct 2018 17:12:52 GMT

Hi Ravi,

@TRF is right and you would require to use REST components of Talend for your requirement.

I believe you are looking for how to join the various components together for your use case. Could you please suggest whether the input flow is a batch file or a real time request since the solution methodology will be different from this point itself. I would suggest you to create a basic framework of your job based on your requirement and current understanding of Talend components. If you are stuck somewhere, please share your current jobs with screenshots of overall job flow and the component screenshots where you are facing issues.

As a starting point, my suggestion would be to go through the Talend basic training videos followed by a quick practice of batch file and REST components related scenarios from Talend Help document. This will automatically give you a fair idea about how to interconnect various components for your use case. If you are still stuck, please feel free to come back to forum and we all are here to help you 🙂

In this way, you will easily learn the various components of Talend and how to create jobs in Talend.

Warm Regards,

Nikhil Thampi

Re: Converting from one currency to another currency

sushantk19 — Tue, 24 Mar 2020 14:56:57 GMT

Hi,

I am also having the same issue, I need to extract the daily currency conversion rates from the below link; I am new to Talend as well, can you please share design of the ETL job and its configuration screenshots if possible?

Request: http://www.ecb.int/stats/eurofxref/eurofxref-daily.xml

Re: Converting from one currency to another currency

sushantk19 — Tue, 24 Mar 2020 16:29:10 GMT

here is the design of my Talend Job. It returns nothing in Body and returns 301 as error code.

currency_exchange_extract.png

Re: Converting from one currency to another currency

sushantk19 — Wed, 25 Mar 2020 08:04:35 GMT

@TRF - Can you check my design and guide me? I am kind of stuck here.