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>

     

     

Tahir2061's avatar
Tahir2061
New Contributor III
4 years ago

HI Scott

Many thanks for replying! We are on the Cloud. We have a connection to SQL for my Bi Blend job which spits out data to a View table. 

One question - what do you use the DM for in this process?

Thanks

Tahir

scottr's avatar
scottr
New Contributor III
4 years ago

The data management sequence is needed in order to use the task scheduler to run the export each day/week/month.  The DM sequence calls a DM step which runs a business rule.  the business rule contains the logic to pull the data out of the cubes/BIBlend and replicate the data out of onestream's database into our internal database server.

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

    Thanks that makes sense! Will have a play with the above ideas