Connect Open Exchange Rates to 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.
clariBI| Connection | API connector. You paste your Open Exchange Rates App ID. |
| Access | Read-only. clariBI never writes to Open Exchange Rates. |
| Sync | When the data is more than a day old, clariBI syncs it again before a question, dashboard refresh or report uses it. You can also press Sync now. |
| More endpoints | 4 documented Open Exchange Rates endpoints you can add, up to 30 per source (trial, Starter and above) |
| Plans | Every plan, including Free. Asking questions in plain English needs the trial or Starter and above. |
About 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.
Vendor site: openexchangerates.org
What clariBI syncs
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 once it is more than a day old. 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.
What you can chart
- 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
How to connect Open Exchange Rates
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 stored encrypted.
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 clariBI reads the synced rates alongside your revenue and costs.
Questions you can ask
Asking in plain English uses AI credits, so it needs the trial or a Starter, Professional or Enterprise plan. Totals and trends are computed from the synced rows; the AI plans the question, picks the chart and writes the explanation.
- "How much of our revenue swing was currency, not volume?"
- "Did the exchange-rate move raise our supplier costs this month?"
About the Open Exchange Rates connector
What do I need to connect Open Exchange Rates?
A free App ID from openexchangerates.org. You paste it into clariBI once; it is stored encrypted, 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 plans include Open Exchange Rates?
Every plan can connect Open Exchange Rates, within its data source limit: 3 on Free, 5 on Lite, 10 on Starter, 50 on Professional and 100 on Enterprise. Each source gets an automatic dashboard on every plan. Asking questions in plain English, AI reports and adding endpoints from the Open Exchange Rates catalog need the trial or a Starter, Professional or Enterprise plan.
Try Open Exchange Rates in clariBI
The trial lasts 14 days, includes 50 AI credits and needs no card. When it ends, your account moves to the Free plan and keeps its data and dashboards.