Skip to main content
arunrajb
Member
Sep 6, 2024 12:47 PM UTC

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

    tschilling
    Member
    Sep 6, 2024 12:52 PM UTC

    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
      Newcomer
      Sep 27, 2024 11:34 AM UTC

      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
      Member
      Sep 27, 2024 11:37 AM UTC

      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.

      arunrajbAuthor
      Member
      Sep 6, 2024 12:58 PM UTC

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

      Terms & ConditionsAccessibility statement