Forum Discussion

arunrajb's avatar
arunrajb
New Contributor III
2 years ago

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?

8 Replies

  • 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.

    • LuckytoStream's avatar
      LuckytoStream
      New Contributor

      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

      • tschilling's avatar
        tschilling
        Contributor

        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.

  • arunrajb's avatar
    arunrajb
    New Contributor III

    hi tschilling, is it possible to have a call with you to understand this process?