Before Connect CDC, some Amway India data required a full day for data replication – now it’s available immediately
Amway India depends on both a custom-developed IBM i ERP application and a Microsoft SQL Server Windows-based e-commerce Suite. The two systems must share data, but keeping them in synch was a problem. Amway needed an automated, real-time data sharing solution.
E-commerce is an important component of Amway India’s growth strategy. Sales through this channel have increased to 31% of the company’s business in the past two years. Greater use of e-commerce promises to improve Amway India’s profitability because e-commerce lowers the cost of order processing (compared to traditional sales channels).
Data sharing between the ERP and e-commerce applications presented a problem for Amway. In the past, Amway India transferred data between the two systems at intervals that depended on the nature of the data.
Most bulk transfers were done at night to avoid impacting system performance during busy daytime hours. As a result, the e-commerce databases were out of date. While some data was 10 minutes behind the ERP, other data was a day or two old.