Open Exchange Rates + clariBI
Connect Open Exchange Rates with your App ID, choose the currencies to track, and get daily exchange rates sitting next to the revenue and costs they move with.
Native Open Exchange Rates data-source connector.
Paste your Open Exchange Rates App ID, pick the currencies to track, and clariBI syncs their daily exchange-rate history into preprocessed datasets and auto-generated dashboards, right next to your other tools.
What is Open Exchange Rates?
Open Exchange Rates is a foreign-exchange-rates API that publishes daily reference rates for more than 170 currencies, relative to a base currency.
clariBI reads Open Exchange Rates through its REST API using your own App ID: the daily rate for each currency you choose, against the US dollar base. Access is read-only, and clariBI never changes anything in your account.
For each day in your chosen window, clariBI requests that day from the historical endpoint and records the rate, building a daily time series per currency.
Learn more at openexchangerates.org
Connect Open Exchange Rates in three steps
Open Data Sources in clariBI
In clariBI, go to Data Sources → Add Data Source, find Open Exchange Rates, and paste your App ID (free from openexchangerates.org). The App ID is Fernet-encrypted at rest.
Choose currencies and history
Type the target currencies to track (for example EUR, GBP, JPY) and choose how many days of history to pull. clariBI reads rates read-only.
Sync, then get dashboards
clariBI syncs the daily rates, preprocesses them, and builds an insights dashboard. Ask "How did EUR move against the dollar this quarter?" and the AI engine queries the synced rates alongside your revenue and costs.
What you can analyze
Out of the box with the Open Exchange Rates connector:
- Daily exchange rate per currency against the US dollar
- Rate trend and volatility over your chosen window
- Relative moves across the currencies you track
- Period-over-period change in a single currency
- Currency exposure lined up with billing dates
- Cross-source: FX moves → foreign revenue → reported margin
Open Exchange Rates is one of many data sources you can connect to clariBI. See the full list →
What gets synced
clariBI pulls daily exchange-rate history for the currencies you select through the Open Exchange Rates REST API, lands it as a preprocessed dataset, and refreshes it on your schedule. Access is read-only.
For each selected currency, clariBI syncs the daily rate against the US dollar base, then builds an insights dashboard you can query, extend, or pull into reports.
clariBI only ever reads. It never changes anything in your Open Exchange Rates account.
Cross-source questions Open Exchange Rates makes possible
Open Exchange Rates data is most useful next to your other tools. clariBI's planner composes it with your CRM, billing, and product data through the same entity-join primitives that back every cross-source analysis.
Open Exchange Rates × Revenue
"How much of our revenue swing was currency, not volume?"
Planner: read daily FX rates from Open Exchange Rates, align to foreign revenue by date, and split the change into rate versus volume.
Open Exchange Rates × Costs
"Did the exchange-rate move raise our supplier costs this month?"
Planner: read the rate for the supplier currency, join to purchase costs by date, and report the FX-driven cost delta.
Open Exchange Rates connector FAQ
What do I need to connect Open Exchange Rates?
A free App ID from openexchangerates.org. You paste it into clariBI once; it is Fernet-encrypted at rest, and there is no OAuth popup or app to register.
Can clariBI change anything in my account?
No. The connector only reads daily exchange-rate history for the currencies you select. It never changes anything in your account.
Which base currency does clariBI use?
The US dollar. The Open Exchange Rates free plan publishes rates relative to the US dollar, so each synced rate is the value of one US dollar in the currency you chose.
Which clariBI plan includes the Open Exchange Rates connector?
Data-source connectors are available on the Trial, Starter, Professional, and Enterprise plans. You can connect Open Exchange Rates during the free 14-day trial.
Start your free trial and connect Open Exchange Rates in a minute
App ID in, read-only, synced dashboards in seconds.
Start free trial