Skip to main content
K
Kamila
February 26, 2025
Solved

How to get FX rate from different source?

  • February 26, 2025
  • 2 replies
  • 1 view

I have the request to automate FX rates upload. Rates are stored in DWH (Data warehouse) and that would be easy if I could simply connect there. Unfortunately DWH team doesn't allow it, instead of it they can push their FX rates into my database. Any idea how can I get them such access?

Thanks!

Best answer by DanielWillis

Assuming you're in the cloud I believe your only option for someone to push something from another system into OneStream is via the REST API 'Data Management Execute Sequence/Step' endpoint.

You can either push data in via parameters of the DM sequence or have the execution of the the sequence trigger OS to go and fetch data from somewhere (not exactly a push, more like a poke!).

2 replies

D
DanielWillisAnswer
Employee
February 26, 2025

Assuming you're in the cloud I believe your only option for someone to push something from another system into OneStream is via the REST API 'Data Management Execute Sequence/Step' endpoint.

You can either push data in via parameters of the DM sequence or have the execution of the the sequence trigger OS to go and fetch data from somewhere (not exactly a push, more like a poke!).

K
KamilaAuthor
February 27, 2025

Thanks Daniel! I already took another approach with consuming the file with FX rates published by another team. 

C
chris_rothermel
February 27, 2025

Have you seen the OpenPlace Solution called "FX Rates Manager"?  I've used it and it was surprisingly easy to load FX Rates into OneStream from either the Central European Bank or the Federal Reserve.  That would obviate the need for your own Data Warehouse but reviewing this solution may give you some ideas on how to automate the loading of FX Rates.

 

K
KamilaAuthor
February 28, 2025

This is very helpful, thank you Chris! I have already chosen the approach with reading the file with FX files that is available on shared location. I am using WINSCP libraries for it. However thank you once again!

C
chris_rothermel
February 28, 2025

Excellent.  I like WINSCP very much but am not familiar with the libraries.  Sounds like something new to learn.

Terms & ConditionsAccessibility statement