Case Study: Better Bathrooms centralizes API data with KingswaySoft SSIS Productivity Pack

Better Bathrooms streamlines multi-API data integration using KingswaySoft

Better Bathrooms, a UK-based independent bathroom retailer, needed a solution to efficiently centralize business data that was dispersed across numerous third-party online marketplaces and review sites. Their existing method was unable to handle APIs, especially those providing data in JSON format, creating a significant challenge. They turned to KingswaySoft to leverage their SSIS expertise with the vendor's SSIS Productivity Pack.

The solution from KingswaySoft utilized HTTP and OAuth Token Managers alongside JSON and XML source components to connect to and process data from various complex APIs. This enabled Better Bathrooms to successfully integrate data from platforms like eBay, Amazon, TrustPilot, and their shipping provider directly into their SQL Server. By using KingswaySoft’s solution, they significantly reduced development time and gained the flexibility to easily add more API integrations in the future.

Better Bathrooms

Philip Schonewille

Head of Systems