Options to send data from OneStream to another system?
What are all the options to send data from OneStream to another system? In my use case, we would be pushing People Planning data from OneStream to Workday.
Thanks for any assistance!
Forum Discussion
Hi aricgresko
You are mentioning PUSHING data to other system, so the "how" to do it depends mainly on the other system (technology used, security...).
To keep it simple, lets assume you are other server has public access, you could use its push api or you could write directly to its SQL server or any other databases. OneStream can do all that.
I would take another approach and ask the client how he wants OneStream to connect to its server.
Hope it helps a bit 🙂Hey Nic - that is helpful info there.
I saw a post from a few years ago Solved: Exporting Data automatically to outside of OneStream - OneStream Community (onestreamsoftware.com) discussing similarly to what I was asking above. I was hoping to expand the solution presented and see a comprehensive list of ways to push data to another system. This is a little outside my skillset, so maybe this question cannot really be summarized in a list.
Good to hear! Do you know now how to send the data to the client server? What is he expecting?
In the link you send us, it is probably pushed with an SFTP as it seems to be a file. Christian is showing how to extract data from OS using FDX. The question is now, once the data is accessible/retrievable in OS, what is expected on the other server?
Do you think you will send a flat file? How does the client wants to consume this information?
That is what I was trying to point in my previous post. I hope I was not too unclear 🙂
Keep us posted!
