Requirements

OneStream Smart Integration Connector Environment Setup

  • Install compatible versions of the OneStream application and Smart Integration Connector Local Gateway Server. It is recommended to install matching versions of the applications.

    IMPORTANT: The Smart Integration Connector Local Gateway Server version 8.5 is not compatible with OneStream version 8.4 or earlier.

    • To install or upgrade OneStream to the latest version, see Setup and Installation.

    • To install or upgrade Smart Integration Connector Local Gateway Server to the latest version, see Upgrading Smart Integration Connector.htm. 

      NOTE: Although OneStream version 8.5 is designed to be compatible with Smart Integration Connector Local Gateway Server version 8.4, performance and functionality cannot be guaranteed. Upgrading to version 8.5 is recommended.

  • Work with your IT team to install the latest version of the Smart Integration Connector Local Gateway Server in an appropriate environment.

    • Windows Server 2019+

    • .NET Framework 4.8

    • 2 newer generation CPU cores (or equivalent virtual processors)

    • Memory (RAM)

      • Minimum 16GB for queries / jobs returning less than 1M / 3M rows or 1GB / 3GB of data respectively.

      • Minimum 32GB for queries / jobs returning less than 5M / 15M rows or 5GB / 15GB of data respectively.

      NOTE: Memory and processor requirements are driven by the frequency and volume of remote data accessed through the gateway service or if remote business rules / long running jobs are leveraged. For queries returning over 1 million records, 32 GB or more RAM is recommended.

    • The installer requires administrative permission on the server to perform the installation.

    • See Smart Integration Connector Local Gateway Server Installation.

  • Create a valid Gateway of type Database Connection to be used as the baseline communication between OneStream Cloud and the Smart Integration Connector Local Gateway Server. See Create a Database Connection for more information.

  • Be a OneStream administrator to configure corresponding data sources in the OneStream environment.

Advanced Networking and Whitelisting

It is a best practice to filter and/or whitelist network traffic for the Smart Integration Connector, you will need to work with your IT team to restrict this traffic. See Advanced Networking / Whitelisting for more information. For any additional questions, please reach out to Customer Support.