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

TyeshaAdams's avatar
TyeshaAdams
New Contributor III
2 months ago

Need to send data from OneStream to Snowflake using an existing SIC ODBC connection

Hello,

What is the best way to send data from OneStream to Snowflake using an existing SIC ODBC connection?

Currently I am using SIC ODBC connection to query data from Snowflake and now I would like to send data back to Snowflake.

Data Integration

3 Replies

  • SimonHesford's avatar
    SimonHesford
    Contributor II
    2 months ago

    If the credentials for the SIC Gateway have permission to insert, update, and/or delete records in a remote dataSource, a OneStream business rule could be leveraged to write-back, update, and/or delete data as needed.

  • jayaleck's avatar
    jayaleck
    New Contributor III
    4 days ago

    Can you give a little more detail as to what you are trying to do? Built a solution that takes cube view data and write's it directly to snowflake, no flat files. Using a DM step, calls the extender rule to export the cv data, then calls the Smart Integration Function rule