Forum Discussion

Tahir2061's avatar
Tahir2061
New Contributor III
4 years ago
Solved

Exporting Data automatically to outside of OneStream

HI I am trying to automate a data extract process to send data from OneStream to another system eg Anaplan. I have a data Mgmt job to Export the data to a CSV on the file share. I now want to move ...
Data Management
FileSystem
  • ChristianW's avatar
    ChristianW
    4 years ago

    If you are not afraid of Business rules, you should try to use the Fdx functions within BRAPI, they are creating a datatable object and they are retrieving the data very fast, they are all starting with

    BRApi.Import.Data.Fdx<Something>

     

     

Krishna's avatar
Krishna
Valued Contributor
4 years ago

You can extract the data through DM Base level or Consolidated Level based on POV and you can read the each row and either you can use RESTAPI to send it to the Target System. Yo have to pass the CSV output to JSON body so it can import into target system and another cool thing is you can also export to datatables.