Tech Talks After Hours: Smart Integration Connector (SIC) - A Technical Perspective

Unlock the full potential of your data integration with OneStream’s Smart Integration Connector (SIC), a secure and scalable solution! Join Brian Dabrowski as he demystifies SIC setup, shares real-world efficiencies, and reveals how this powerful gateway transforms data access, governance, and automation for modern enterprises.

Key Topics Covered

• Smart Integration Connector (SIC) overview: a gateway component that enables OneStream to connect to internal or network-restricted data sources without requiring a VPN connection
• When SIC is required: data accessible only via VPN or special network, custom DLL libraries (such as ERP Connect by Theobald for SAP), special drivers (ODBC), or post/service file configurations
• Platform context: SIC becomes the primary connectivity method as customers move to the OneStream 8.0 environment
• SIC gateway architecture: a single on-premises installation on the customer's network that handles all communication with OneStream; sensitive artifacts and credentials remain on the customer's side
• Pre-8.0 vs. 8.0: previously, custom drivers and DLLs had to be installed on every OneStream device; the SIC gateway centralizes this to a single installation point
• ERP Connect (by Theobald Software): the most common method for accessing SAP data; the DLL must reside on the SIC gateway, enabling SAP RFC/BAPI calls from OneStream
• ODBC drivers: act as a translator between OneStream and the target system; used to connect to Oracle, data lakes, and other sources requiring a driver-based connection
• Data lake connectivity via ODBC: provides encryption for establishing the connection and allows SQL queries to retrieve data — eliminating the need for API token management
• Internal DNS configuration within SIC: allows the gateway to resolve internal hostnames that OneStream's cloud environment could not previously translate
• SAP FAGL FlexT data extraction: demonstrated using a data table read through ERP Connect to pull general ledger flexible data directly into OneStream stage
• Custom SAP function modules: ERP Connect supports specifying custom function modules with defined imports and exports, enabling extraction of virtually any SAP data structure
• Future episodes planned: SAP connector configuration deep dive, additional integration patterns — this session establishes the foundational concepts
• Related resource: prior Tech Talks After Hours episode on Smart Integration Connector with Ryan Berry