Revision History

Updated for release features, including the following enhancements:

• Remote BR support for datasets that contain more than one datatable.

• Support for SQL Table Editor write-backs to SQL Server without needing additional BRs.

• Automatically create long running job processes using single BRAPI.

Updated for release features, including the following enhancements:

• Removed WinSCP from the SIC Local Gateway Installer. Best practice is to use SSH.NET for SFTP transfers. See Support for SFTP.

• Revised phrasing of "Database Connection" to "Gateway Connection" and adjusted related gateway terms to align with new user interface and tooltips.

• Update Connection icons for Gateway Connections and Direct Connections.

• Split "Use Smart Integration Connector" subheadings into separate sections for improved document navigation.

• Move the following settings to Application Data Settings:

  • "Allow Remote Code Execution"

  • "Web API Bind Port"

Updated for release features, including the following enhancements:

• Load Balanced Gateway Servers support queries over 1 million rows and Smart Integration Functions that query for long running jobs.

• Enhanced debugging capabilities of Smart Integration Functions / Remote Business Rules.

• Smart Integration Functions / Remote Business Rules support returning more than 1 million rows by default.

Updated for release features, including the following enhancements:

• Added ability to mask and encrypt Configuration Parameter Values.

• Connection strings greater than 245 characters now will encrypt.

• Removed redundant copying of DLLs in the "Referenced Assembly" folder upon service startup.

• Version number is now displayed in the title bar.

• Added Frequently Asked Questions to the documentation. See Frequently Asked Questions.

CAUTION: Smart Integration Connector version 8.4 is required when running OneStream version 8.4.

Updated for release features, including the following enhancements:

• Improved performance and reliability of multi-threaded / parallel processing for larger payloads.

• Streamlined process of setting up a redundant Gateway Server.

• The active Gateway Server is now displayed within the Gateway Setup in the Windows App.

• For Remote Business Rules, the number of rows returned per query threshold has increased to 5M / 5GB of data.

• Added ability to check if the gateway is online via a BRAPI.

Updated for release features, including the following enhancements:

• Query results that contain NULL values are now being returned.

• Added ability to mask the password when creating a database connection string.

• Queries that run longer than 10 minutes will consistently return data.

• Improved the reliability of multi-threaded connections.

• Smart Integration Connector Local Gateway Configuration Utility will automatically open the configuration file for non-default install locations.

• DataTable / Datasets can now be sent via a Remote Business Rule.

Updated to add WebAPI examples.

Updated for release features, including the following enhancements:

• Customers can test their Smart Integration Connector Gateways during set-up to ensure there is nothing blocking port 443.

• The default Referenced Assemblies folder is in C:\Program Files\OneStream Software\OneStream Gateway\Referenced Assemblies.

• The database connection strings in the OneStream Local Gateway Configuration are encrypted when saved.

• Specific IPs or CIDRs (a range of IPs) can be whitelisted from the OneStream Windows Client Application.

• The OneStream Local Gateway Configuration utility automatically opens the configuration file for the user.