Forum Discussion

arunrajb's avatar
arunrajb
New Contributor III
4 months 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?

  • tschilling's avatar
    tschilling
    New Contributor III

    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
        New Contributor III

        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?