In many enterprises, legacy IBM i systems coexist alongside Windows‑based applications such as Microsoft Office, Excel dashboards, and CRM tools. Historically, bridging these environments has required heavy middleware, manual exports and imports, or separate databases - each introducing latency, duplication, and risk. The System Integration feature of the Sitemule Platform addresses this challenge by enabling direct and seamless connectivity between IBM i and Windows environments, allowing Microsoft Office applications and other software to interact with ERP data in real time without compromising system integrity.

Architecture and Core Design Principles

Architecture

The System Integration component is embedded within the Platform’s native runtime on IBM i, providing interface adapters that connect Windows and Microsoft Office applications directly to IBM i business logic and data. These adapters act as lightweight bridges that run within IBM i jobs and use native APIs or Open Access communication to exchange data. On the Windows side, Office add‑ins or Windows services use standard protocols (such as REST, OLE DB, or TCP/IP) to communicate with the IBM i bridge layer.

Design Rationale

The central design goal is to avoid duplication of business logic or data. By connecting Office or Windows apps directly to the ERP logic hosted on IBM i, the solution prevents version drift and eliminates separate synchronization layers. The Platform ensures that integrations remain within the trusted IBM i security domain and transactional integrity is preserved, rather than exporting data out of system control into separate silos.

"By keeping integrations inside IBM i, we eliminated middleware and regained control of our workflows."

Data Flow

When a user in Microsoft Excel selects “Refresh stock data”, the Office add‑in sends a REST or SOAP call to the Platform’s integration endpoint on IBM i. The runtime adapter invokes ILE programs or embedded SQL queries against Db2 for i, retrieves results, and streams them back to Excel in JSON or a table format. In parallel, if a user pastes a table in Word and triggers “Export to ERP”, the Platform adapter interprets the payload, maps each row to an RPG program or API endpoint, executes the transaction, logs the activity, and confirms changes - all in real time.

Integration within Sitemule Platform

Within the broader Sitemule Platform, the System Integration feature operates as a core infrastructure layer. It works alongside the Native IBM i Integration services to manage how cross‑platform calls are executed. When a module such as Architect generates a new web‑based data‑entry form, that form may automatically support “Export to Excel” or “Send to Word” features using the integration layer. The Hub module leverages the same bridges to expose ERP data to external partner portals or supplier systems running on Windows. These subsystems call into the shared integration engine, so all cross‑platform workflows live under consistent session, authorization, and logging contexts.

Technical Benefits and Performance

Performance

Since the integration layer executes within IBM i and uses native job scheduling and memory, the latency typical of external middleware is removed. Data transfers between Office applications and Db2 for i happen in milliseconds, enabling near‑interactive refreshes of large data sets or batch updates directly from Windows clients.

Scalability

The feature is capable of handling multiple concurrent sessions from Windows clients, Excel spreadsheets, Word documents, and web forms. It scales through job pools in IBM i and uses connection multiplexing to optimize throughput, making it suitable for hundreds or thousands of simultaneous integrations without degrading ERP response times.

"Our teams now update ERP orders from Word and Excel - securely, reliably, and without IT delays."

Maintainability

All integration mappings, data transformations, and endpoint configurations are managed through the Platform console rather than separate script libraries or middleware configurations. This allows your team to update connectors or Office templates without interrupting core ERP logic and promotes consistent governance. Each integration uses the same audit logging and version‑control mechanisms already established in the Platform, simplifying support and compliance.

Compatibility and Interoperability

The System Integration feature supports a wide variety of environments and technologies. On the IBM i side, it works with Db2 for i, embedded SQL in RPG or COBOL, ILE service programs, and remote job calls. On the Windows side, it supports Microsoft Excel, Word, PowerPoint add‑ins, OLE DB connections, REST/JSON endpoints, and even legacy COM interfaces. For example, a CRM running on Windows can call a REST endpoint exposed by the Platform integration layer to retrieve customer credit status from ILE logic. On the Excel side, a stand‑alone macro can query ERP sales‑order status in real time via JSON. Because all integration uses standard protocols and the bridge lives within IBM i, you avoid separate ETL layers, file‑drops, or external replication - thus reducing compliance and data‑integrity risk.

Real‑World Usage

A regional distributor operated a legacy IBM i ERP system for inventory, orders, and shipping, while their sales team worked in Microsoft Office on Windows. Salespeople often exported raw inventory files from IBM i, manipulated them in Excel, then re‑entered data manually - introducing errors and delays. By deploying Sitemule Platform’s System Integration feature, the distributor implemented a live Excel template that connected directly to IBM i inventory tables. Sales input quantities in Excel, hit “Update ERP”, and the change posted directly via the integration layer into IBM i logic with full audit logs. The implementation took days and required zero middleware servers. Inventory errors dropped by 85 % and turnaround time for quoting improved by 60 %.

"We connected Excel directly to IBM i logic - no scripts, no exports, just live ERP data in seconds."

Related Features and Internal Links

The System Integration layer complements the Native IBM i Integration feature by ensuring all execution stays within IBM i even when using Windows clients. It also aligns with the Monitoring & Alerting module, enabling integration workflows to trigger alerts when mapped Office‑based operations fail or exceed thresholds.

By bridging IBM i and Windows environments through direct, no‑middleware integration, the Sitemule Platform’s System Integration feature enables enterprises to unify Office applications, ERP logic, and native IBM i data into one consistent ecosystem. You gain real‑time connectivity, reduce duplication and risk, and increase operational speed - all while preserving your core architecture.