Case Study: Andrews Sykes Group reduces ETL processing time with KingswaySoft

Andrews Sykes Group cuts ETL processing from 15 minutes to 90 seconds with KingswaySoft

Andrews Sykes Group, a company specializing in equipment hire and climate control, faced a challenge with an unreliable and unscalable legacy ETL process. Their mobile sales teams required real-time access to customer data, quotes, and contracts, but high data volumes during batch processing caused excessive runtimes of up to 15 hours. To address this, they turned to KingswaySoft and its SSIS Integration Toolkit for Dynamics 365.

KingswaySoft implemented a robust, scalable integration solution that was multi-threaded and took advantage of the ExecuteMultiple CRM class. The result was a dramatic reduction in data processing time, from over 15 minutes to just 90 seconds for regular daily runs. This empowered field sales teams with timely, accurate CRM data and significantly improved overall operational efficiency for Andrews Sykes Group.

Andrews Sykes Group