FX rates delivered automatically
Eliminating any need for manual input, our solution serves foreign exchange rates directly to the client’s Vena tenant on a set schedule.
Data integrity guaranteed
Data Quality Reports are fully customisable and can detect unexpected variance in the incoming data so users can be confident in the numbers they're reporting
Dynamic design
Fully adaptable to the clients needs including alternative source and destination systems and calculated custom fields
Challenge
Our multinational clients require foreign exchange rates as part of their regular valuation and forecasting efforts and wanted to automate the process of integrating those rates to eliminate the need for manual input and ensure data quality.
Solution
The FX Rates solution we built combined standard features of the Datablend iPaaS platform as well as some custom scripting and transformations which enable seamless data integration between the foreign exchange rate provider and Vena. Taking things a step further, by standardising the structure of data passed between different elements of the workflow, we minimised the amount of additional configuration necessary to add custom fields, currencies, quality checks, or dimensions. We can even substitute the source and destination systems when onboarding new clients with little additional effort.
Results
With our fully automated process, users can feel confident that their rates are delivered before they even log in on the first of the month. There’s no longer any concern if the owner of this process is on holiday, leaves the company, or is simply too busy with more important work to attend to the tedious task of gathering and uploading rates. The rates are there, ready to be reported on, and on top of that, users will have a detailed report in their inbox relaying the results of any data quality checks as well as the overall success of the process.