Forum Discussion
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 ...
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>
Are you on prem or in the cloud?
We are cloud for OneStream and need many different applications to consume the OneStream data. I set up automation to export to SQL Server so that we don't have to deal with the hassles of files. If you don't have an external SQLconnection, one would need to be set up. Next create a business rule with a query to get the data you want and write it to the SQL table. Set up a Data management step and sequence. Finally, create a OneStream Scheduled task to run the data management sequence for the daily/weekly/monthly schedule you want the process to run.
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
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.
Thanks that makes sense! Will have a play with the above ideas