The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
Sibi_S
11 months agoNew Contributor
Automating Data Access from OneStream to Snowflake: Exporting Financial and Master Data
How to configure the OneStream system to push the transaction and master data (dimensions) to Snowflake without manual intervention?
I need step-by-step Info how to pull data from Snowflake into On...
Sibi_S
11 months agoNew Contributor
We have included the below points which is need to be done in this process.
- We would like to extract the Transformation details for Account, Entity and Product (UD dimension) dimensions from OneStream to Snowflake.
- Daily once to start with and we might require an hourly refresh
- Metadata and cube data for key reported developed in Snowflake (Not all dimensions required)
- Csv is preferable. However, we would like to understand if this can be extracted directly from OneStream using any other ETL tools like Azure Data Factory, Five Tran etc.
Regards, Sibi S
- tschilling11 months agoContributor
Check out the OneStream REST API Guide. Very Simple to setup a REST call from any ETL Tool to extract data without needing flat files.
Related Content
- 12 days ago
- 4 months ago