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's avatar
Sibi_S
New Contributor
11 months ago

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...
Data Integration
Data Management
Sibi_S's avatar
Sibi_S
New Contributor
11 months ago

We have included the below points which is need to be done in this process.

  1. We would like to extract the Transformation details for Account, Entity and Product (UD dimension) dimensions from OneStream to Snowflake.
  2. Daily once to start with and we might require an hourly refresh
  3. Metadata and cube data for key reported developed in Snowflake (Not all dimensions required)
  4. 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

  • tschilling's avatar
    tschilling
    Contributor
    11 months ago

    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.