Skip to main content
A
arunrajb
Newcomer
September 6, 2024

Export from OneStream to Databricks

  • September 6, 2024
  • 2 replies
  • 0 views

has anyone done data export from OneStream to Databricks? what is the best way or method to transfer data into databricks?

    2 replies

    T
    tschilling
    Newcomer
    September 6, 2024

    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.

      L
      LuckytoStream
      Newcomer
      September 27, 2024

      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

      T
      tschilling
      Newcomer
      September 27, 2024

      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.

      A
      arunrajbAuthor
      Newcomer
      September 6, 2024

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

      Terms & ConditionsAccessibility statement