Coastal Pet Products – Umbraco/AS400 Integration

“Thank you for accomplishing in just 1 ½ weeks what was taking us months to figure out…..” – C Suite Leader at Coastal Pet Products

Background & Problem

Headquartered in Alliance, Ohio, Coastal Pet Products is a manufacturer of a vast array of collars, leashes and harnesses for pets. Coming to The Provato Group by way of one our trusted agency partners, Coastal Pet Products was faced with the difficult task of being able to access data from a legacy environment/database (AS400 DB2). The end game for accessing this data was so it could interface with a new website/database Microsoft Azure SQL on the Umbraco CMS platform in order to move data between the environments.

Solution & Results

The Provato Group was approached on a Friday morning with this problem, and by 4PM that same day had assembled a team of architects and developers to assess the issues within the environment. Within six business hours from original reach out, a project strategy and plan of attack were put into action.

The first task was to design an integrated solution to allow the two unlike environments to talk seamlessly using a technology called Azure Data Factory and Azure Blob Storage. A key component was using the right tool to assure the website would respond quickly for the best end user experience.

Within three weeks The Provato Group was able to design, build, test and deploy a solution that worked flawlessly. Provato’s solution came after 90+ days of the client attempting to build the integration within their own IT department. The result of our work allowed the customer to launch the new website on time and on budget.

leading partners clickhere