Case Study: The Scoular Company achieves real-time AS400 data integration with Etlworks

The Scoular Company modernizes AS400 CDC with Etlworks for real-time Azure replication

The Scoular Company, a global agribusiness, needed to modernize its data integration from its IBM i (AS400) system to cloud platforms. Their challenge was replicating high-volume transactional data to Microsoft Azure in near real-time, capturing essential journal metadata, and handling scheduled system maintenance without data loss. After evaluating several tools, they selected the Etlworks platform for its deep support for IBM i environments and change data capture (CDC) capabilities.

Using Etlworks, Scoular implemented a high-performance CDC pipeline that streams both data and journal metadata from AS400 to multiple Azure destinations, including Azure SQL Server, Synapse Analytics, and Microsoft Fabric Warehouse. The solution provided by Etlworks automated the handling of system maintenance windows and ensured reliable performance under high transaction volume, enabling near real-time analytics and operational reporting while preparing for future expansion to event-driven integrations.

The Scoular Company