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

Better Bathrooms reduces API integration development time with KingswaySoft

Better Bathrooms, a UK-based independent bathroom retailer, needed to gather data from multiple external platforms like eBay, Amazon, and Zendesk for their internal SQL Server. Their challenge was dealing with new and regularly changing APIs, particularly those providing data in JSON format, which their previous tool could not effectively parse. KingswaySoft's SSIS Productivity Pack was selected to solve this integration challenge.

The KingswaySoft solution enabled Better Bathrooms to use their existing SSIS skills for fast integration. Components like the HTTP Connection Manager and OAuth Token Manager simplified token handling, while the JSON and XML source components parsed the data for SQL Server loading. This cut development time significantly and improved data visibility, allowing the team to integrate with numerous APIs in a timely fashion for their data warehouse.

Better Bathrooms