Skip to main content
Newcomer
April 16, 2026
Question

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

  • April 16, 2026
  • 2 replies
  • 0 views

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.

2 replies

Newcomer
April 17, 2026

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.

Newcomer
April 22, 2026

SimonHesford​  Thank you!  Would you happen to have any business rule examples?

Newcomer
June 19, 2026

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