Forum Discussion

OS_Love's avatar
OS_Love
New Contributor III
17 days ago

Dashboard Integration

Hi, I have designed a dashboard using SQL adapter and have stitched multiple OS tables.Current ask is to integrate this dashboard data and sent it out to an external db.I can create a table in the e...
Data Integration
Data Sources
JoakimK's avatar
JoakimK
Contributor
6 days ago

So there are a couple of options here.

  • If you want to PUSH the data out of OneStream you have to determine if you want to:
    a) Push data as a data table into an external Database or
    b) Create a CSV file of the data to be pushed out to a file storage (SFTP, AWS S3, Azure Blob etc)
  • Or, if you can use your external system to PULL the data out of OneStream you can leverage the REST API to call that same DataAdapter to get all the data you need.

Some factors to determine which method other than the obvious ones of which process you would prefer, would be things such as how large the data set it, how frequent you need to do it etc.

For more in-depth discussion on your specific use case, I would recommend you submit a ticket to our support/Remote Consulting team to discuss.

Regards, Joakim