Product Catalog Integration For A Large Online Retailer

After conducting a detailed assessment of the client’s existing environment, VNB Consulting proposed a hub-and-spoke model for automating product catalog upload into Product Information System and eCommerce using Microsoft Middleware BizTalk Server. Our solution consisted of BizTalk Integration processes to pick up product feeds from designated partner portals, process the data, transform to canonical format and upload to PIM system to pick up and process further for final eCommerce upload. We utilized a methodical approach, which included: Leveraging BizTalk on Azure IaaS (Infrastructure as a Service) to save infrastructure cost and achieve higher scalability. A Site-to-Site VPN connection to access on-premise systems and leverage current investments. Support for multiple products feed formats like zip, excel, xml, text, x12 etc. Components to unzip, decode and parse the product feeds in various formats as well as handle large data files. A robust exception and error handling mechanism to help customer handle the problems and failures. BAM (Business Activity Monitoring) to track data import transactions status