Forum Discussion

OS_Love's avatar
OS_Love
New Contributor III
2 months 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 external db reflecting the same column structure.

What is an efficient way to integrate this data from OS dashboard to external db-FYI- I have SIC in place.

Thanks for your time

Data Integration
Data Sources
  • JoakimK's avatar
    JoakimK
    Contributor
    2 months 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