Skip to main content
KayneSchwarz
Community Admin
KayneSchwarzCommunity Admin
Community Admin
Mar 13, 2026 1:00 PM UTC

Tech Talks After Hours: SAP Integration via Smart Integration Connector

Getting started with SAP via SIC? Brian Dabrowski and Tom Linton take a deep dive into the code providing samples, questions to ask, and reference materials for connecting to SAP!

Key Topics Covered

  • Platform version context: demonstrated on OneStream 8.4 (latest at time of recording)
  • Read Table vs. Custom Function Modules: custom function modules are strongly preferred — processing data on the SAP side is more performant and requires less manipulation on the OneStream side
  • R3 connection object: the ERP Connect construct used to establish a connection to SAP, accepting host, user, password, system, language, and client parameters
  • Connection variants: basic connection, load balancer configuration, and encryption options depending on customer SAP environment requirements
  • Credential security: passwords and other sensitive values are stored in the SIC gateway as name-value pairs, not hardcoded in the business rule; retrieved at runtime via an API library call to the gateway
  • Custom function module structure: imports are parameters passed in (e.g., company code, period); exports are the data returned — ERP Connect reverses the typical import/export convention but the premise is the same
  • Executing a function module: passing required import parameters, executing the call, and receiving back a data table
  • Returning data to OneStream: the data table is passed back from the SAP rule and can be used in workflow processing or surfaced in a drill-back grid view
  • SIC relay architecture: all SAP communication flows through the gateway relay — OneStream never receives SAP credentials directly
  • Gateway error log troubleshooting: if integration errors don't surface on the OneStream side, check the hidden gateway service log at Program Data → OneStream Software → Gateway Service Log for detailed error information
  • Related resource: prior After Hours episode introducing the Smart Integration Connector (SIC) with Ryan Berry and the follow-on episode with Brian Dabrowski covering SIC setup

 

 

Terms & ConditionsAccessibility statement