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

MZ's avatar
MZ
New Contributor III
1 year ago

Outbound Files through SIC Using UNC

Need some ideas on how to out bound files from OS shared folders to a network driver using UNC through SIC (we are upgrading to 8.2 from 7.3). We have SFTP through SIC works already, however, this specific process cannot be replaced by SFTP at this time. I have seen discussions and recommendation about inbounding through SIC only.

Extenders

5 Replies

  • atalecki's avatar
    atalecki
    Icon for OneStream Employee rankOneStream Employee
    1 year ago

    I have been able to take a file from the OneStream fileshare and transfer it to an on-prem file share.  Remote SIC business rules are required for this.  I converted the file to a KeyValuePair(Of String, Byte()), and added a key value pair parameter to the SIC remote business rule.

    Inside of the remote SIC function, I then used the File.WriteAllBytes("filePath", byte()) function to write the file to fileserver share.  

    • MZ's avatar
      MZ
      New Contributor III
      1 year ago

      Thanks! We got some helps from OneStream remote consulting. The final solution is similar to what you mentioned that compressed data bytes passed over the SIF function as an argument.

  • seangly's avatar
    seangly
    New Contributor III
    1 year ago

    Hi MZ and Atalecki,

    Do mind sharing the SIC Function script?

    Regards

    • seangly's avatar
      seangly
      New Contributor III
      1 year ago

      I was able to develop that script, I ma just wondering if you are using any compressing data to make it lighter to transfer to the gateway server?

      • atalecki's avatar
        atalecki
        Icon for OneStream Employee rankOneStream Employee
        1 year ago

        Compression was not needed in my case since the file was too small for that to have a major impact.