Export from OneStream to Databricks
has anyone done data export from OneStream to Databricks? what is the best way or method to transfer data into databricks?
Forum Discussion
Yes - Very straightforward. We just had Databricks call the Onestream Rest API endpoint to get the data we needed.
On the reverse, you could write a business rule that pushes data to the DataBricks endpoint/s.
Hi tschilling,
Could you please help me with the sample script steps to implement the process? We have a requirement to send the data (Only Staging Data) into DataBricks from OneStream. But for now i have created Staging Data Export Business rule and exporting the data into files.
Best Regards
LuckytoStream
Are you looking to "push" the data to DataBricks from OS, or are you going to fire the process off from DataBricks? Both would work, but 2 very different approaches. Both have API endpoints you can use, lot of example code out there for both.
I got it, i want to push the data into DataBricks from Onestream. That to only Staging data.
Best Regards
LuckytoStreamA few options there but have used the DataBricks API endpoint/s in the past to post data/streams into DataBricks from an OS Business Rule and scheduled/triggered from a Data Management Sequence. Alternatively, there are several other methods to load data that would work as well.
Hi tschilling,
Can you please provide some sample scripts as requested below. i am also on same boat and need some guide to achieve it.
Thanks in advance
Sandeep
