Currency Exchange Rates

Renta exports daily currency exchange rates to your data warehouse: a table with one row per date and a column for every currency you track. All rates are quoted against a single base currency of your choice, so each row shows what one unit of the base was worth in each of those currencies on that day.

The list covers over 150 currencies. The table is partitioned by date and grows incrementally: scheduled runs add new days without re-fetching the history.

Connect the source

The source requires no credentials. You name the connection and pick the data provider, and Renta requests the rates itself.

Create a pipeline

Once the source is connected, create a pipeline to load exchange rates into your destination.

Pipeline configuration

On the final step, choose the currencies and set the loading options.

Base currency

Select the currency all rates will be quoted against.

The dropdown lists each currency with its name and ISO code, and the search field filters the list. The default is United States Dollar.

Target currencies

Check the currencies whose rates will land in the destination table.

Each selected currency becomes a column named by its ISO code (EUR, GBP, JPY), and the date column is added automatically. To track everything, click Select All. The Selected tab collects your current set.

The base currency itself is absent from the list: its rate to itself is always 1. Every value in a currency column is the number of units of that currency per one unit of the base on the row's date.

Supported currencies

Renta loads exchange rates for the following currencies.

Table name

Name the pipeline and the destination table.

1. Integration name.
   The name of the pipeline. It is used exclusively in the Renta interface.
2. Table name.
   The destination table name. You can keep the auto-generated name or enter your own.

Date range

Set the historical period to load.

1. Date start.
   The first date of the extraction period.
2. Date end.
   The last date of the extraction period. Leave it as Today to keep collecting fresh rates on every run.

Schedule

Choose how often the pipeline runs.

For the Daily schedule, pick the Update time (the exact hour each run starts) and click Create pipeline. The source provides one rate per day, so a Daily schedule is enough to keep the table current.

The new pipeline appears in the Pipelines section under the ETL tab. Its row shows the run progress and the destination table name.

Sync strategy

The table below describes how Renta synchronizes the exchange rates.